Question

Write a sql query to get state-wise count of customers with ascending order of state

Answer 1

select COUNT(ID) state from <Table Name> Group by state;

Answer 2

SQL QUERY:

      create a table a customer with details of the customers in the table. insert the value for the table.

      query for the given question

   select count(state), country from customer order by state

The condition for the question

1) Count the state-wise of customer

2) Arrange the state into the ascending order.

   In the given query State will be count by using the count method and the sate is arranged in ascending order by using the order by

To Learn More...

brainly.in/question/4661528