-- Opdracht 1 | Vendors /* Toon alle vendors zonder vend_state. */ -- vend_id vend_name vend_address vend_city vend_state vend_zip vend_country -- FNG01 Fun and Games 42 Galaxy Road London NULL N16 6PS England -- JTS01 Jouets et ours 1 Rue Amusement Paris NULL 45678 France SELECT * FROM Vendors WHERE vend_state IS NULL; -- Opdracht 2 | Products /* Toon alle producten met een prijs vanaf 3.49 t/m 8.99. */ -- prod_id vend_id prod_name prod_price prod_desc -- BNBG01 DLL01 Fish bean bag toy 3.49 Fish bean bag toy, complete with bean bag worms with which to feed it -- BNBG02 DLL01 Bird bean bag toy 3.49 Bird bean bag toy, eggs are not included -- BNBG03 DLL01 Rabbit bean bag toy 3.49 Rabbit bean bag toy, comes with bean bag carrots -- BR01 BRS01 8 inch teddy bear 5.99 8 inch teddy bear, comes with cap and jacket -- BR02 BRS01 12 inch teddy bear 8.99 12 inch teddy bear, comes with cap and jacket -- RGAN01 DLL01 Raggedy Ann 4.99 18 inch Raggedy Ann doll SELECT * FROM Products WHERE prod_price BETWEEN 3.49 AND 8.99; -- Opdracht 3 | Vendors /* Toon alle USA vendors aflopend gesorteerd op vend_id. */ -- vend_id vend_name vend_address vend_city vend_state vend_zip vend_country -- FRB01 Furball Inc. 1000 5th Avenue New York NY 11111 USA -- DLL01 Doll House Inc. 555 High Street Dollsville CA 99999 USA -- BRS01 Bears R Us 123 Main Street Bear Town MI 44444 USA -- BRE02 Bear Emporium 500 Park Street Anytown OH 44333 USA SELECT * FROM Vendors WHERE vend_country = 'USA' ORDER BY vend_id DESC; -- Opdracht 4 | Products /* Toon alle products met het vend_id DLL01 en BRS01. */ -- prod_id vend_id prod_name prod_price prod_desc -- BNBG01 DLL01 Fish bean bag toy 3.49 Fish bean bag toy, complete with bean bag worms with which to feed it -- BNBG02 DLL01 Bird bean bag toy 3.49 Bird bean bag toy, eggs are not included -- BNBG03 DLL01 Rabbit bean bag toy 3.49 Rabbit bean bag toy, comes with bean bag carrots -- BR01 BRS01 8 inch teddy bear 5.99 8 inch teddy bear, comes with cap and jacket -- BR02 BRS01 12 inch teddy bear 8.99 12 inch teddy bear, comes with cap and jacket -- BR03 BRS01 18 inch teddy bear 11.99 18 inch teddy bear, comes with cap and jacket -- RGAN01 DLL01 Raggedy Ann 4.99 18 inch Raggedy Ann doll SELECT * FROM Products WHERE vend_id = 'DLL01' OR vend_id = 'BRS01';
Download hier het bestand.