The sql check online quiz uses the same numbering system given here
UMGC IFSM 330 Assignment Mythical Creatures II
This assumes you have worked through the SQL commands referenced in the weekly tutorial(s) and you have prepared the SQLiteonline.com environment (see the Setting_Up_SQLiteonline_com.docx for instructions).
You must complete the quiz AND submit a complete Word document with SQL queries and screenshots to receive credit for this assignment.
Remember, you can always reach out for help to your instructor if your SQL is not behaving for
you.
| Page 1 | |||
|---|---|---|---|
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|||
 |
|
||
Give an answer to the question based only on what you see in your SQLite database. (Do not use Excel or other tools to answer these questions; since we are trying to learn SQLite here, you should do these exercises in SQLite.)
You will eventually submit this document as part of your week’s assignment.
| |
|
|---|
SubType for all the pirates, mermaids, and fairies. Only include these three Subtypes. Order by ascending idLitCharacters.
[SQL Week 2 Question 100-009] You want to get some name ideas for somebody who is either a mad scientist or supervillain. What are those names? Print out the Lit Character ID as well as the name and Sub Type. Order by ascending idLitCharacters.
 |
Page 4 |
|---|
[SQL Week 2 Question 100-011] Select the idLitCharacters, name, Gender, Creature SubType.
Your newest author wants a specific list of names which meet one of two criteria. The first criteria to meet would be a female pirate. The second criteria to meet would be any cute tiny male creature of weight 10 or below. Your output should contain some female pirates and some cute tiny male creatures. Sort the results first alphabetically on Gender and then within that field by idLitCharacters ascending.
 |
Page 5 |
|---|
[SQL Week 2 Question 100-013] You want the big ones. Make a list of all the ID, the name, the Creature SubType, and weight and height. You only want those whose weight is greater than or equal to 150 or those whose height is greater than or equal to 65. Sort your results
alphabetically by Name and then ascending by idLitCharacter.
 |
Page 7 |
|---|
[SQL Week 2 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.) 7126
 |
|
Page 9 |
|---|
[SQL Week 2 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.
 |
Page 11 |
|---|
[SQL Week 2 Question 100-025] You want something small and cute. How many creatures have a height between 10 and 15 inches and a weight between 5 and 10 pounds? (Hint: you should use the BETWEEN command)
 |
Page 13 |
|---|
answer some other questions after you do this command, be sure you refresh your
database (i.e. re-load and re-run the script which made the database in the first place)
| |
|---|
going to go back and answer some other questions after you do this command, be sure you
refresh your database (i.e. re-load and re-run the script which made the database in the first
