Write a query to find bookname, totalquantity(Price*Qty) from table BOOKS

(a)  

To display the details of the books in descending order of their price

(a)  

Write a query to print first four letters of author name concatenated with last four letters of book name

(a)  

Write a query to print Book name and Quantity Issued from table Issues

(a)  

Change the structure of the table Issues such that it has dateofissue with default value 01-Jan-2020

(a)  

Write a query to print all books which start with letter 'S'

(a)  

Write a query to find number of distinct publishers from table faculty

(a)  

Write a query to print the name of faculty who is the oldest in the organisation

(a)  

Write a query to print the course names being taught by Amit Mishra

(a)  

Write a query to print all faculties which were hired in Year 2004

(a)  

Modify the table faculty such that salary of each faculty is increased by 18%

(a)  

Make F_ID as the primary key in table faculty

(a)  

Write the query to find the course which is most expensive

(a)