DB2 | zadania

--ZADANIE 2

SELECT *
  FROM EMPLOYEE
  --WHERE FIRSTNME BETWEEN 'C' AND 'S'
  WHERE SUBSTR(LCASE(FIRSTNME), 1, 1) BETWEEN 'c' AND 's'
    AND SUBSTR(LCASE(FIRSTNME), 3, 1) NOT LIKE 'l'


-- ZADANIE 6
SELECT CURRENT TIME, CURRENT DATE
  FROM SYSIBM.SYSDUMMY1


-- ZADANIE 7
SELECT FIRSTNME, LASTNAME, BIRTHDATE
  FROM EMPLOYEE
  WHERE BIRTHDATE BETWEEN (SELECT CURRENT DATE - 50 YEARS
                     FROM SYSIBM.SYSDUMMY1) AND (SELECT CURRENT DATE - 30 YEARS
                                                   FROM SYSIBM.SYSDUMMY1)



db2set DB@_COMPATIBILITY_VECTOR=ORA
db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES