sqlh6.2

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 
10SELECT
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 
29SELECT
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 
44SELECT
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 
55SELECT

Download hier het bestand.