- Additional Source: https://www.youtube.com/watch?v=miEFm1CyjfM&t=314s (in English)
- Before doing your Github homework, let's create the following tables in PostgreSQL using Python codes. Let's write the codes to run the queries.
- Find the employees who get paid more than Rodney Weaver.
- Find the average, min and max salaries
- Find the employees whose salary is more than 8700. Our query should return first name, last name, and salary info of the employees.
- Find the employees (first name, last name from employees table) who work under the Operations department (departments table). Our query should return first name and last name info.
- Find the employees (first name, last name from employees table) who work under the Technology department (departments table). Our query should return first name and last name info.
- Find the average salary of female employees.
- Find the average salaries of each department.
- Find the oldest and newest employees.
- Find the hiring date and department of the highest paid employee
- Find the hiring date and department of the lowest paid employee
You are expected to complete the mini project, which has a detailed explanation in the link below.