Skip to main content

Return to Answer

added 2 characters in body
Source Link
MatBailie
MatBailie
  • 87.5k
  • 19
  • 112
  • 144

Try this query -

SELECT COUNT(IF(gender = 'M', User_id, NULL)) males, COUNT(IF(gender = 'F', User_id, NULL)) females FROM User

Try this query -

SELECT COUNT(IF(gender = 'M', User_id, NULL) males, COUNT(IF(gender = 'F', User_id, NULL) females FROM User

Try this query -

SELECT COUNT(IF(gender = 'M', User_id, NULL)) males, COUNT(IF(gender = 'F', User_id, NULL)) females FROM User
Source Link
Devart
Devart
  • 119.6k
  • 23
  • 172
  • 189

Try this query -

SELECT COUNT(IF(gender = 'M', User_id, NULL) males, COUNT(IF(gender = 'F', User_id, NULL) females FROM User