Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can some one help me with this? Q CUR 1 10 Flashcards Google Translate SQL Server TRANSL SQLSERVER Tryit Ed O Quiz: Q uz 02-SQL

image text in transcribed

Can some one help me with this?

Q CUR 1 10 Flashcards Google Translate SQL Server TRANSL SQLSERVER Tryit Ed O Quiz: Q uz 02-SQL G select distinct in sq G xyz sql meaning-C + https://canvas.csun.edu/courses/52563/quizzes/126944/take D Question 2 20 pts CSUN While OrderDate is typically on the Sales Orders and not on the SOLines, I assume the OrderDate is allso on the SOLines to simplify the SQL code. SELECT DISTINCT ItemD FROM SOLines WHERE DATEPART ywy. OrderDate) 2018 [ Choose] What is the average sales order line amount in 2018? Which customers bought a specific combination of items? How much did we sell in 2018? I Choosel SELECT COUNT IDISTINCT temID) FROM SOLines WHERE DATEPART wy Orde Date)- 2018 Choosel Who ordered a specific item in 2018? Courses Which Items were sold in 2018? Which Items were not sold in 2018? Which products did a specific customer buy in 2018? Groups SELECT DISTINCT ItemiD CustomeritD FROM SOLines WHERE DATEPART (y. Orde Date- 2018 AND CustomeriD- abcde I Choose ] List Customers in terms of amount sold in 2018. How many orders did customers place individually in 2018? How many different items were sold in 2018? Which Customers did not purchase anything from us in 2018? Calendar SELECT COUNT ISOIDI FROM SalesOrders WHERE DATEPART tywy.OrderDate) 2018 Inbox IChoose Help & Lbrary SELECT SUM ExtAmcurn FROM SOLines hoyse WHERE DATEPART wwy. OrderDate)- 2018 SELECT ItemD, CustomeriD FROM SalesOrders WHERE ItemiD xy2 AND DATEPART (vyyy. OrderDatel-2018 IChoose SELECT CustomerName FROM SOUnesChoose l WHERE ItemiD abc AND ItemlD a xyz AND ItemiD mno SELECT CustomeriD, SUM (ExtAmount) AS Total Sales" FROM SalesOrders WHERE DATEPART (ywyy OrderDatel-2018 ORDER BY Total Sales Choosel SELECT AVE IQty Price) FROM SOLines WHERE DATEPARTlwww. OrderDate)- 2018 IChoose SELECT SUM I Qty . Prid AS "Total Sold' FROM SalesOrders WHERE DATEPART I Choose ywwy. OrderDatel-2018 3:24 PM 4 2/22/2019

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Logidata+ Deductive Databases With Complex Objects Lncs 701

Authors: Paolo Atzeni

1st Edition

354056974X, 978-3540569749

More Books

Students also viewed these Databases questions

Question

4. Identify cultural variations in communication style.

Answered: 1 week ago