Question: Prompt: Develop a query to provide details about customer sales at the end of 2014. You want the output to include the following attributes in

Prompt: Develop a query to provide details aboutPrompt: Develop a query to provide details aboutPrompt: Develop a query to provide details aboutPrompt: Develop a query to provide details about

Prompt: Develop a query to provide details about customer sales at the end of 2014. You want the output to include the following attributes in this order: sale ship-to city, customer last name, and sale ship date. Restrict the query to include sales that were shipped to cities that end in the letter "o" and were shipped on a date within the last four months of 2014. Sort the query output first by the ship- to city and next by the customer last name. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Sale.ShipToCity, Customer.LastName, Sale.ShipDate FROM Sale JOIN Customer Sale. =Customer. Sale.ShipToCity AND Sale.Ship Date AND ORDER BY Sale.ShipToCity, Customer.LastName; Query Result Count (enter number only, ex. 12): Result: rows Name CategoryID CatName CatDescript CustOrder OrderID CustID EmployeeID OrderDate ReqDate Customer CustID LastName FirstName BirthDate CustIncBracket Address City Region PostalCode Country Phone Employee EmployeeID LastName FirstName Title BirthDate HireDate TermDate Address City Region PostalCode Country Phone Order Product OrdProdID OrderID ProdID Order Price QtyOrdered INTEGE NVARCH NUMERI INTEGE INTEGE INTEGE INTEGE INTEGE INTEGEI INTEGE INTEGE INTEGE INTEGE DATETI NUMERI Product ProdID ProdName UnitPrice SupplierID CategoryID UnitsInStock UnitsonOrder ReorderLevel Sale SaleID OrderID CustID EmployeeID ShipperID ShipDate FreightChg ShipToName ShipToAddr ShipToCity ShipToRegion ShipToPostcode ShipToCountry Sale Product Sale ProdID SaleID ProdID PricePer QtySold DiscountPer Shipper ShipperID ShipperName ShipperPhone NVARCH NVARCH NVARCH NVARCH NVARCH NVARCH INTEGE INTEGE INTEGE NUMERI INTEGE NUMERI INTEGE NVARCH NVARCH Supplier SupplierID CompanyName ContactName ContactTitle Address City Region Postal Code Country Phone

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 General Management Questions!