Image by Kevin Ku

DATABASE MANAGEMENT

February 20, 2018

I was tasked with writing the proper SQL statements to solve the questions posed by the professor within the given database. The assignment description, along with the questions, can be found below:

Using the library database:

1. What is the join statement that would show you all books with their related formats?

2. What is the join statement that would show all books and their authors last names sorted Z-A?

3. What is the join statement that would give the author's first name, last name, book title, and format?

4. What is the join statement that would give authors who have a last name starting with v and their book titles, titles sorted Z-A?

 

©2019 by Gabriel E. Bailey. Proudly created with Wix.com