How i will generate a list of Countries with number of individual and company customers
Write a single SQL statement to generate a list of countries with the number of individual customers and company customers. The query should have 3 columns named Country, Individuals and Companies. The column Country includes all the countries from the Customer table. The column Individuals and Companies display the number of individual customers and the number of company customers respectively in each country. A company customer is defined by the existence of a company name in the Customer table. If a country does not have any associated company customers, 0 will be displayed in the column Companies for that particular row. Sort the result of the query by the column Country in accending order. Please Help me fast. I am Stuck here.