Question

1. Write a query that will list all the books with a book cost of greater than $120. Display the book_title, book_year, book_subject, and book_cost. 2. How many books are currently checked out? Write a query that will display the number. Display the column heading as "# Books Checked Out"

Answer 1

1. SELECT Book_Title, Book_Year, Book_Subject, Book_Cost FROM BOOK WHERE Book_Cost >120; 2. SELECT COUNT(Check_Num) AS '# Books Checked Out' FROM CHECKOUT WHERE Check_In_Date IS NULL;

Step-by-step explanation:

SQL or structured query language is a database communication tools used to facilitate database operation.

The BOOK table is queried to return four columns while the books checked out returns a result with a alias header.