1.	SELECT PRODID FROM PRODUCT
        SELECT DISTINCT PRODID FROM ITEM
 
2.      SELECT ‘THE DESCRIPTION OF THE PRODUCT WITH ID=‘ + PRODID, ‘ IS ‘ + DESCRIP FROM PRODUCT
 
3.      SELECT ‘THE PRODUCT IS ‘ + DESCRIP ‘PRODUCT NAME’ FROM PRODUCT
 
4.      SELECT ENAME ‘EMPLOYEE NAME’, 12*SAL ‘ANNUAL SALARY’, 12*COMM ‘ANNUAL COMMISION’, 12*SAL+12*COMM ‘ANNUAL SALARY & COMMISION’ FROM EMP
 
5.      SELECT ENAME ‘EMPLOYEE NAME’ FROM EMP WHERE COMM IS NOTNULL ORDER BY COMM DESC
 
6.      SELECT PRODID, DESCRIP FROM PRODUCT WHERE DESCRIP LIKE ‘%BALL%’
 
7.      SELECT NAME, CREDITLIMIT FROM CUSTOMER WHERE ((CREDITLIMIT >= 5000) AND (CREDITLIMIT <= 7000))
 
8.      SELECT NAME, CREDITLIMIT FROM CUSTOMER WHERE ((CREDITLIMIT > 5000) AND (CREDITLIMIT < 7000))
        
9.      SELECT PRODID, DESCRIP FROM PRODUCT WHERE DESCRIP LIKE ‘%TENNIS%’
 
10.     SELECT PRODID, DESCRIP FROM PRODUCT WHERE DESCRIP LIKE ‘%TENNIS%’ AND DESCRIP LIKE ‘%BALL%’
 
11.     SELECT PRODID FROM PRODUCT  WHERE DESCRIP LIKE ‘%\’’ OR PRODID LIKE ‘10086_’ OR PRODID LIKE ‘10087_’
 
12.     SELECT NAME, CREDITLIMIT, COMMENTS FROM CUSTOMER WHERE COMMENTS LIKE ‘%\%%’
 
13.     SELECT ORDID, CUSTID FROM ORD WHERE ORDERDATE LIKE ‘1987%’ ORDER BY CUSTID DESC, ORDID
 
14.     SELECT NAME, ADDRESS, CITY FROM CUSTOMER WHERE (PHONE LIKE '5___3___' OR PHONE LIKE '6___3___' OR PHONE LIKE '7___3___' OR PHONE LIKE '5___9___' OR PHONE LIKE '6___9___' OR PHONE LIKE '7___9___')
 
15.     SELECT DISTINCT PRICE FROM PRODUCT WHERE ((PRODID != 100861) AND (PRODID != 100890) AND (PRODID != 200380) AND (PRODID != 100871)) ORDER BY PRICE DESC
 
16.     SELECT ORDID, ORDERDATE, COMMPLAN, TOTAL FROM ORD WHERE ((ORDERDATE NOT LIKE ‘1986%’) AND (COMMPLAN NOT LIKE ‘A’) AND (COMMPLAN NOT LIKE ‘B’)) AND (TOTAL  BETWEEN 1000 AND 10000)
 
17.     SELECT 'STHN POLITEIA ' + STATE + ' BRISKETAI O PEALATHS POU TO ONOMA TOU KATALHGEI SE \" SPORTS\" KAI EINAI O ' + NAME + ' , EXEI DIEFTHUNSH ' ADDRESS + ' EDRA THN POLH ' + CITY + ' KAI THLEFONO ' + PHONE FROM CUSTOMER WHERE STATE LIKE ‘CA’ AND NAME LIKE ‘%SPORTS’
 
18.     SELECT * FROM EMP WHERE ((ENAME NOT LIKE ‘__R%’) AND (SAL BETWEEN 1500 AND 2500))