Write SQL statements to list the ID and start date of the project that began before.
Write SQL statements to list the name, salary, and 5% increased salary of the employees who are living in LR. Rename the increased salary column as "5%IncreasedSalary".
Write SQL statements to list the name of the employee whose salary is between 50000 and 100000, and also whose name contains the words "ar".
Write SQL statements to list the name of the employee who doesn't have a supervisor.
I would like to know how many employees make more than $65000 by department.
Write SQL statements to list the department name and the total salary.
I am looking for someone. I know that the second letter of his name was "e". Write SQL statements to list his name, department name, and project name.
For each project that started in the year 2021, list the project name and the total salary for the employees who worked for the project. Include in the outcome table only if the total salary is greater than 500000. Arrange the outcome by the total salary.