SQL

Find the employee names, job and department name who are working as a Salesman.

List department names, their location and all employee details who work in the departments.

How many employees are in the database?

Find the job title and department name that has $2$ or more employees.

What is the salesman's total salary?

List the total salary, maximum and minimum salary and the average salary of employees job wise for department number $10$ and $20.$

Find the average salary for each job type and the number of people employed in each job.

Get the names and salaries of all the analysts earning more than $1200,$ who are based in accounting department. Sort the answer by ascending name.