1- Display contact First name and contact Last name for customers after sorting the customers by their contact Last name in ascending order.

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
icon
Related questions
icon
Concept explainers
Question

1- Display contact First name and contact Last name for customers after sorting the customers
by their contact Last name in ascending order.
2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table.
Also, display the subtotal (quantityOrdered * priceEach) for each line item and sorts the result
set based on the subtotal descending .
3- Display unique last names from employees table ordered by last name.
4- Display customerNumber, customerName and creditLimit for getting the top five customers
who have the highest creditLimit.
5- Find customer Name, customer country, sales representative employee number from
customers who do not have a sales representative.
6- For each order status, display status and count of orders have this status.
7- For Each order number in order details table, Display order number, sum of quantity ordered
(itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition “total”
greater than 1000.
8- Display product code, product name and text description for product.
9- Find customer number, customer name, order status and order number, for customer with
their orders (handle customers that don’t have orders also). 

 

We will work on this schema:
productlines
"productLine
products
orderdetails
*productCode
productName
productLine
productScale
productVendor
productDescription
quantitylnStock
buyPrice
MSRP
* orderNumber
* productCode
e quantityOrdered
priceEach
textDescription
htmlDescription
image
orderLineNumber
employees
employeeNumber
lastName
orders
firstName
orderNumber
extension
orderDate
email
customers
requiredDate
shippedDate
4 status
officeCode
customerNumber
reportsTo
jobTitle
customerName
contactLastName
contactFirstName
comments
customerNumber
phone
addressLine1
offices
*officeCode
addressLine2
city
city
phone
payments
customerNumber
* checkNumber
paymentDate
state
postalCode
country
salesRepEmployeeNumber
creditLimit
addressLine1
4addressLine2
state
amount
country
postalCode
territory
Transcribed Image Text:We will work on this schema: productlines "productLine products orderdetails *productCode productName productLine productScale productVendor productDescription quantitylnStock buyPrice MSRP * orderNumber * productCode e quantityOrdered priceEach textDescription htmlDescription image orderLineNumber employees employeeNumber lastName orders firstName orderNumber extension orderDate email customers requiredDate shippedDate 4 status officeCode customerNumber reportsTo jobTitle customerName contactLastName contactFirstName comments customerNumber phone addressLine1 offices *officeCode addressLine2 city city phone payments customerNumber * checkNumber paymentDate state postalCode country salesRepEmployeeNumber creditLimit addressLine1 4addressLine2 state amount country postalCode territory
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

2- selects the order line items (orderNumber, orderlinenumber) from
the “orderdetails” table. Also, display the subtotal (quantityOrdered * priceEach) for each
line item and sorts the result set based on the subtotal descending .
3- Display unique last names from employees table ordered by last name.
4- Display customerNumber, customerName and creditLimit for getting the top five customers
who have the highest creditLimit.
5- Find customer Name, customer country, sales representative employee number from
customers who do not have a sales representative.
6- For each order status, display status and count of orders have this status.
7- For Each order number in order details table, Display order number, sum of quantity
ordered (itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition
“total” greater than 1000.
8- Display product code, product name and text description for product.
9- Find customer number, customer name, order status and order number, for customer
with their orders (handle customers that don’t have orders also)

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Query Syntax
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education