Answered step by step
Verified Expert Solution
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
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/2019Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started