LEARNING MADE EASY: SQL PRACTICE QUESTIONS FOR TABLE STORE

(i) To display name, location, city, SalesAmount of stores in descending order of SalesAmount.

(ii) To display names of stores along with SalesAmount of those store s that have ‘fashion’ anywhere in their store names.

(iii) To display Stores names, Location and Date Opened of stores that were opened before 1st March, 2015.

(iv)To display total SalesAmount of each city along with city name.

(v) To display total no. of stores in each city

(vi) To display id, name and location of city delhi and mumbai

(vii) To display store details in ascending order of sales amount.

(viii) To display store details in ascending order of city and descending order of sales amount.

(ix) To display name and location of stores in ascending order of no. of employees.

(x) To display name, location, no. of employees who opened in 2016.

WRITE THE OUTPUT OF THE FOLLOWING QUERIES:-

1) SELECT STOREID, NAME FROM STORE WHERE CITY NOT IN ('DELHI','MUMBAI');

2) SELECT STOREID,CITY FROM STORE WHERE NOOFEMP>10;

3) SELECT NAME, LOCATION FROM STORE WHERE SALESAMOUNT >400000 ORDER BY DATEOPENED;

4) SELECT MAX(DATEOPENED), MIN(DATEOPENED) FROM STORE WHERE NOOFEMP<10;

5) SELECT AVG(SALESAMOUNT) FROM STORE GROUP BY CITY;

LEARNING MADE EASY