I’m going thru CODE CHALLENGE: AGGREGATE FUNCTIONS: # Code Challenge 1
And just playing around, I’m trying to use CASE statement inside of COUNT to see how can I get the same result as when I use just WHERE.
I got 697 results by using this code:
WHERE email LIKE ‘%.com’;
And 1000 results by using this:
WHEN email LIKE ‘%.com’ THEN 1 ELSE 0 END)
Would appreciate it if you can point me to the mistake