These are chat archives for FreeCodeCamp/DataScience
discussion on how we can use statistical methods to measure and improve the efficacy of http://freeCodeCamp.com
alright awesome, I have a challenge for class that I’m very close to completing but need to implement part of the information with a subquery.
this is the challenge followed by my statement:
Please find all emp records that have a salary greater than 8000, and those hired after 1996 and please report the % of their salary as compared to the salary of the lowest salary.
Use subquery to find the lowest salary
SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, HIRE_DATE, SALARY,
(SALARY - min(SALARY) ) / min(SALARY) * 100 AS Percentage_Comparison FROM EMPLOYEES
WHERE SALARY > 8000
AND HIRE_DATE >= '01-JAN-97';
SELECT * FROM ( SELECT * from EMPLOYEES WHERE SALARY > 8000 ) subquery where subquery.hire_date >= '01-JAN-97'
cwborion sends brownie points to @mcbarlowe :sparkles: :thumbsup: :sparkles: