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

WHERE GROUP BY HAVING ORDER BY

Q2. Which keyword returns only unique rows?

Select one answer • 1 pt

SINGLE ONLY DISTINCT UNIQUE

Q3. What does COUNT(*) return?

Select one answer • 1 pt

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

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

Select one answer • 1 pt

INNER JOIN CROSS JOIN RIGHT JOIN LEFT JOIN

Q5. Which clause is used to sort results?

Select one answer • 1 pt

SORT BY ORDER 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 sort rows alphabetically To filter rows before SELECT To rename columns in results To group rows for aggregate calculations

Q8. Which clause filters groups after GROUP BY?

Select one answer • 1 pt

FROM HAVING WHERE LIMIT

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

Select one answer • 1 pt

FETCH TOP LIMIT TAKE

Q10. What does an INNER JOIN return?

Select one answer • 1 pt

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

Cancel