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 4 months, 2 weeks agoSagnikcap
Most Recent 2 months, 2 weeks agojimboslims
6 months, 1 week agorenshoo_shimasho
6 months ago