Create the SQL that would generate a list of

Question

Create the SQL that would generate a list of cities and a count of the number of vendors within each city. Order the data by city in ascending order.

Anonymous · Answer

SELECT syudad.city, count(vendor.city)
FROM syudad INNER JOIN vendor ON syudad.City = vendor.city group by syudad.city;

Create the SQL that would generate a list of cities and a count of the number of vendors within each city. Order the data by city in ascending order.