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’
4. SELECT ENAME ‘EMPLOYEE NAME’, 12*SAL ‘ANNUAL SALARY’, 12*COMM ‘ANNUAL COMMISION, 12*SAL+12*COMM ‘ANNUAL SALARY & COMMISION’
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, ORDID
14. SELECT NAME, ADDRESS, STATE FROM CUSTOMER WHERE (PHONE LIKE ‘5%’ OR PHONE LIKE ‘6%’ OR PHONE LIKE ‘7%’) AND (PHONE LIKE “%-3%” OR PHONE LIKE ‘%-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))