SQL

Query

Tables:

• Employee Table

  employee_id	employee_name	department_id	salary	joining date

• Department Table

  dept_id	dept_name	budget

Questions

Where, order by

• Return employees order by salary

Group By

• Group employees based on department

• Group employees based on department, and give max salary in each department

• Group employees based on department, and return employee count in each department

Window functions

Indexes

• Types of indexes

• Advantages and disdvantages of Indexes