оПХКНФЕМХЕ E


рюакхжш 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

       -----------------------------------------------
Hosted by uCoz