KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Following query returns a number of people having the same name with gender = Male. select lookup_name.firstname,count(lookup_name.firstname) from lookup_name where gender='M' group by firstname similarly, the query below returns a number of people having the same name with gender = Female. select lookup_name.firstname,count(lookup_name.firstname) from lookup_name where gender='F' group by firstname I need to write a query which finds out the name and tell the gender (whether male or female) with the greater count. i.e higher probability of that name in the database is of being male or female?
Tags (comma-separated)
Save Edits
Cancel