3. SELECT;SELECT snum, sname, city, comm FROM Salespeople; 
3. SELECT;SELECT * FROM Salespeople; " * "    
3. SELECT;SELECT sname, comm FROM Salespeople;   
3. SELECT;SELECT odate, snum, onum, amt FROM Orders; 
3. DISTINCT;SELECT snum FROM Orders;  
3. DISTINCT;SELECT DISTINCT snum FROM Orders;  
3. WHERE;SELECT sname, city FROM Salespeople WHERE city = "London";   city  "London"
3. WHERE;SELECT * FROM Customers WHERE rating = 100;   rating  100
3.;SELECT onum, amt, odate FROM Orders;  SELECT,     ,         .
3.;SELECT * FROM Customers WHERE snum = 1001; ,        ,     = 1001.
3.;SELECT city, sname, snum, comm FROM Salespeople; ,         :city, sname, snum, comm.
3.;SELECT rating, cname FROM Customers WHERE city = 'SanJose';  SELECT,     (rating),      San Jose.
3.;SELECT DISTINCT snum FROM Orders; ,     snum               .
4. ;SELECT * FROM Customers WHERE rating > 200;      200
4. ;SELECT * FROM Customers WHERE city = 'SanJose' AND rating > 200;    'SanJose'    200
4. ;SELECT * FROM Customers WHERE city = 'SanJose' OR rating > 200;    'SanJose'     200
4. ;SELECT * FROM Customers WHERE city = 'SanJose' OR NOT rating > 200;    'SanJose'      200
4. ;SELECT * FROM Customers WHERE NOT city = 'SanJose' OR rating > 200;     'SanJose'     200
4. ;SELECT * FROM Customers WHERE NOT ( city = 'SanJose' OR rating > 200);     'SanJose'      200
4. ;SELECT * FROM Orders WHERE NOT (( odate = '10/03/1990' AND snum > 1002) OR amt > 2000.00);      2000,   10/03/1990     1002
4.;SELECT * FROM Orders WHERE AMT > 1000;            $1,000.
4.;SELECT SNAME, CITY FROM SALESPEOPLE WHERE CITY = 'London' AND COMM > 0.1;       sname  city        .10.
4.;SELECT * FROM CUSTOMERS WHERE NOT CITY = 'Rome' AND RATING <= 100;            =< 100,      .
4.;SELECT * FROM Orders WHERE ( amt < 1000 OR NOT ( odate = '10/03/1990' AND cnum > 2003)) ;        ?
4.;SELECT * FROM Orders WHERE NOT (( odate = '10/03/1990' OR snum > 1006) AND amt >= 1500);        ?
4.;SELECT * FROM SALESPEOPLE;      ?SELECT snum, sname, city, comm FROM Salespeople WHERE ( comm > + .12 OR comm < .14 )
5.*;    ;
5. IN;SELECT * FROM Salespeople WHERE city = 'Barcelona' OR city = 'London'  ;     IN
5. IN;SELECT * FROM Salespeople WHERE city IN ( 'Barcelona', 'London' ) ;     IN
5. IN;SELECT * FROM Customers WHERE snum IN ( 1001, 1007, 1004);       snum = 1001, 1007,  1004
5. BETWEEN;SELECT * FROM Salespeople WHERE comm BETWEEN 0.1 AND 0.12;     .10  .12
5. BETWEEN;SELECT * FROM Salespeople WHERE ( comm BETWEEN 0.1 AND 0.12) AND NOT comm IN (0.10 , 0.12);     .10  .12  
5. BETWEEN;SELECT * FROM Customers WHERE cname BETWEEN 'A' AND 'G';        - : A-G
5. LIKE;SELECT * FROM Customers WHERE cname LIKE 'G%';       'G'
5. LIKE;SELECT * FROM Salespeople WHERE sname LIKE 'P__l%';       : P??l*
5. LIKE;SELECT * FROM Salespeople WHERE sname LIKE '%/_ / / %'ESCAPE'/'; '_/'  , 'ESCARE'   '/'  ,     '_'  '%'    . (    )
5. LIKE;SELECT * FROM Salespeople WHERE sname LIKE '%/_%'ESCAPE'/';    , 'ESCARE'   '/'  ,     '_'  '%'    . (    )
5. NULL;SELECT * FROM Customers WHERE city IS NULL;  NULL. (    )
5.NOT  ;SELECT * FROM Customers WHERE city NOT NULL;
5.NOT  ;SELECT * FROM Customers WHERE NOT city IS NULL;
5.NOT  ;SELECT * FROM Salespeople WHERE city NOT IN ( 'London', 'San Jose' );
5.NOT  ;SELECT * FROM Salespeople WHERE NOT city IN ( 'London', 'San Jose' );
