Scribd
Upload
20 views2 pages

A4SQL

The document contains 6 problems asking to write SQL queries to retrieve data from library database tables including member and book information as well as fine details.

Uploaded by

Ayush Bansal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
20 views2 pages

A4SQL

The document contains 6 problems asking to write SQL queries to retrieve data from library database tables including member and book information as well as fine details.

Uploaded by

Ayush Bansal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

ASSIGNMENT-4

Problem # 1: Write a query to display the member id, member name of the
members, book code and book title of the books taken by them.

Problem # 2: Write a query to display the total number of books available in


the library with alias name “NO_OF_BOOKS_AVAILABLE” (Which is not
issued

Problem # 3: Write a query to display the member id, member name, fine
range and fine amount of the members whose fine amount is less than 100.
Problem # 5: Write a query to display the book code, book title and rack
number of the books which are placed in rack 'A1' and sort by book title in
ascending order.

Problem # 6: Write a query to display the member id, member name, due
date and date returned of the members who has returned the books after
the due date. Hint: Date_return is due date and Date_returned is actual
book return date.

You might also like