LAB3.SQL

1. SELECT TO_CHAR(SYSDATE - 1, 'MONTH FMDDSPTH "OF YEAR" YYYY') AS "YESTERDAY'S DATE" FROM DUAL;

2. SELECT LAST_NAME, FIRST_NAME, ROUND(SALARY*1.10) AS "HIGH SALARY", (((SALARY*1.10)-12)*12) AS " ANNUAL INCREASE" FROM EMPLOYEES;

3. SELECT FIRST_NAME ||' '|| LAST_NAME|| ' IS ' || JOB_ID AS "EMPLOYEE" FROM EMPLOYEES
   WHERE LAST_NAME LIKE '%N' AND FIRST_NAME LIKE 'L%' OR FIRST_NAME LIKE 'M%'
   ORDER BY LAST_NAME ASC;

4. SELECT LAST_NAME, HIRE_DATE, ROUND(MONTHS_BETWEEN(SYSDATE, HIRE_DATE),0) AS "TOTAL MONTHS" FROM EMPLOYEES
   WHERE HIRE_DATE < '94-06-07'
   ORDER BY 3;

5. SELECT CITY, COUNTRY_ID, NVL(STATE_PROVINCE, 'UNKNOWN PROVINCE') AS "PROVINCE" FROM CITIES
   WHERE CITY LIKE 'T%' OR CITY LIKE 'R%' AND ( LENGTH(CITY) < 7);

6. SELECT LAST_NAME, HIRE_DATE, SALARY, TO_CHAR(NEXT_DAY(ADD_MONTHS(HIRE_DATE, 6), 'MONDAY'),'FMDAY, FMTH "OF" MONTH "IN YEAR" YYYY') 
   FROM EMPLOYEES
   WHERE HIRE_DATE > '98-03-15';