6. SQL Questions
- Write up a School Registration DB Schema
- Two table of Employee (ID, Name)/Salary History (EMP_ID, SALARY, SAL_BEGIN_DATE)
- Find primary keys/foreign keys.
- Find ID of employee whose salary decreased.
- Find ID, total comp of employees
- Find ID of employees who got only paid once.

Question

6. SQL Questions
 - Write up a School Registration DB Schema
 - Two table of Employee (ID, Name)/Salary History (EMP_ID, SALARY, SAL_BEGIN_DATE)
  - Find primary keys/foreign keys.
  - Find ID of employee whose salary decreased.
  - Find ID, total comp of employees 
  - Find ID of employees who got only paid once.

Sigiloso · Accepted Answer

select * from employee e where e.id in(select s.empid from salary s, salary a where s.salary  a.salary_bigin_date);

Jan · Answer

Employees with decreased salaries
------------------------------------------------
select * from salary_history a
join salary_history b on a.emp_id=b.emp_id and a.salaryb.begin_date

Sigiloso · Answer

Employees with decreased salaries 
------------------------------------------------ 
select * from salary_history a
join salary_history b on a.emp_id=b.emp_id
and a.salaryb.begin_date

Goldman Sachs

Pergunta de entrevista da empresa Goldman Sachs

Respostas da entrevista

Empresas seguidas

Buscas de vagas