01 | -- Oefening 1 |
02 |
03 | SELECT order_num |
04 | FROM OrderItems |
05 | WHERE prod_id = 'RGAN01'; |
06 |
07 |
08 | -- Oefening 2 |
09 |
10 | SELECT cust_id |
11 | FROM Orders |
12 | WHERE order_num IN (20007,20008); |
13 |
14 |
15 | -- Oefening 3 |
16 |
17 | SELECT cust_id |
18 | FROM Orders |
19 | WHERE order_num IN (SELECT order_num |
20 | FROM OrderItems |
21 | WHERE prod_id = 'RGAN01'); |
22 | |
Download hier het bestand.