SQL Assignment

In Progress

1‐ In how many distinct locations are the departments located? 

2‐ How many employees are there in each phone area code? Sort by area 

code. 

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 

null row. 

6‐ List the address of each department that is not located in Seattle in the 

following format: 

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 

first. 

Database will be provided, each question will have a picture to show what answer should look like.

Skills: Database Programming, MySQL, Oracle, SQL

See more: simple assignment sql, woocommerce sorted alphabetically, database assignment sql script, school assignment sql, small assignment sql, use exceptions handle invalid user entries following situations, database assignment sql, submit database assignment sql, college assignment sql server, sql server express use windows, sql assignment help, college assignment database sql oracle, sql assignment database, sql assignment solution, sql assignment, sql assignment solve, assignment project design inplement windows desktop application vb net sql server meeting room database, amazonec2 sql self installation, clone sql system admin use domains, sql server 2005 project assignment, use bids import csv sql database

Project ID: #11728782

Awarded to:

mdaventini

Hi! As a freelancer starter i'm bidding low. Have a lot of experience in oracle! Been working more than 10 years programming

$15 CAD in 1 day
(0 Reviews)
0.0

8 freelancers are bidding on average $36 for this job

asadrana91

A proposal has not yet been provided

$55 CAD in 1 day
(27 Reviews)
5.7
ARKSolution2015

Dear Hiring Manager, Experience : 4+ years I will do it for you with perfection and I will keep working on it until you are 110% satisfied with results. Feel free to message me. we can discuss price and project More

$80 CAD in 3 days
(21 Reviews)
4.3
$30 CAD in 2 days
(24 Reviews)
3.3
GuichX

Hello mate, queries to do aren't so difficoult. It will take some hours only. Let me know and thanks for your time.

$30 CAD in 1 day
(3 Reviews)
1.7
$50 CAD in 1 day
(1 Review)
1.0
designsmaker0

A proposal has not yet been provided

$15 CAD in 0 days
(1 Review)
1.1
$30 CAD in 1 day
(0 Reviews)
0.0
$78 CAD in 1 day
(0 Reviews)
0.0
shezy007

MS COMPUTER SCIENCE..............................ASSISTANT PROFESSOR .................. ..............................SUBJECT: DATABASE ........ MY SQL , ORACLE , MS ACCESS ......!! I HAVE READ ALL THE QUERIES AND U More

$14 CAD in 1 day
(0 Reviews)
0.0