Consider the following sample database. Figure 1: ERD for Library Database Given the following sample data, you will see that certain tables are linked via

Consider the following sample database.

Given the following sample data, you will see that certain tables are linked via primary and foreign keys (e.g., Client and Borrower: ClientId is on both tables).

Write the following SQL statements to retrieve data:

Select all borrowers

Select all books borrowed by borrowers, order by borrow date

Select all books and include the author first and last name

Insert a new client with an occupation of pilot

Note that your queries will not return data, unless you would like to create and set up a functioning database.