SQL Assignment - Repost
Este projeto foi concedido à mdaventini para $10 USD.Obtenha orçamentos gratuitos para um projeto como este
Orçamento do projeto$10 USD
Total de Ofertas1
Descrição do projeto
1‐ In how many distinct locations are the departments located?
2‐ How many employees are there in each phone area code? Sort by area
3‐ How many locations do NOT have postal codes starting with a number?
4‐ Find the mid‐point between the lowest and highest salaries of each
department that their salaries are higher than $5000. Sort by department
ID and do not include nulls.
5‐ The company wants to give a BONUS OF $1000 to employees who don’t
earn commissions and $500 to those who do earn commissions. What is the
total bonuses that each department will be paying out? Do not include the
6‐ List the address of each department that is not located in Seattle in the
7‐ Use a cross self‐join to list all the employees that have last names coming
after ‘Hartstein’ in an alphabetically sorted list, but have employee IDs that
come before Hartstein’s. Sort by last name
8‐ Do question 7 using subqueries.
9‐ Similar to question 2, but this time find the percentages (count divided by
the total number * 100). Sort by the percentages. Hint: You can use a
subquery to find the total number of rows.
10‐ Similar to Question 4, find the mid salary values, but this time for each
location. Sort by location ID. Hint: You can use a subquery to do the join
Database will be provided, each question will have a picture to show what answer should look like.
Querendo fazer dinheiro?
- Defina seu orçamento e o prazo de entrega
- Descreva sua proposta
- Receba pelo seu trabalho
Contratar freelancers que também ofereça neste projeto
Trabalhe em projetos como este e ganhe dinheiro desde casa!Cadastre-se Agora!
- The New York Times
- Wall Street Journal
- Times Online