SQL

Q1. Create a query to display highest, lowest, sum, and average salary of all worker whose Job is analyst.

Q2. Create a query to display the highest salary for each job.

Q3.Display the number of stores from staff table without listing them. Label the column Number of Stores.

Q4.Display the number difference between the highest and lowest salaries. Label the column DIFFERENCE.

Q5.Display the store number and the average of salaries in each store, Exclude any average is Less than 4000, exclude any worker whose job is clerk. Give each column an appropriate Label.

Q6. Create a query to display store id, store address, Total salaries in each store. , Exclude any Worker who do not have a store id. Sort the result in descending order by total salaries. Give each column an appropriate label.