15. [SQL Week 1 Question 100-015] What is the lightest weight of any of the creatures who is taller

than 60 inches?

16. [SQL Week 1 Question 100-016] How many creatures are of type Human?

17. [SQL Week 1 Question 100-017] Get the average weight of all human type creatures. Note your

answer to four decimal places.

18. [SQL Week 1 Question 100-018] Your newest novel has a scene in which all the miscreants are

on a bridge, but collectively they are too heavy for it so the bridge fails. It's very exciting for

your audience. What is the sum of the weight of all the miscreants here? We define miscreants

here as Pirates, Supervillains, Mad Scientists, and Cowboys of any gender.

19. [SQL Week 1 Question 100-019] You are going to have a scene in which all the basilisks are on

one side of a balance scale, and the single smallest dinosaur is on the other side of the scale.

The dinosaur is bigger, of course. By how many pounds? (It's OK if you need to run two

separate queries and then manually subtract them.)

20. [SQL Week 1 Question 100-020] Use the LIKE command to select the idLitCharacters, name, and

creature subtype of all the creatures which start with MER (i.e. mermen, mermaids, etc.). Sort it

alphabetically by name.

21. [SQL Week 1 Question 100-021] What is the average weight of all creatures for which the name

contains the string 'us'? The phrase can be anywhere in the name - so "Usman" would count,

as would "Beusaleth" and "McManus." (Your database may vary; these names may or may not

be in your version of the database.) Note your answer to four decimal places.

22. [SQL Week 1 Question 100-022] Select all the fields for all the creatures that contain the word

"the" in their names, such as "Roderick the Brave." Do not include entries for which "The" is the

first word, such as "The Fire Breather." Order alphabetically by Name, then ascending by

idLitCharacters.

23. [SQL Week 1 Question 100-023] List all creatures which have two consecutive L's anywhere in

their name (such as "Elling" or "Llewers" or "Dingell") and which are not Knights. Sort by

number of appearances (fewest appearances on top) and then ascending by idLitCharacters.

24. [SQL Week 1 Question 100-024] Use the SQL IN command to select all fields from all creatures

which are Knights, Pirates, Fairies, or Jackalopes and who have had 1 or more appearances to

date. Sort it by idLitCharacters, this time in DESCENDING order, so the highest ID is on the top.

Use the SQL LIMIT command to display only 10 results.

How many of each type were in your top 10 results?