Beginner ~12 min

SQL Basics

Core SQL fundamentals: SELECT, WHERE, JOIN, GROUP BY, and aggregates.

Progress: 0/10

Beginner • ~12 min

Q1. Which SQL clause is used to filter rows returned by a SELECT query?

Select one answer • 1 pt

HAVING ORDER BY GROUP BY WHERE

Q2. Which keyword returns only unique rows?

Select one answer • 1 pt

DISTINCT ONLY UNIQUE SINGLE

Q3. What does COUNT(*) return?

Select one answer • 1 pt

The number of rows returned The number of non-NULL values in a column The number of tables in the database The sum of all numeric columns

Q4. Which JOIN returns all rows from the left table and matching rows from the right table?

Select one answer • 1 pt

RIGHT JOIN LEFT JOIN CROSS JOIN INNER JOIN

Q5. Which clause is used to sort results?

Select one answer • 1 pt

GROUP BY ARRANGE SORT BY ORDER BY

Q6. Which statement adds a new row to a table?

Select one answer • 1 pt

APPEND ADD ROW INSERT INTO UPDATE

Q7. What is the purpose of GROUP BY?

Select one answer • 1 pt

To rename columns in results To group rows for aggregate calculations To sort rows alphabetically To filter rows before SELECT

Q8. Which clause filters groups after GROUP BY?

Select one answer • 1 pt

LIMIT FROM HAVING WHERE

Q9. Which keyword limits the number of rows returned in MySQL?

Select one answer • 1 pt

FETCH TOP TAKE LIMIT

Q10. What does an INNER JOIN return?

Select one answer • 1 pt

All rows from both tables regardless of match Only matching rows from both tables No rows unless NULLs exist All rows from the left table

Cancel