Question: please help me to do all the questions 6. Construct the SQL statement to retrieve those repair jobs requested by all customers, including the customer

please help me to do all the questions

please help me to do all the questions 6. Construct the SQL

6. Construct the SQL statement to retrieve those repair jobs requested by all customers, including the customer that have no repair jobs. Your SQL result must be displayed as follows: JOBNUM DATERECEIVED COMPUTERID CUSTOMERID FIRSTNAME LASTNAME J1 06/01/2015 CP1 CUST3 Halimatun Abdullah J2 10/15/2015 CP3 CUST3 Halimatun Abdullah 13 01/12/2016 CP6 CUSTS Lai Teng J4 01/13/2016 CP1 CUST3 Halimatun Abdullah CUST6 Chong May CUSTI Sulaiman Ahmad CUST2 Dareen Ghani CUSTO Ahmad Sarimah Mahmood Jailani CUST4 (12 marks) 7. Construct the SQL Nested/Subquery statement to display those item(s) ordered by Faris Jamal. Your SQL result must be displayed as follows: ITEMID PARTNUM SHORTNAME COST NUMINSTOCK ITO2 PT101 Video Card 400 4 IT09 PT108 Mouse 45 1 (18 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

FUTURE, Inc. has three different types of employees: technical staff, quality controller and worker. Each employee has a unique name, and address. A technical staff has an education record indicating...

I need someone that is very good at Principles of accounting and finance to answer the attached questions. It is not a one-day job therefore if you do not have the time, please don't attempt it. The...

Hi, I need help with this document. It is due 06/06/2017 11:59, Please help me! Project Six: Acquisition Contingencies Background In 2011, a construction materials manufacturing company (Construct)...

I really need an answer for module 3 entries (June 17-30) and midterm evaluation and final evaluation. I need them asap please help. Zacks Bike Hut Level II 1st Web-Based Edition Introduction Page 1...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

Need a sample answer for part C. Looking for a tutor to answer this question for the tutor credits I have. Would be a great help if someone would work with this price. Thanks a lot, really appreciate...

Need ONLY an answer to Part C, step 1, questions 1 and 3. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most...

Case Questions: Be Our Guest, Inc. 1. A. Reformat the income statement to clearly indicate EBITDA and EBIT. B. See footnote A Exhibit 3. Remove from "Other General and Administrative Expenses the...

Hi I was wondering If someone can check my ratios. I had to do the ratios for two companies for years 2015 and 2014. Can you please check them for me and let me know if there is anything wrong and...

What is a layout? What is its purpose?

The capital investment committee of Eastern Trucking Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Each...

You want to be able to withdraw $$ 0 , 0 0 0 each year for 3 0 years. Your account earns 8 % interest. a ) How much do you need in your account at the beginning?

Can you help me answer the following C programming question based on the following sample code. Sample code: #define _CRT_SECURE_NO_WARNINGS #include #include struct Person { int age; char job; char...

6. Go to www.uawford.com, the Web site for the UAW-Ford National Programs Center. Choose one of the joint programs to investigate. Search the Web site to find information about the program. What is...

1. Go to the Web site for Hewlett-Packard (HP) at www.hp.com. Click on About US, and then, click on Diversity Inclusion. Hewlett-Packard is known for its commitment to diversity. How does HP...

13. What are Lifelong Learning Accounts? Do you think they help retain employees or encourage them to train and then leave the company? Explain your rationale.