MySQL Query help

Question

I'm not very good at database queries. Need help with what is probably a simple query.

Database: MYSQL

zipcodes [table]

zip | city | state

post [table]

post_id | title | post | zip

I need to display the number of posts for each unique city.

Answer 1

SELECT count(*) FROM post LEFT JOIN zipcodes ON post.zip = zipcodes.zip GROUP BY city;