SQL Machine Learning

EmpNo	EName	Job	MGR	HireDate	Sal	Comm	DeptNo
1234	Amit	Waiter	8382	19-Oct-18	50000	500	50
5678	Ashish	Analyst	8635	2-Nov-18	60000	200	51

SELECT *
FROM emp e, dept d
WHERE UPPER(d.loc) IN (‘DELHI,’BANGALORE’) AND e.DeptNo = d.DeptNo
AND e.HireDate < (SELECT e.HireDate FROM emp e WHERE EName = ‘Aman’);

EmpNo	EName	Job	MGR	HireDate	Sal	Comm	DeptNo
1234	Amit	Waiter	8382	19-Oct-18	50000	500	50
5678	Ashish	Analyst	8635	2-Nov-18	60000	200	51

SELECT *
FROM empSELECT *
WHERE job in (SELECT job from emp WHERE EName IN (‘Aman’,’Amit’);

EmpNo	EName	Job	MGR	HireDate	Sal	Comm	DeptNo
1234	Amit	Waiter	8382	19-Oct-18	50000	500	50
5678	Ashish	Analyst	8635	2-Nov-18	60000	200	51

SELECT MAX(Sal)
FROM emp;

EmpNo	EName	Job	MGR	HireDate	Sal	Comm	DeptNo
1234	Amit	Waiter	8382	19-Oct-18	50000	500	50
5678	Ashish	Analyst	8635	2-Nov-18	60000	200	51

SELECT *
FROM emp
WHERE Salary = (SELECT MIN(Salary)
FROM emp);