Write SQL commands for following customer table: CustomerID Cust_Name Age Address Order_amount 101 Alex 35 Paris 200 102 James 28 London 340 103 Paul 30 Paris 440 104 Allene 32 Rome 566 105 Kate 29 Beijing 225 1. Write a query to create a customer table containing above columns, whereas customer id as primary key. 2. Write a query to insert multiple records into customer table. 3. Write a query to list name of customers having age between 20 to 30. 4. Write a query to list name of customers who either belong to Paris, London or Beijing order by name and age. 5. Write a query to show list of customers whose name ends with character ‘E’. 6. Write a query to display name of city that are not repeating itself. 7. Write a query to display max age of customers city wise. 8. Write a query to find number of customers belong to Paris and their total order amount. 9. Write a query for each city with more than one customer, find number of customers in each city and show average order amount order by customer ID. 10. Write a query to find 2nd highest order amount from customer table along with customer name.
Write SQL commands for following customer table:
CustomerID Cust_Name Age Address Order_amount
101 Alex 35 Paris 200
102 James 28 London 340
103 Paul 30 Paris 440
104 Allene 32 Rome 566
105 Kate 29 Beijing 225
1. Write a query to create a customer table containing above columns, whereas customer id
as primary key.
2. Write a query to insert multiple records into customer table.
3. Write a query to list name of customers having age between 20 to 30.
4. Write a query to list name of customers who either belong to Paris, London or Beijing
order by name and age.
5. Write a query to show list of customers whose name ends with character ‘E’.
6. Write a query to display name of city that are not repeating itself.
7. Write a query to display max age of customers city wise.
8. Write a query to find number of customers belong to Paris and their total order amount.
9. Write a query for each city with more than one customer, find number of customers in
each city and show average order amount order by customer ID.
10. Write a query to find 2nd highest order amount from customer table along with customer
name.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
