SQL Queries Practice & Solutions

Solve following queries using aggregate functions for the table. Table: sales (orderID OrderDate OrderPrice OrderQuantity CustomerName) 1.Count how many orders have made a customer with customer name of Smith. 2.Find the number of unique customers that have ordered from the store. 3.Find out total no. of items ordered by all the customers. 4.Find out the … Continue reading SQL Queries Practice & Solutions

Advertisements