Given the BOOKS table below, write a nested SQL query to obtain the books that retail for a price greater than the average retail price of books in every category. Your query should list the book title, retail price, and category. The results must be presented in ascending order of the book category. [Hint: you need to find the average retail price per book category] BOOK Table ISBN TITLE PUBDATE PUBID COST RETAIL CATEGORY  

[THIS IS A BONUS QUESTION] — Will add up to 4 points to the Final Exam and up to 1% to your Course Total Given the below ER diagram for a criminal database: Write an SQL query that lists the names of all criminals and the police officers who charged them with crimes between Jan 1st, 2021 to jan 1st, 2023.  

Given the below ER diagram for a criminal database: Write an SQL query that lists the names of all criminals who were never charged with a crime charge ID = 3751.  Write your assumptions (if needed).

El sol es muy fuerte allí. 11. _________ eso antes de ir a la playa tenemos que llevar parasol.

One complaint in “The Declaration of Independence” is that the ______ has “plundered our seas, ravaged our coasts, burnt our towns.”

What are the three main parts of “The Declaration of Independence”?

Colombia es más seguro que antes, pero es mejor __________________________ (tener / ser) cuidado.

Ayer Enrique y yo pasamos 3. _________ la agencia de viajes

What Enlightenment idea is shown in the belief that governments must get their power from the people?

Vamos a estar allí 2. _________ siete días.