Find the total number of customers from each country in the table (customer ID, customer Name, country) using group by

 

In this post, we are going to Find the total number of customers from each country in the table (customer ID, customer Name, country) using group by in "MySQL". This project is given by CBSE in term II Practical File.

Here is the code:

select country,count(*) "TOTAL CUSTOMER" from customer group by counrty;