This quiz will test your understanding of how to retrieve data from MySQL databases using the SELECT statement. You will explore key concepts such as selecting specific columns, using wildcards, filtering results with LIMIT and OFFSET, eliminating duplicates with DISTINCT, sorting with ORDER BY, and applying aggregate functions like SUM(), AVG(), and COUNT().
By completing this quiz, you will reinforce your knowledge of essential SQL queries that help efficiently extract and manipulate data from MySQL tables.
1.
Which function is used to calculate the average of column values?
2.
Which keyword is used to limit the number of rows returned by a SELECT query?
3.
What is the correct syntax to retrieve multiple columns from a table?
4.
Which function calculates the total sum of values in a column?
5.
What is an alternative way to use LIMIT with OFFSET?
6.
How can you retrieve only the first two rows from a table?
7.
Which wildcard symbol is used in a SELECT statement to retrieve all columns from a table?
8.
Which function returns the highest value in a column?
9.
What does the COUNT() function return?
10.
Which clause is used to sort query results?
11.
Which SQL function returns the lowest value in a column?
12.
What is the primary purpose of the SELECT statement in MySQL?
13.
What does the following query return?
SELECT DISTINCT description FROM product;
14.
How can you retrieve a single column from a table using the SELECT statement?
15.
How do you sort query results in descending order?
16.
Which keyword is used to group query results based on a column value?
17.
Which keyword is used to remove duplicate values from a SELECT query result?
18.
Which SQL keyword allows renaming a column in a query result?
19.
What does the following query do?
SELECT name, SUM(price * quantity) AS total FROM product GROUP BY name ORDER BY total;
20.
What does the OFFSET keyword do in a SELECT statement?
