SQL Queries ProblemsPlease see Attachment! Thank You 

 

 

PROBLEM11Show the First Name, Last Name, OrderNumber and OrderDate for all Customers even ifthey do not have any orders.Hint: The information for this query is in the Customer and Sales Order tables.Use a JOIN on these two tables. The "common column" is CustomerID. To get allCustomers, use a LEFT JOINProblem 12Show the ±rst and last names of the customer as one column, and the City andState separated by a comma as one column. Order by the state, the city and thecustomer's last name.Hint: To concatenate columns, use the '+' key, e.g., AreaCode + '-' +PhoneNumber.Problem 13For each part, show the Sales Orders that sold that part. Show the Parts thathave no sales as well. Display the PartID, Part Name, Sales Order #, the Quantitsold and the price for the order.Hint: A Left Join returns everything already selected even if it doesn't match thetables following. An Inner Join only returns those rows that match the conditionin both tables. A Right Join is the opposite of a Left Join: It returns rows in everytable AFTER the join even if the previous rows are not matchedProblem 14For each Part, show the PartID, Part Name, Total Quantity sold and the totalsales, including Parts with no sales. Order by the quantity sold descending, then

• 1495762417-Final.docx

ComputerScienceExpert

(11)

Status NEW Posted 26 May 2017 01:05 AM My Price 8.00

-----------

Attachments

file 1495762419-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer