1. Display the employee number, full employee name, job title, and hire date of all employees hired in September with the most recently hired employees displayed first. Eneve Ntea Ne 12 James, Elliott Accountant 11 Ramirez, Tyler Accountant Stoek clerk Sat e [September 30th of 2016] [September 20th of 2016] (september 2eth of 2016) 27 Long, Kai 2Rivera, Jude Administration Vice President [September 21st of 2016] 101 Dunn, Annabelle Administration Assistant [September 17th of 2016]
1. Display the employee number, full employee name, job title, and hire date of all employees hired in September with the most recently hired employees displayed first. Eneve Ntea Ne 12 James, Elliott Accountant 11 Ramirez, Tyler Accountant Stoek clerk Sat e [September 30th of 2016] [September 20th of 2016] (september 2eth of 2016) 27 Long, Kai 2Rivera, Jude Administration Vice President [September 21st of 2016] 101 Dunn, Annabelle Administration Assistant [September 17th of 2016]
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Please use sql to answer the following question an erd also provide as the picture shown

Transcribed Image Text:COMPI22 W21 ERS 100ASGM1 ORDER ITEMS
PF. ORDER ID
P TEM ID
F PRODUCT ID
QUANTITY
* UNIT PRICE
NUMBER (12)
NUMBER (12)
NUMBER (12)
NUMBER (8,2)
NUMBER (82)
COMPI22 W21 ERS 100ASGM1 ORDERS
P. ORDER ID
F CUSTOMER_ID
STATUS
COMPI22 W21 ERS 100 ASGM1 EMPLOYEES
P. EMPLOYEE ID
* FIRST NAME
LAST NAME
EMAIL
• PHONE
* HIRE DATE
MANAGER ID
JOB TITLE
NUMBER
NUMBER
VARCHAR2 (255 BYTE)
VARCHAR2 (255 BYTE)
VARCHAR2 (255 BYTE)
VARCHAR2 (50 BYTE)
DATE
NUMBER (12)
VARCHAR2 (255 BYTE)
NUMBER (6)
VARCHAR2 (20 BYTE)
NUMBER (6)
DATE
SALESMAN ID
* ORDER DATE
PK ASGM1 ORDER_ITEMS (ORDER_ID, ITEM_ID)
O FK ORDER_ITEMS_ORDERS (ORDER_ID)
FK ORDER_ITEMS PRODUCTS (PRODUCT_ID)
O PK ASGM1 ORDER_ITEMS (ORDER_ID, ITEM_ID)
ASGM1 ORDERS PK (ORDER ID)
O FK ORDERS_CUSTOMERS (CUSTOMER_ID)
FK ORDERS EMPLOYEES (SALESMAN_D)
ASGM1 EMPLOYEES PK (EMPLOYEE ID)
Og FK EMPLOYEES MANAGER (MANAGER_ID)
COMP122 W21 ERS 100.ASGM1_INVENTORIES
PF PRODUCT_ID
PF WAREHOUSE ID
* QUANTITY
NUMBER (12)
NUMBER (12)
NUMBER (8)
PK ASGM1_INVENTORIES (PRODUCT_ID, WAREHOUSE ID)
FK INVENTORIES PRODUCTS (PRODUCT_ID)
FK_INVENTORIES_WAREHOUSES (WAREHOUSE ID)
O PK ASGM1_INVENTORIES (PRODUCT_ID, WAREHOUSE ID)
COMP122_W21_ERS_100 ASGM 1_CUSTOMERS
P CUSTOMER_ID NUMBER
NAME
VARCHAR2 (255 BYTE)
VARCHAR2 (255 BYTE)
VARCHAR2 (255 BYTE)
NUMBER (8,2)
COMP122 W21_ERS_100 ASGM1_PRODUCTS
P PRODUCT_D
* PRODUCT NAME
DESCRIPTION
ADDRESS
WEBSITE
CREDIT LIMIT
NUMBER
VARCHAR2 (255 BYTE)
VARCHAR2 (2000 BYTE)
NUMBER (92)
NUMBER (92)
NUMBER
ASGM1 CUSTOMERS PK (CUSTOMER_ID)
STANDARD COoST
LIST PRICE
• CATEGORY ID
ASGM1_PRODUCTS PK (PRODUCT_ID)
FK ASGM1 PRODUCTS CATEGORIES (CATEGORY ID)
COMP122 W21 ERS 100 ASGM1 WAREHOUSES
COMP122 W21 ERS 100.ASGM1 CONTACTS
P. WAREHOUSE ID
WAREHOUSE NAME
LOCATION_ID
P CONTACT ID
* FIRST_NAME
LAST NAME
EMAIL
PHONE
CUSTOMER ID
NUMBER
VARCHAR2 (255 BYTE)
VARCHAR2 (255 BYTE)
VARCHAR2 (255 BYTE)
VARCHAR2 (20 BYTE)
NUMBER
NUMBER
VARCHAR2 (255 BYTE)
NUMBER (12)
IF
a ASGM1_WAREHOUSES PK (WAREHOUSE ID)
COMP122 W21_ERS 100 ASGM1_PRODUCT CATEGORIES
P. CATEGORY ID
• CATEGORY NAME
FK _WAREHOUSES_LOCATIONS (LOCATION_ID)
NUMBER
VARCHAR2 (255 BYTE)
> ASGM1 CONTACTS_PK (CONTACT_ID)
FK CONTACTS CUSTOMERS (CUSTOMER_ID)
ASGM1_PRODUCT CATEGORIES_PK (CATEGORY_ID)
COMP122 W21 ERS 100 ASGM1 LOCATIONS
P. LOCATION ID
ADDRESS
POSTAL CODE
NUMBER
VARCHAR2 (255 BYTE)
VARCHAR2 (20 BYTE)
VARCHAR2 (50 BYTE)
VARCHAR2 (50 BYTE)
CHAR (2 BYTE)
COMP122 W21 ERS 100.ASGM1 COUNTRIES
CHAR (2 BYTE)
VARCHAR2 (40 BYTE)
NUMBER
COMP122 W21 ERS 100 ASGM1 REGIONS
P. REGION ID
REGION NAME
COUNTRY ID
COUNTRY NAME
CITY
NUMBER
STATE
VARCHAR2 (50 BYTE)
REGION ID
COUNTRY_ID
- ASGM1_COUNTRIES_PK (COUNTRY_ID)
a ASGM1 REGIONS PK (REGION_ID)
ASGM1 LOCATIONS PKLOCATION IDA
![1. Display the employee number, full employee name, job title, and hire date of all
employees hired in September with the most recently hired employees displayed
first.
Enlevee NteName
12 James, Elliott Accountant
11 Ramirez, Tyler Accountant
27 Long, Kai
2Rivera, Jude
101 Dunn, Annabelle Administration Assistant
[September 30oth of 2016]
[September 28th of 2016]
[september 2eth of 2016)
Stock clerk
Administration Vice President (September 2lst of 2016]
(September 17th of 2016]
Milestone 2 - Week 3 (Question 2, 3, 4, 5, and 6)
2. The company wants to see the total sale amount per sales person (salesman) for all
orders. Assume that online orders do not have any sales representative. For online
orders (orders with no salesman ID), consider the salesman ID as 0. Display the
salesman ID and the total sale amount for each employee.
Sort the result according to employee number.
Enlyee te tat S
O $18,245, 463.50
$1,884,295.40
$3, 525, 462.19
$2, 754,951.05
$3, 522, 704.53
$3, 900, 172.99
ו3. 737 ,233 ,$3
54
55
56
57
59
60
3. Display customer Id, customer name and total number of orders for customers that
the value of their customer ID is in values from 35 to 45. Include the customers with
no orders in your report if their customer ID falls in the range 35 and 45.
Sort the result by the value of total orders.
Cuntone Nane
38 Kraft Meinz
37 Hunt sman
35 Kimberly-Ciark
40Fluor
39 Lear
36 Hartford Finaneial services Group
41 ABCOM
43 Facebook
42 Becton Dickinson
45 Centurylink
44 Jabil Cireuit](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F049d5dc6-be41-490f-a90a-eca810f23bb9%2F6cb87d9c-4603-40f8-85b3-1fd9148316fe%2F2oit10q_processed.png&w=3840&q=75)
Transcribed Image Text:1. Display the employee number, full employee name, job title, and hire date of all
employees hired in September with the most recently hired employees displayed
first.
Enlevee NteName
12 James, Elliott Accountant
11 Ramirez, Tyler Accountant
27 Long, Kai
2Rivera, Jude
101 Dunn, Annabelle Administration Assistant
[September 30oth of 2016]
[September 28th of 2016]
[september 2eth of 2016)
Stock clerk
Administration Vice President (September 2lst of 2016]
(September 17th of 2016]
Milestone 2 - Week 3 (Question 2, 3, 4, 5, and 6)
2. The company wants to see the total sale amount per sales person (salesman) for all
orders. Assume that online orders do not have any sales representative. For online
orders (orders with no salesman ID), consider the salesman ID as 0. Display the
salesman ID and the total sale amount for each employee.
Sort the result according to employee number.
Enlyee te tat S
O $18,245, 463.50
$1,884,295.40
$3, 525, 462.19
$2, 754,951.05
$3, 522, 704.53
$3, 900, 172.99
ו3. 737 ,233 ,$3
54
55
56
57
59
60
3. Display customer Id, customer name and total number of orders for customers that
the value of their customer ID is in values from 35 to 45. Include the customers with
no orders in your report if their customer ID falls in the range 35 and 45.
Sort the result by the value of total orders.
Cuntone Nane
38 Kraft Meinz
37 Hunt sman
35 Kimberly-Ciark
40Fluor
39 Lear
36 Hartford Finaneial services Group
41 ABCOM
43 Facebook
42 Becton Dickinson
45 Centurylink
44 Jabil Cireuit
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education