SQL Data Analyst Quiz

What SQL clause is used to filter the results of a query when querying the Quizizz database for specific games?

• GROUP BY

• ORDER BY

• WHERE

• HAVING

Tags

DOK Level 1: Recall

Which SQL function is used to count the number of rows in a database table, such as the 'Game' table in Quizizz?

• COUNT()

• SUM()

• AVG()

• MAX()

Tags

DOK Level 1: Recall

How would you select all the columns from a table named "Game" where the "Status" is "Active"?

• SELECT * FROM Game WHERE Status='Active';

• SELECT * FROM Game HAVING Status='Active';

• SELECT Status FROM Game WHERE Status='Active';

• SELECT Status='Active' FROM Game;

Tags

DOK Level 2: Skill/Concept

If you want to sort the results of your game by the "Score" column in descending order, which SQL clause should you use?

• ORDER BY Score asc;

• ORDER BY Score desc;

• GROUP BY Score desc;

• SORT BY Score desc;

Tags

DOK Level 2: Skill/Concept

How can you join two tables, "Quiz" and "Game", to match each quiz with the game's information, assuming the common column is "QuizID"?

• SELECT * FROM Quiz JOIN Game ON Quiz.QuizID = Game.QuizID;

• SELECT * FROM Quiz, Game WHERE Quiz.QuizID = Game.QuizID;

• SELECT * FROM Quiz UNION Game;

• SELECT * FROM Quiz CROSS JOIN Game ON Quiz.QuizID = Game.QuizID;

Tags

DOK Level 2: Skill/Concept

Write a SQL query to find the total number of games played per quiz from the "Game" table, which includes columns "GameID", "QuizID", and "PlayedDate". You need to group the results by "QuizID".

• SELECT QuizID, COUNT(GameID) FROM Game GROUP BY QuizID;

• SELECT PlayedDate, COUNT(GameID) FROM Game ORDER BY PlayedDate;

• SELECT COUNT(GameID), QuizID FROM Game GROUP BY PlayedDate;

• SELECT QuizID, SUM(GameID) FROM Game GROUP BY QuizID;

Tags

DOK Level 3: Strategic Thinking

How would you modify a table named "Quiz" to add a column "HostEmail" with the data type VARCHAR(255)?

• ALTER TABLE Quiz ADD COLUMN HostEmail VARCHAR(255);

• UPDATE TABLE Quiz ADD HostEmail VARCHAR(255);

• INSERT INTO Quiz (HostEmail) VALUES (VARCHAR(255));

• MODIFY TABLE Quiz ADD HostEmail VARCHAR(255);

Tags

DOK Level 2: Skill/Concept

Given a table "Quiz" with columns "ID", "Title", "CreatorID", and "SubjectID", and another table "Game" with columns "GameID" and "QuizID", write a SQL query to find all quizzes that have been hosted as a game.

• SELECT Quiz.Title FROM Quiz JOIN Game ON Quiz.ID = Game.QuizID;

• SELECT Title FROM Quiz WHERE ID IN (SELECT QuizID FROM Game);

• SELECT Title FROM Quiz, Game WHERE Quiz.ID = Game.QuizID;

• All of the above are correct.

Tags

DOK Level 3: Strategic Thinking

Imagine you have a table "Game" with columns "GameID", "GameName", and "Score". You need to find the third highest "Score" in the table. Which SQL query would you use?

• SELECT TOP 1 Score FROM (SELECT DISTINCT TOP 3 Score FROM Game ORDER BY Score DESC) AS temp ORDER BY Score ASC;

• SELECT MIN(Score) FROM (SELECT TOP 3 Score FROM Game ORDER BY Score DESC) AS temp;

• SELECT Score FROM Game GROUP BY Score ORDER BY Score DESC LIMIT 2, 1;

• SELECT DISTINCT Score FROM Game ORDER BY Score DESC LIMIT 2, 1;

Tags

DOK Level 3: Strategic Thinking

You are tasked with designing a database schema for a new Quizizz-like application. The application needs to track quizzes, questions within those quizzes, and the games that are instances of quizzes being played. Describe the tables you would create, including key columns and how they would relate to each other to support these requirements.

• Create tables for Quizzes (QuizID, QuizName), Questions (QuestionID, QuestionText, QuizID), Games (GameID, QuizID, DateTime), and a junction table GameQuestions (GameID, QuestionID) to relate questions to games.

• Create a single table with columns for QuizID, QuizName, QuestionID, QuestionText, and GameID.

• Create two tables: Quizzes (QuizID, QuizName, GameID) and Questions (QuestionID, QuestionText, QuizID, GameID).

• Create tables for Quizzes (QuizID, QuizName), Questions (QuestionID, QuestionText), and Games (GameID, QuizID, DateTime, QuestionID).

Tags

DOK Level 4: Extended Thinking