snowsql cloud credits per querry

credits.sql

select 
    LEFT(query_text,300),USER_NAME, COUNT(LEFT(query_text,300)) as COUNT_QUERIES, SUM(CREDITS_USED_CLOUD_SERVICES)
from SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY as jb
where start_time  between '2023-04-27' and '2023-04-28'
GROUP BY LEFT(query_text,300), USER_NAME
order by 3 desc nulls last LIMIT 100;