How to get total number of users per city by using SQL Query

I have to tables (User table and City Table)

User Table:
Column: Userid, username, package, cityid

City Table:
Column: CityID, Cityname etc

I want to display total number of users per city. For Example

  1. London 1000
  2. Newyork 2000
  3. California 2500

    etc


Source: sql

Leave a Reply