Question

7) Write commands in SQL for 1 to Ge) and output for (x) and (vi). Table: Store Storied Name Location City Noofemp Dateopen salesant S101 Planet Bandra Mumbai 7 2015-10-16 40000 S102 Vogue Karol Bagh Delhi 8 2015-07-14 120000 S103 2015-06-24 30000 S104 Trends Powa Mumbai 10 Superfashion Thane Mumbai 11 Annabelle South Ext Delhi 8 2015-02-06 45000 S105 2015-04-09 60000 S106 trends Delhi 5 2015-03-01 20000 Defence Colony To display names of stores along with SalesAmount of those stores that have `fashion' anywhere in their store names. (1)To display Stores names Location and DateOfOpen of stores that were opened before 1st March 2015 (i) To display name and location of those store which have either *u' as second character in their name Dutta's screen ity and the number of stores located in that City only if number `​

Answer 1

Answer:

shsshfsufdjsdhdjfjdfjsfdhfdfjdhsfh