Question

h) Write commands in SQL for (i) to (iv) and output for (v) and (vi).
Table : Store
4
Storeld Name Location City NoOlEmpDate Open Sales Amt
S101 | Planet Fashion Bandra Mumbai17 2015-10-161 40000
S102 | Vogue Karol Bagh Delhi 8 1 2015-07-14 1200001
S103 Trends | Powai Mumbai 10 2015-06-24 30000
S104 SuperFashion Thane Mumbai 11 2015-02-06 | 45000
S105 | Annabelle South Extn. Delhi 18 2015-04-09 600001
S106 Rage Defence Colony Delhi 15 2015-03-01 | 20000
To display names of stores along with SalesAmount of those stores that
have fashion anywhere in their store names
() To display Stores names. Location and Date Of Open of stores that
were opened before 1st March, 2015.
(it) To display name and location of those store which have either vas
second character in their name
(iv) To display the City and the number of stores located in that City, only
number of stores is more than 2
(v) Select Min(Date Open) from Store:
(vi) Select Count(Storeid). Noofemp From Store Group By Noofemp
Having Max(Salesamt)<60000​

Answer 1

B and friends have a lot of good news on