CITD 120 -- SQL Concepts (50 points)

You will be using the Questions Tables provided by the Online Emulator site(http://citw.lcc.edu/~sperlt/citd120/index.php)(with log on ID: Justinomundi. and passwd: dog_lemon. These Tables are not in your textbook. Be sure to review these Tables to understand the data held in the dataset. The Questions Tables contains much less data than would be normally found in a Database of quizzes. This dataset has been made smaller to make it easier for you to check your SELECT statements to retrieve correct data.

Using the SQL Emulator prepare SQL statements to perform the following tasks. Each task is worth 5 points. For all tasks show a screenshot of what the emulator provided (i.e., The Red Box).

Tasks:

1. Retrieve a list of unique dates when questions were modified.
2. Display the number of topics that have less than three Class Sessions.
3. What is the average question difficulty?
4. How many quizzes did less than 10 students pass?
5. List the question text that contains the word pot.
6. List the title of the topics that have questions with difficulty level 1.
7. List the quiz number and date of quizzes having a low score less than the average low score.
8. List the question id and topic id of questions not having a difficulty level assigned.
9. For each quiz show the quiz number and the average high score. Only include the quizzes that had more than 10 students.
10. List the quiz number and the total number of students passing for quizzes taken by more than 75 students.