Question

Write commands in SQL for (i) to (ii) and output for . 2.10 (0)
Table : Store
Storeld Name
Location City NovEmn DacOpen SalesAmt
S101
Planet Fashion Bandra
Miniba
7
2015-10-16
40000
S102 Vogue
Karol Bagh
Delhi
2015-07-14
120000
S103 Trends
Powai
Mumbai
10
2015-24
30000
S104 Super Fashion Thane
Mumbai
11
2015-02-06
15000
S105 Annabelle
South Extn.
Delhi
2015-04-09
60000
S106 Rage
Defence Colony Delhi
n
2015-03-01
20000
(1) To display names of stores along with Sales Amount of those stores that are
located in Mumbai.
(i) To display the details of store in alphabetical order of name.
(m) To display the City and the number of stores located in that City, only if
number of stores is more than 2.
(IV) SELECT MIN(DATEOPEN) FROM STORE,
(V) SELECT COUNT(STOREID). NOOFEMP FROM STORE GROUP BY
NOOFEMP HAVING MAX(SALESAMT)-50000​

Answer 1

Answer:

marja gandhe ke kute

Explanation:

Nikal peli fursat mein