Write SQL commands for (i) to (vi) on the basis of relations given below:

Table: BOOKS

Book_ID	Book_name	Author_name	Publishers	Price	Type	qty
K0001	Let us C	Y. Kanetkar	EPB	450	Prog	15
P0001	Computer Networks	B. Agarwal	FIRST PUBL	755	Comp	24
M0001	Mastering C++	K.R. Venugopal	EPB	165	Prog	60
N0002	VC++ advance	P. Purohit	TDH	250	Prog	45
K0002	Programming with Python	Sanjeev	FIRST PUBL	350	Prog	30
L02	Computer Science with Python	Sumita Arora	Dhanpat rai	655	Prog	16
L04	Computer Science with Python	Preeti Arora	Sultan chand	550	Prog	20
L05	Concise Mathematics	R.K.Bansal	Selina	600	Maths	10

Table: ISSUED

Book_ID	Qty_Issued
L02	13
L04	5
L05	21

(i) To show the books of "FIRST PUBL" Publishers written by P.Purohit.

(ii) To display cost of all the books published for FIRST PUBL.

(iii) Depreciate the price of all books of EPB publishers by 5%.

(iv) To display the bookname and price of the books, more than 3 copies of which have been issued.

(v) To show total cost of books of each type.

(vi) To show the details of the costliest book.

(i)

SELECT BOOK_NAME
FROM BOOKS
WHERE PUBLISHERS = "FIRST PUBL" AND AUTHOR_NAME = "P.PUROHIT";

There is no output produced because there are no books published by "FIRST PUBL" and written by "P.Purohit" in the table BOOKS.

(ii)

SELECT SUM(Price * qty) AS Cost
FROM BOOKS
WHERE Publishers = 'FIRST PUBL'
GROUP BY publishers;

+-------+
| Cost  |
+-------+
| 28620 |
+-------+

(iii)

UPDATE BOOKS 
SET Price = Price - (Price * 5/100)  
WHERE Publishers = 'EPB';

(iv)

SELECT b.Book_name, b.Price
FROM BOOKS b, ISSUED i 
WHERE b.Book_ID = i.Book_ID and i.Qty_Issued > 3;

+------------------------------+-------+
| Book_name                    | Price |
+------------------------------+-------+
| Computer Science with python |   655 |
| Computer Science with python |   550 |
| Concise Mathematics          |   600 |
+------------------------------+-------+

(v)

SELECT Type, SUM(Price * qty) AS Total_Cost
FROM BOOKS
GROUP BY Type;

+-------+------------+
| Type  | Total_Cost |
+-------+------------+
| Prog  |      59070 |
| Maths |       6000 |
| Comp  |      18120 |
+-------+------------+

(vi)

SELECT *
FROM BOOKS
WHERE Price = (SELECT MAX(Price) FROM BOOKS);

+---------+-------------------+-------------+------------+-------+------+-----+
| book_id | book_name         | author_name | publishers | price | type | qty |
+---------+-------------------+-------------+------------+-------+------+-----+
| P001    | Computer Networks | B.Agarwal   | FIRST PUBL |   755 | Comp |  24 |
+---------+-------------------+-------------+------------+-------+------+-----+