01 | -- Opdracht 1 | Products |
02 |
03 | /* Toon de vend_id, prod_name en prod_price. De vend_id moet gelijk zijn aan DLL01 of BRS01. Alle prijzen |
04 | moeten groter of gelijk zijn dan 5. */ |
05 |
06 | -- vend_id prod_name prod_price |
07 | -- BRS01 8 inch teddy bear 5.99 |
08 | -- BRS01 12 inch teddy bear 8.99 |
09 | -- BRS01 18 inch teddy bear 11.99 |
10 |
11 | SELECT |
12 |
13 | -- Opdracht 2 | Products |
14 |
15 | /* Toon alle products m.u.v. de vend_id DLL01 en FNG01. */ |
16 |
17 | -- prod_id vend_id prod_name prod_price prod_desc |
18 | -- BR01 BRS01 8 inch teddy bear 5.99 8 inch teddy bear, comes with cap and jacket |
19 | -- BR02 BRS01 12 inch teddy bear 8.99 12 inch teddy bear, comes with cap and jacket |
20 | -- BR03 BRS01 18 inch teddy bear 11.99 18 inch teddy bear, comes with cap and jacket |
21 |
22 | SELECT |
23 |
24 | -- Opdracht 3 | Customers |
25 |
26 | /* Toon alle Fun4All customers of customers zonder e-mail. */ |
27 |
28 | -- cust_id cust_name cust_address cust_city cust_state cust_zip cust_country cust_contact cust_email |
29 | -- 1000000002 Kids Place 333 South Lake Drive Columbus OH 43333 USA Michelle Green NULL |
30 | -- 1000000003 Fun4All 1 Sunny Place Muncie IN 42222 USA Jim Jones jjones@fun4all.com |
31 | -- 1000000004 Fun4All 829 Riverside Drive Phoenix AZ 88888 USA Denise L. Stephens dstephens@fun4all.com |
32 | -- 1000000005 The Toy Store 4545 53rd Street Chicago IL 54545 USA Kim Howard NULL |
33 |
34 | SELECT |
35 |
36 | -- Opdracht 4 | Products |
37 |
38 | /* Toon alle products waarvan de prod_desc begint met een numerieke waarde. */ |
39 |
40 | -- prod_id vend_id prod_name prod_price prod_desc |
41 | -- BR01 BRS01 8 inch teddy bear 5.99 8 inch teddy bear, comes with cap and jacket |
42 | -- BR02 BRS01 12 inch teddy bear 8.99 12 inch teddy bear, comes with cap and jacket |
43 | -- BR03 BRS01 18 inch teddy bear 11.99 18 inch teddy bear, comes with cap and jacket |
44 | -- RGAN01 DLL01 Raggedy Ann 4.99 18 inch Raggedy Ann doll |
45 | -- RYL01 FNG01 King doll 9.49 12 inch king doll with royal garments and crown |
46 | -- RYL02 FNG01 Queen doll 9.49 12 inch queen doll with royal garments and crown |
47 |
48 | SELECT |
Download hier het bestand.