Write SQL commands for the following on the basis of given table (a) Select all the PROG type published by BPB from Library.

Q. Write SQL commands for the following on the basis of given table :

(a) Select all the PROG type published by BPB from Library.

(b) Display a list of all books with Price more then 130 and sorted by Qty.

(c) Display all the books sorted by Price in ascending order.

Answer  =

(a)
Select * from library
Where type = ‘PROG’ AND pub = ‘BPB’ ;

(b)
Select title from library
Where price >130
Order by Qty;

(c)
Select title from  library
Order by price ;