segunadeleye
commented
7 years ago - https://github.com/damilola-dealdey/SQL-Track/blob/master/Ex5/answers.sql#L9 If there are more than one city with the maximum number of respondents, your query will still return one row.
- https://github.com/damilola-dealdey/SQL-Track/blob/master/Ex5/answers.sql#L9 https://github.com/damilola-dealdey/SQL-Track/blob/master/Ex5/answers.sql#L28 Use the proper convention.
- https://github.com/damilola-dealdey/SQL-Track/blob/master/Ex5/answers.sql#L17 https://github.com/damilola-dealdey/SQL-Track/blob/master/Ex5/answers.sql#L21 Use alias
- https://github.com/damilola-dealdey/SQL-Track/blob/master/Ex5/answers.sql#L21
There is no need for
DISTINCTwhen you are usingGROUP BY
damilola-dealdey
https://github.com/damilola-dealdey/SQL-Track/tree/master/Ex5
We ran a campaign on a website, asking people to submit their email address, their city and phone number. The data was collected in a csv format - The file is here... http://dl.dropbox.com/u/628209/exercises/mysql/email_subscribers.txt First import this csv data into a mysql database. From the database, we need to find the following information by writing a single SQL statement for each; What all cities did people respond from How many people responded from each city Which city were the maximum respondents from? What all email domains did people respond from ? Which is the most popular email domain among the respondents ?