Chapter 6, Problem 7EYK

The HR manager wants to calculate total salaries and count of only non-salespersons of each department and job id. Include total of salary and the number of employees of the groups, department id, job id in your report. Also, total sum of each department and total number of each department should be in included in the SQL query database result.

- Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy the dname and the total salary of each department into TEMP_TABLE table

Find top 2 largest departments in terms of number of employees

Find the staff name who has the maximum salaryfor each branchFind the staff name who has the maximum salaryfor each cityFind the branch that does not have any staff  Find the city that does not have any staff

Given the employees of medium-sized semi-conductor firm, find the employee that joined November 8, 2020 using INDEX and MATCH function. (Attach an excel file) NAME GENDER DEPARTMENT DATE JOINED SALARY Andy Gomez Lito Cruz Michelle Sy Luis Cortez SHEILA CO PAMELA DY SARAH MORAL PATRICK ONG CLAIRE HONG JAYSON MEDINA MALE MALE FEMALE MALE FEMALE FEMALE FEMALE MALE FEMALE MALE MARKETING R&D ACCOUNTING OPERATIONS PURCHASING OPERATIONS MARKETING OPERATIONS PURCHASING OPERATIONS 16-OC-19 3-MAR-10 5-SEP-18 18-DEC-19 4-SEP-19 4-MAY-19 8-NOV-20 12-AUG-18 30-JUL-18 19-OCT-18 50,000 28,000 65,000 70,500 62,000 35,000 80,100 39,000 42,700 44,700

Find the managers who have given the most amount of money to a single organization. For the 3highest amounts, retrieve the manager name, organization name and total amount given. Using Mysql

Do you need to normalize median age when making your choropleth map? Why or Why not?

Write SQL Query to find the average of all the salaries from the table Employee(ID, NAME, SALARY, DEPARTMENT)

Solve the following queries: 1. Display all details of the item table. 2. Display item name, section and price of all garments. 3. Display the number of customers from Muscat and their total amount. 4. Display the average of all garment items sold. 5. Display the maximum and minimum amount of the customer. 6. Display all items ending with ‘et’ and are décor. 7. Display customer number and location of customer with amount not less than 50. 8. Display all garments and décor items. 9. Display all décor items with prices not less than 10. 10. Display item name, section and price of all accessories with price less than equal to 5. 11. Display the average amount of Nizwa city customers. 12. Display all items with price between 5 and 10. (without using between) 13. Remove duplicate values from the section column of the item table. 14. Display item name, price, customer number of C2 customer.