Database Simulator

SQL Interactive Practice Lab

Select Mode: INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN GROUP BY

HAVING: No HAVING COUNT(o.product) > 1

Customers

1 - Alice

2 - Bob

3 - Charlie

Orders

1 - Laptop

1 - Mouse

2 - Phone

4 - Tablet

Counts

2

1

0

Build Result

---

Stored Function & Procedure Simulator

Select Program Type: Stored Function Stored Procedure

Parameter (Customer ID): 1 2 3

Drag Correct Output Here