Question

Rahul, who works as a database designer, has developed a database for a bookshop. This database includes a table BOOK whose column (attribute) names are mentioned below:

BCODE: Shows the unique code for each book.

TITLE: Indicates the book’s title.

AUTHOR: Specifies the author’s name.

PRICE: Lists the cost of the book.

I. Write SQL query to display book titles in lowercase. 

II. Write SQL query to display the highest price among the books. 

III. Write SQL query to display the number of characters in each book title. 

IV. Write SQL query to display the Book Code and Price sorted by Price in descending order.

Answer 1

I. SELECT LOWER(TITLE) FROM BOOK;

II. SELECT MAX(PRICE) FROM BOOK;

III. SELECT LENGTH(TITLE) FROM BOOK;

IV. SELECT BCODE, PRICE FROM BOOK ORDER BY PRICE DESC;