Question

42.
(5)
where Qty_store>150;
Write SQL queries for (a) to (e) based on the table Supplier given below.
Suppno Suppname
Status City
Otysupp
Si
Brittania
Delhi
10
S2
Mother Diary
Mumbai
Nirula's
Delhi
20
S4
Haldiram
Bangalore 40
Bikaner
Jaipur
30
20
S3
S5
(a) Display the different types of status from the supplier table.
Display all the supplier names sorted by quantity supplied in descending order.
Display the details of all supplier whose supplier name starts with “B'.
To change the city of Brittania Supplier name from Delhi to Kolkata.
To delete the details of Supplier whose city is Bangalore.
*** *** ** ***
CS QP_Set_1_Page 14​

Answer 1

Answer:

SELECT Status FROM Supplier;

SELECT SuppName FROM Supplier ORDER BY qtySupp DESC;

SELECT * FROM Supplier WHERE SuppName LIKE 'B%';

UPDATE Supplier SET City='Kolkata' WHERE SuppName='Britannia';

DELETE FROM Supplier WHERE City='Banglore';