Identify how the count_if function and the count where x is null can be used
Consider a table random_values with below data.
What would be the output of below query?
select count_if(col > 1) as count_a. count(*) as count_b.count(col1) as count_c from random_values col1
0
1
2
NULL -
2
3
MultiCloudIronMan
Highly Voted 3 months, 3 weeks agoSagnikcap
Most Recent 1 month, 3 weeks agojimboslims
5 months, 3 weeks agorenshoo_shimasho
5 months, 1 week ago