Show customer_id and full_name of the customers who bought at least one Toys
product (category_id 8), each customer once.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_items |
|---|
| item_id (PK) |
| order_id (FK) |
| product_id (FK) |
| products |
|---|
| product_id (PK) |
| category_id (FK) |
Show customer_id and full_name of the customers who bought at least one Toys
product (category_id 8), each customer once.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_items |
|---|
| item_id (PK) |
| order_id (FK) |
| product_id (FK) |
| products |
|---|
| product_id (PK) |
| category_id (FK) |
| customer_id | full_name |
|---|---|
| 1 | Aisha Verma |
| 2 | Rahul Sharma |
| 3 | Sneha Patel |
| 4 | Amit Kumar |
| 5 | Pooja Singh |
| 6 | Vikash Yadav |
| 7 | Neha Gupta |
| 8 | Rajesh Khanna |
| 9 | Kavita Rao |
| 10 | Sanjay Mehta |
| 13 | Meena Iyer |
| 14 | Arun Joshi |
| 15 | Divya Menon |
| 16 | Karan Malhotra |
| 17 | Pallavi Kulkarni |
| 18 | Nikhil Bose |
| 20 | Manoj Tiwari |
| 21 | Fatima Khan |
| 22 | George Thomas |
| 23 | Lakshmi Venkat |
| 24 | Imran Sheikh |
| 25 | Sara D'Souza |
Run query to see output