all command.txt

4.1
SELECT *
FROM employees

4.3
SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12
FROM employees

4.6
SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12 as "YEARLY SALARY"
FROM employees

4.4
SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12 as "YEARLY SALARY"
FROM employees
ORDER BY SALARY*12 DESC

SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12 as "YEARLY SALARY"
FROM employees
ORDER BY SALARY*12 DESC, FIRST_NAME

4.7
SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12 as "YEARLY SALARY"
FROM employees
ORDER BY SALARY*12 DESC, FIRST_NAME
LIMIT 0,10

SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12 as "YEARLY SALARY"
FROM employees
ORDER BY SALARY*12 ASC, FIRST_NAME
LIMIT 0,10

SELECT EMPLOYEE_ID, FIRST_NAME, SALARY*12 as "YEARLY SALARY"
FROM employees
ORDER BY SALARY*12 DESC, FIRST_NAME
LIMIT 2,1

4.2
SELECT EMPLOYEE_ID, FIRST_NAME, SALARY
FROM employees
WHERE SALARY>20000

SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE
FROM employees
WHERE HIRE_DATE>="1987-10-01" AND HIRE_DATE<="1987-10-31"

4.5 [NOT NEEDED]




SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE
FROM employees
WHERE HIRE_DATE BETWEEN "1987-10-01" AND "1987-10-31"



SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
WHERE DEPARTMENT_ID=10 || DEPARTMENT_ID=50 || DEPARTMENT_ID=60

SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
WHERE DEPARTMENT_ID IN(10,50,60);


SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
WHERE DEPARTMENT_ID IN(10,50,60) IS FALSE

SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
WHERE DEPARTMENT_ID IN(10,50,60) IS NOT FALSE



SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
WHERE FIRST_NAME LIKE "L%"

SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
WHERE FIRST_NAME LIKE "L%X"


SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
WHERE FIRST_NAME LIKE "___"


SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
WHERE FIRST_NAME LIKE "_____%"


SELECT EMPLOYEE_ID, 
       CASE WHEN SALARY>20000 THEN 'A'
       WHEN SALARY BETWEEN 10000 AND 20000 THEN 'B'
       ELSE 'C' END
AS "SALARY GRADE"
       
FROM employees


SELECT EMPLOYEE_ID, SALARY+SALARY*IFNULL(COMMISSION_PCT,0) AS "TOTAL SAL"
FROM employees

NEXT ONLINE : 4.1 TO 4.7
SLIDE 11