
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
thumb_up100%
Display Customer name (concatenate First Name and Last Name with a space between) and total number of orders for each customer. Name the total number of orders column as 'NumberOfOrders'. Sort based on Number of orders in descending order.

Transcribed Image Text:CUSTOMER Table
CUSTID | LNAME | FNAME | CITY
| STATE | PHONE
HARRIS
EDWARDS MITCH
107
PAULA
OSSEO
WI
7155559035
232
WASHBURN WI
7155556975
133
GARCIA
MARIA
RADISSON
WI
7155558332
154
MILLER
LEE
SILVER
WI
7155559002
179
CHANG
ALISA
SISBAY
WI
7155550087
CUSTID
ORDER Table
ORDERID|INVID|ORDERDATE | CUSTID| ORDER_PRICE|QUANTITY
1057
11668 5/29/2001
107
259.99
1
1057
11776 5/29/2001
107
59.90
2
11777 5/29/2001
11780 5/31/2001
1058
232
29.95
59.95
1
1059
133
1
1060
11775 5/31/2001
154
59.90
2
1061
11779 6/01/2001
179
59.95
1
INVID
INVENTORY Table
INVID| ITEMID | ITEMSIZE | CCOLOR | CURR PRICE | QOH
11668
786
SIENNA
259.99
16
11669
786
FOREST
259.99
12
11775
KHAKI
KHAKI
29.95
29.95
894
S
150
11776
894
147
11777
894
L
KHAKI
29.95
59.95
120
11778
897
S
TEAL
152
117
11779
897
M
TEAL
59.95
11780
897
L
TEAL
59.95
125
ITEMID
ITEM Table
ITEMDI ITEMDESC
| CATEGORY
894
WOMEN'S HIKING SHORTS
WOMEN'S CLOTHING
WOMEN'S CLOTHING
MEN'S CLOTHING
897
WOMEN'S FLEECE PULLOVER
786
MEN'S EXPEDITION PARKA
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved 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.Similar questions
- For every completed or 'open service request for janitorial work', list the condo id, description, and status.arrow_forwardDatabase Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,arrow_forwardQuestion 10 When sorting query output, you use the key words 'sort by'. Question 10 options: True Falsearrow_forward
- Determine which types of books are currently available in the current inventory. Each category should only be included once.arrow_forwardWhich group function can be used to perform a count that includes NULL values?arrow_forwardItem Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors' telephone number and address On this day in the suburbs of the cityarrow_forward
- Below are some rows of the PROVIDERS table for a factory: PCODE NAME PHONE 10192 Hans, Inc. 231 - 3092 98411 Tools and More 231 - 1029 0489035 Motors Inc. 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? a. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’ b. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’ c. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’ d. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’arrow_forwardWrite a ASQ statement to return to see all of the first names in the People table. SELECT first name FROM people; WHERE FROM People first name; FROM People SELECT first_name; First name WHERE FROM People;arrow_forwardClassify students according to the total number of hours they have completed. (Less than30=freshman, 30 to 59 is sophomore, 60 to 89 is junior, 90+ senior)arrow_forward
- 5. Determine the profit of each book sold to Jake Lucas, using the actual price the customerpaid (not the book’s regular retail price). Sort the results by order date. If more than onebook was ordered, sort the results by profit amount in descending order. Perform thesearch using the customer name, not the customer number.arrow_forwardERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYeararrow_forwardList the employee’s first and last name and the department name he/she does NOT belong topurchasing, shipping, or sales departments. Use Not operator.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

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