MySQL / As
- Show the total no of employees, their total salary, their average salary, their max salary, their min salary from employees table.
- Show the maximum and minimum value of min_salary column, maximum and minimum value of max_salary column from job_history table
- Count the total no of distinct job_id s from employees table
- Count the distinct no of countries from the locations table