01 | -- Opdracht 1 | Products |
02 |
03 | /* Toon alle products waarbij de prod_name de tekst 'bean bag' bevat. */ |
04 |
05 | -- prod_id vend_id prod_name prod_price prod_desc |
06 | -- BNBG01 DLL01 Fish bean bag toy 3.49 Fish bean bag toy, complete with bean bag worms with which to feed it |
07 | -- BNBG02 DLL01 Bird bean bag toy 3.49 Bird bean bag toy, eggs are not included |
08 | -- BNBG03 DLL01 Rabbit bean bag toy 3.49 Rabbit bean bag toy, comes with bean bag carrots |
09 |
10 | SELECT |
11 |
12 | -- Opdracht 2 | OrderItems |
13 |
14 | /* Toon alle orderitems waarvan de prod_id begint met 4 willekeurige karakters, het getal 0 en 1 willekeurig karakter. */ |
15 |
16 | -- order_num order_item prod_id quantity item_price |
17 | -- 20007 2 BNBG01 100 2.99 |
18 | -- 20007 3 BNBG02 100 2.99 |
19 | -- 20007 4 BNBG03 100 2.99 |
20 | -- 20007 5 RGAN01 50 4.49 |
21 | -- 20008 1 RGAN01 5 4.99 |
22 | -- 20008 3 BNBG01 10 3.49 |
23 | -- 20008 4 BNBG02 10 3.49 |
24 | -- 20008 5 BNBG03 10 3.49 |
25 | -- 20009 1 BNBG01 250 2.49 |
26 | -- 20009 2 BNBG02 250 2.49 |
27 | -- 20009 3 BNBG03 250 2.49 |
28 |
29 | SELECT |
30 |
31 | -- Opdracht 3 | Products |
32 |
33 | /* Toon alle products waarvan de prod_desc niet begint met een B of R. */ |
34 |
35 | -- prod_id vend_id prod_name prod_price prod_desc |
36 | -- BNBG01 DLL01 Fish bean bag toy 3.49 Fish bean bag toy, complete with bean bag worms with which to feed it |
37 | -- BR01 BRS01 8 inch teddy bear 5.99 8 inch teddy bear, comes with cap and jacket |
38 | -- BR02 BRS01 12 inch teddy bear 8.99 12 inch teddy bear, comes with cap and jacket |
39 | -- BR03 BRS01 18 inch teddy bear 11.99 18 inch teddy bear, comes with cap and jacket |
40 | -- RGAN01 DLL01 Raggedy Ann 4.99 18 inch Raggedy Ann doll |
41 | -- RYL01 FNG01 King doll 9.49 12 inch king doll with royal garments and crown |
42 | -- RYL02 FNG01 Queen doll 9.49 12 inch queen doll with royal garments and crown |
43 |
44 | SELECT |
45 |
46 | -- Opdracht 4 | Products |
47 |
48 | /* Breid opdracht 3 uit zodat de prod_id hoger dan een 1 eindigt. */ |
49 |
50 | -- prod_id vend_id prod_name prod_price prod_desc |
51 | -- BR02 BRS01 12 inch teddy bear 8.99 12 inch teddy bear, comes with cap and jacket |
52 | -- BR03 BRS01 18 inch teddy bear 11.99 18 inch teddy bear, comes with cap and jacket |
53 | -- RYL02 FNG01 Queen doll 9.49 12 inch queen doll with royal garments and crown |
54 |
55 | SELECT |
Download hier het bestand.