ANelson82

my_var = "Hello World, today is a nice day"

print(f"{my_var}")

ANelson82

with cte1 as (
        select 
              quantile_cont(amount, [.01, .10, .25, .5, .75, .9, .99]) as p
            , min(amount) as min
            , max(amount) as max
            , mode(amount) as mode
            , (select count(amount) from MY_TABLE where amount = 0) as zeroes_cnt
            , (select count(amount) from MY_TABLE where amount is null) as null_cnt
            , (select count(amount) from MY_TABLE) as total_cnt
         from MY_TABLE)