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.
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;