BEISPIELLOESUNG ZU BLATT 01
===========================


1.)
SELECT name FROM customers where salesRepEmployeeNumber = 1286
    and country != "USA"

2.)
Moeglichkeit 1: Verwendung eines Subqueries:

  SELECT firstName, lastName FROM employees where 
     reportsTo = (select reportsTo from employees where employeeNumber=1504);

Moeglichkeit 2: Verwendung von Tupelvariablen:

  SELECT A.firstName, A.lastName FROM employees A, employees B 
     where A.reportsTo = B.reportsTo and B.employeeNumber = 1504;

3.)
SELECT status, count(status) from orders group by status;

4.)
SELECT sum(quantityOrdered * priceEach) FROM orderdetails o 
   where orderNumber=10204;

5.)
SELECT distinct(c.country) from payments p, customers c 
   where paymentDate like "2005-04%" and p.customerNumber = c.customerNumber;

6.)
SELECT p.*, o.productCode, count(o.productCode) from products p,
   orderdetails o where p.productCode = o.productCode 
   group by o.productCode order by count(o.productCode) desc limit 1