sqlh4.3

-- 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.