A toy promotion goes to customers in Kochi. Pair every Kochi customer with every
Toys product (category_id 8): show full_name, product_name and price.
End your query with ORDER BY full_name, product_name.
| customers |
|---|
| customer_id (PK) |
| full_name |
| city |
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
A toy promotion goes to customers in Kochi. Pair every Kochi customer with every
Toys product (category_id 8): show full_name, product_name and price.
End your query with ORDER BY full_name, product_name.
| customers |
|---|
| customer_id (PK) |
| full_name |
| city |
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| full_name | product_name | price |
|---|---|---|
| George Thomas | Building Blocks 250pc | 1499.00 |
| George Thomas | RC Stunt Car | 1999.00 |
| George Thomas | Strategy Board Game | 1199.00 |
| Harish Pillai | Building Blocks 250pc | 1499.00 |
| Harish Pillai | RC Stunt Car | 1999.00 |
| Harish Pillai | Strategy Board Game | 1199.00 |
| Ravi Nair | Building Blocks 250pc | 1499.00 |
| Ravi Nair | RC Stunt Car | 1999.00 |
| Ravi Nair | Strategy Board Game | 1199.00 |
Run query to see output