Untitled

ALTER SESSION SET CURRENT_SCHEMA=HR;
SELECT FIRST_NAME, LAST_NAME FROM HR.EMPLOYEES WHERE LAST_NAME LIKE '%a';
SELECT FIRST_NAME, LAST_NAME FROM HR.EMPLOYEES WHERE FIRST_NAME LIKE '_a%' AND EMPLOYEES.SALARY < 5000;
SELECT FIRST_NAME, LAST_NAME, SALARY, DEPARTMENT_ID FROM HR.EMPLOYEES WHERE SALARY <3000 OR (SALARY <5000 AND DEPARTMENT_ID = 50);
SELECT COUNT(EMPLOYEE_ID) FROM HR.EMPLOYEES;
SELECT SUM(SALARY) FROM HR.EMPLOYEES;
SELECT FIRST_NAME,LAST_NAME ,JOB_ID,JOB_TITLE FROM HR.EMPLOYEES AND JOB_ID,JOB_TITLE FROM HR.JOBS WHERE EMPLOYEES.JOB_ID = JOBS.JOB_ID;