ТАБЛИЦЫ, ИСПОЛЬЗУЕМЫЕ В SQL

 
 
==================== ТАБЛИЦА 1: ПРОДАВЦЫ ================ 
 
 ---------------------------------------------- 
 snum | sname | city | comm 
 --------|-----------|--------------|---------- 
 1001 | Peel | London | .12 
 1002 | Serres | San Jose | .13 
 1004 | Motika | London | .11 
 1007 | Rifkin | Barcelona | .15 
 1003 | Axelrod | New York | .10 
 --------------------------------------------- 
 
 
 
================== ТАБЛИЦА 2: ЗАКАЗЧИКИ =============== 
 
 ---------------------------------------------- 
 cnum | cname | city | rating | snum 
 -------|------------|---------|--------|------ 
 2001 | Hoffman | London | 100 | 1001 
 2002 | Giovanni | Rome | 200 | 1003 
 2003 | Liu | SanJose | 200 | 1002 
 2004 | Grass | Berlin | 300 | 1002 
 2006 | Clemens | London | 100 | 1001 
 2008 | Cisneros | SanJose | 300 | 1007 
 2007 | Pereira | Rome | 100 | 1004 
 ---------------------------------------------- 
 
 
 
================== ТАБЛИЦА 3: ПОРЯДКИ ================== 
 
 ----------------------------------------------- 
 onum | amt | odate | cnum | snum 
 -------|-----------|-------------|------|------ 
 3001 | 18.69 | 10/03/1990 | 2008 | 1007 
 3003 | 767.19 | 10/03/1990 | 2001 | 1001 
 3002 | 1900.10 | 10/03/1990 | 2007 | 1004 
 3005 | 5160.45 | 10/03/1990 | 2003 | 1002 
 3006 | 1098.16 | 10/03/1990 | 2008 | 1007 
 3009 | 1713.23 | 10/04/1990 | 2002 | 1003 
 3007 | 75.75 | 10/04/1990 | 2004 | 1002 
 3008 | 4723.00 | 10/05/1990 | 2006 | 1001 
 3010 | 1309.95 | 10/06/1990 | 2004 | 1002 
 3011 | 9891.88 | 10/06/1990 | 2006 | 1001 
 -----------------------------------------------