SQL practiceSQL SELECT Practice
SELECT is the first SQL command most learners need to master. Practice choosing columns, reading result sets, and writing clear beginner queries.
SELECT practice builds the foundation for every later SQL topic. Before filtering or joining data, you need to choose columns clearly and understand the result set a query will return.
Read each prompt as a question about output shape. Decide which table is needed, which columns should appear, and whether aliases, distinct values, sorting, or limits change the result.
- Choosing columns from a table
- Aliases, DISTINCT, ORDER BY, and LIMIT
- Reading the shape of query results
Example practice questions
Try these samples, then continue into the SQL Practice Labfor guided browser-based practice.
Write a query that returns all columns from a users table.
Answer: SELECT * FROM users;
Write a query that returns only name and email from users.
Answer: SELECT name, email FROM users;
Write a query that returns product names from products.
Answer: SELECT name FROM products;
Write a query that renames price as item_price in the result.
Answer: SELECT price AS item_price FROM products;
Write a query that returns distinct countries from customers.
Answer: SELECT DISTINCT country FROM customers;
Write a query that returns users ordered by created_at newest first.
Answer: SELECT * FROM users ORDER BY created_at DESC;
Write a query that returns the first 10 rows from orders.
Answer: SELECT * FROM orders LIMIT 10;