1. SELECT suppliers.first_name, suppliers.last_name 
FROM suppliers 
WHERE suppliers.job_title = 'Marketing Manager' 
ORDER BY suppliers.last_name DESC 

2. SELECT products.product_name AS Rattennahrung, products.product_code, products.quantity_per_unit 
FROM products 
WHERE products.category = "Baked Goods & Mixes" AND products.minimum_reorder_quantity >= 5 
ORDER BY products.product_code DESC 

3. SELECT products.category, MAX(products.standard_cost) 
FROM products 
GROUP BY products.category 
ORDER BY products.category DESC 

4. SELECT products.product_name, products.target_level, products.category
FROM products
WHERE products.category = 'Dried Fruit & Nuts'
GROUP BY products.product_name
HAVING products.target_level > 50

5. SELECT products.category, SUM(products.list_price) 
FROM products 
GROUP BY products.category 

6. SELECT COUNT(products.product_code) AS Anzahl_Artikel 
FROM products

7. SELECT customers.last_name, customers.first_name, customers.business_phone, customers.city 
FROM customers 
WHERE customers.city != 'Boston' AND customers.city != 'Honolulu' AND customers.city != 'Las Vegas' 

8.SELECT DISTINCT(customers.city), customers.state_province
FROM customers
2********************************************************************
1. durchschnittspreis aller produkte mit Bezeichnung "24 -200 g pkgs"
2. Summierter Preis von produkten die über 30 mal nachbestellt wurden
3. geringste nachbestellungsmenge von "Canned Fruit & Vegetables"
4.zählt Sales Representatives und gibt es als Vertriebsmitarbeiter aus
5.gibt netto und brutto für alle produkte aus



3 ******************************************************************+
SELECT products.product_name, products.target_level, products.category
FROM products
WHERE products.category = 'Dried Fruit & Nuts'
GROUP BY products.product_name
HAVING products.target_level > 50
