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 GROUP BY ORDER BY WHERE

Q2. Which keyword returns only unique rows?

Select one answer • 1 pt

DISTINCT UNIQUE ONLY 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 sum of all numeric columns The number of tables in the database

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

Select one answer • 1 pt

CROSS JOIN INNER JOIN RIGHT JOIN LEFT JOIN

Q5. Which clause is used to sort results?

Select one answer • 1 pt

ORDER BY SORT BY GROUP BY ARRANGE

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

Select one answer • 1 pt

UPDATE APPEND INSERT INTO ADD ROW

Q7. What is the purpose of GROUP BY?

Select one answer • 1 pt

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

Q8. Which clause filters groups after GROUP BY?

Select one answer • 1 pt

FROM HAVING LIMIT WHERE

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

Select one answer • 1 pt

TAKE FETCH LIMIT TOP

Q10. What does an INNER JOIN return?

Select one answer • 1 pt

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

Cancel