Scribd
Upload
11 views2 pages

Task C Refresh

Uploaded by

kalitalareworld2020
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views2 pages

Task C Refresh

Uploaded by

kalitalareworld2020
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

TASK C

C1 :- List thePartsID’s of all parts containing “plastic”.

Select partsID from Parts where Description=”plastic”;

Output

C2:- Find the names of suppliers who supply parts of red color and costing less than$200

Select [Link] from suppliers,parts,catalogue where [Link]=”red” and


[Link]<200 and [Link]=[Link] and [Link]=[Link];

Output
C3:-What is the price of the lowest costing part in Melbourne?

Select min([Link]) from catalogue, suppliers where [Link] =[Link]


and [Link]=”Kolkata”;

Output

C4:-Find the SupplierID’s of suppliers who either supply some red part or who are in NSW.

Select [Link] from suppliers,parts,catalogue where


[Link]=[Link] and [Link]=[Link] and [Link]=”red” and
[Link]=”nsw”;

Output

You might also like