Items Sales ID _Name Price Supplier SID S Date CID Ketchup 1 2012-5-23 1. 50 Block Factory 2012-5-24 2 Unique Manufacturer S&S 2 Salt 40 4 2016-4-23 3 2016-2-12 4 Soap 30 6 2016-1-10 International 4...


Items<br>Sales<br>ID<br>_Name<br>Price<br>Supplier<br>SID<br>S Date<br>CID<br>Ketchup<br>1<br>2012-5-23<br>1.<br>50<br>Block Factory<br>2012-5-24<br>2<br>Unique<br>Manufacturer<br>S&S<br>2<br>Salt<br>40<br>4<br>2016-4-23<br>3<br>2016-2-12<br>4<br>Soap<br>30<br>6<br>2016-1-10<br>International<br>4<br>Toothpaste<br>33<br>Brothers<br>Enterprise<br>General<br>5<br>Sugar<br>20<br>Bill<br>Traders<br>6.<br>Detergent<br>34<br>Alibaba<br>SID<br>ID<br>Express<br>2<br>1<br>3<br>Customer<br>4<br>CID<br>Name<br>2<br>1<br>City<br>Lahore<br>Peshawar<br>2<br>4<br>Aqib<br>Suleman<br>2<br>2<br>Sahiwal<br>Peshawar<br>2<br>Nadeem<br>Sarim<br>4<br>4<br>Sohail<br>Peshawar<br>4<br>3<br>6<br>Nadir<br>Okara<br>4<br>2<br>4<br>4<br>Peshawar<br>Lahore<br>Nasir<br>Kamal<br>U sing the Schem a - data/statistics Can follow ing queries be executed on above relations<br>or not.lf not then justify with reason.<br>1) (Select ID, I_Name from item s where I_Name like '% a % ') Unio n (Select Nam e,CID from<br>Customer)<br>2)(Select * fro m items where P rice > 20) In tersect (Select * from Customer)<br>3)Select * from Customer inner jo in Sales wh ere City='Lahore' and Custom er.CID=Sales.CID<br>4) Select distin ct Name, City from Custom er<br>5) In sert into Sales values (3,'2016-2-12',4)<br>

Extracted text: Items Sales ID _Name Price Supplier SID S Date CID Ketchup 1 2012-5-23 1. 50 Block Factory 2012-5-24 2 Unique Manufacturer S&S 2 Salt 40 4 2016-4-23 3 2016-2-12 4 Soap 30 6 2016-1-10 International 4 Toothpaste 33 Brothers Enterprise General 5 Sugar 20 Bill Traders 6. Detergent 34 Alibaba SID ID Express 2 1 3 Customer 4 CID Name 2 1 City Lahore Peshawar 2 4 Aqib Suleman 2 2 Sahiwal Peshawar 2 Nadeem Sarim 4 4 Sohail Peshawar 4 3 6 Nadir Okara 4 2 4 4 Peshawar Lahore Nasir Kamal U sing the Schem a - data/statistics Can follow ing queries be executed on above relations or not.lf not then justify with reason. 1) (Select ID, I_Name from item s where I_Name like '% a % ') Unio n (Select Nam e,CID from Customer) 2)(Select * fro m items where P rice > 20) In tersect (Select * from Customer) 3)Select * from Customer inner jo in Sales wh ere City='Lahore' and Custom er.CID=Sales.CID 4) Select distin ct Name, City from Custom er 5) In sert into Sales values (3,'2016-2-12',4)

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here