$(1$pt$)$ Using the WHERE clause, write a query that will return the book authors firstname and

lastname and the book titles they authored. To complete this query, you'll need to join the

books table, the bookauthor table, and the author table. Remember to use column qualifiers

and table aliases

$(1$ pt$)$ Complete the same query above except this time, complete using the Join using method.

$(1\mathrm{.}5$ pt$)$ Using either the WHERE clause or JOIN USING techniques, List all criminals along with

the crime charges filled. The report need to include the criminal ID$,$ Name, Crime, and fine

amount. This query will require that you join criminals, crimes, and crime charges tables

$(1\mathrm{.}5$ pt$)$ List all criminals along with crime status and appeal status $($if applicable$).$ The reports

need to include the criminal ID$,$ name, crime classification, date charged, appeal filing date, and

appeal status. Show all criminals, regardless of whether they have filed an appeal. $($this is a

hint to add an outer join condition $())$