CiS120-PJ 2-QBE

docx

School

East Los Angeles College *

*We aren’t endorsed by this school

Course

123

Subject

Computer Science

Date

Apr 3, 2024

Type

docx

Pages

3

Uploaded by MagistrateWaterOtter209

Report
Q1. List the names of all clients that have a credit limit >= $10,000 [Hint: The answer contains 3 names. One name is “Two Crefty Cousins”.] Two Crefty Cousins, Harperburg bank, Prichard’s pizza and pasta Q2. List the descriptions of all items in the Tasks table that have the category DRM. [Hint: The answer contains 2 descriptions. One description is “Data Recovery Major”.] Data Recovery Major, Data Recovery Minor Q3. List the order numbers for orders placed by client number 322 on September 10, 2018. [Hint: The answer contains 2 numbers. One number is 67424.] 67424, 67949 Q4. List the order date and the scheduled date for any work order involving task SA44. [ QBE Hint: Inner Join 3 tables: WorkOrders, OrderLine, and Tasks.] [Hint: The answer contains only one record.] 9/14/2018, 9/24/2018 Q5. List the name of each client who placed an order for only two different tasks in the OrderLine table. [ QBE Hint: Inner Join 3 tables: Client, WorkOrders, and OrderLine. Total: First Group By Count |||| Criteria: 2] [Hint: The answer contains only 2 names. One name is “Harpersburg Bank”. The other name begins with “P”.] Harpersburg Bank, Prichard’s pizza and pasta Q6. List the name of each client who has a credit limit of $5,000, and is represented by the consultant Patrick Jordan. [ QBE Hint: Inner Join 2 tables: Client and Consultant.] [Hint: The answer contains only 2 names. One name is “Howler, Laura”.] “Howler, Laura”, Seymour lindsey Q7. List the sum of the balances for all customers represented by the consultant Christopher Turner. [ QBE Hint: Inner Join 2 tables: Consultant and Client. Total: Sum Group By Where Where] [Hint: The result must be only one big $ amount, not a list of $ amounts.] $18,746.05
Q8. For each order placed on September 10, 2018, list the order number, the client name, the last and first name of its consultant. (You must show a table for this query result.) [ QBE Hint: Inner Join 3 tables: Consultant, Client, and WorkOrders.] [Hint: The answer contains 3 records. One record is as follows: “67838 MarketPoint Sales Turner Christopher”] “67838 MarketPoint Sales Turner Christopher”, “67949 printing issues Sarah Allen” , “67424 mobility Sarah Allen” Q9. List the name of each client who placed an order that has exactly three different tasks in the OrderLine table. [ QBE Hint: Inner Join 3 tables: Client, WorkOrders, and OrderLine. Total: First Group By Count |||| Criteria: 3] [Hint: The answer contains only one name. The name begins with “P”.] Prichard’s pizza and pasta Q10. List ClientNum, ConsltNum, and City for each client whose city is the same as the city of its consultant. (You must show a table for this query result.) [ QBE Hint: Inner Join 2 tables: Client and Consultant. The join properties of Client and Consultant is #1: Only include rows where the join fields from both tables are equal. This is called inner join.] [Hint: The answer contains 2 records. One record is “322 35 Lizton”.] “322 35 Lizton” , “363 22 Easton” Q11. List the ClientNum and the ClientName for each client whose consultant is “Christopher Turner”, and who has ordered only one work order so far. (You must show a table for this query result.) [ QBE Hint: Inner Join 3 tables: Consultant, Client, and WorkOrders. Total: First First Group By Where Where Count] [Hint: The answer contains only one record. The ClientName starts with “H”.] Howler laura Q12. List OrderNum, OrderDate, ClientNum, TaskID, QuotedPrice, ScheduledDate for all order numbers in WorkOrders table. [ QBE Hint: Inner Join 2 tables: WorkOrders and OrderLine. The join properties of WorkOrders and Orderline is #1: Only include rows where the join fields from both tables are equal. This is called inner join.] [Hint: The answer contains exactly 12 records.] OrderNum, OrderDate, ClientNum, TaskID, QuotedPrice, ScheduledDate 67101,9/6/2018,733,SI77,softare minor,9/10/2018 67313,9/7/2018,458,LA81,LAN,9/12/2018 67424,9/10/2018,322,MO49,Mobility,9/14/2018
67838,9/10/2018,867,LA81,LAN,9/20/2018 67949,9/10/2018,322,PI54,printing issues,9/21/2018 68252,9/12/2018,363,DI85,data recovery minor,9/24/2018 68868,9/14/2018,867,SA44,software major,9/24/2018 68979,9/17/2018,826,AC65,accessories,9/27/2018
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

CS230 module 4 journal entry.docx
CS 405 5-3 Activity Static Code Analysis(revised).docx
CS 405 5-1 Case Study Triple A and Defense in Depth.docx
CS 405 2-1 Journal Defense in Depth (DiD).docx
Quiz7.docx
Quiz6.docx
CiS120-PJ1-report-my-name.docx).docx
Aviation Assignment.pdf
2-2 short responses.docx
questions for final.docx
Assignment_3_Template.docx
Quiz5.docx
Recommended textbooks for you
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
SEE MORE TEXTBOOKS