Answers for "how to count and use a where in sql"

sql count where

SELECT count(CASE WHEN gender = 'F' THEN 1 ELSE NULL END) women_count,
       count(CASE WHEN gender = 'M' THEN 1 ELSE NULL END) men_count
FROM people;

Posted by: Guest on April-21-2021

Code answers related to "how to count and use a where in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to count and use a where in sql"

Code answers related to "how to count and use a where in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to count and use a where in sql"

Code answers related to "how to count and use a where in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us