Skip to content

Instantly share code, notes, and snippets.

@abue-ammar

abue-ammar/all command.txt

Created October 16, 2019 06:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save abue-ammar/8851e0c2f4ab54f0f627b3a4fa5efebc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save abue-ammar/8851e0c2f4ab54f0f627b3a4fa5efebc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment