Exam 1: Basic SELECT

Difficulty: Beginner

Topics covered: SELECT, FROM, SELECT *, column aliases

Write a SQL query that satisfies each prompt, then click Submit to check your answer.

---

Question 1

Retrieve all columns from the customers table.

-- Write your query here

⌘ / Ctrl + Enter to run

---

Question 2

Retrieve only the name and email columns from the customers table.

-- Write your query here

⌘ / Ctrl + Enter to run

---

Question 3

Retrieve the name, category, and price columns from the products table.

-- Write your query here

⌘ / Ctrl + Enter to run

---

Question 4

Retrieve the order_id, order_date, and total_amount columns from the orders table.

-- Write your query here

⌘ / Ctrl + Enter to run

---

Question 5

Retrieve all columns from the products table, but alias name as product_name and price as unit_price.

-- Write your query here

⌘ / Ctrl + Enter to run