Microsoft
DP-900 · Question #140
Drag and Drop Question You have a table named Sales that contains the following data. You need to query the table to return the average sales amount day. The output must produce the following results
Sign in or unlock DP-900 to reveal the answer and full explanation for question #140. The question stem and answer options stay visible for context.
Submitted by hans_de· Mar 30, 2026Writing T-SQL queries using aggregate functions and grouping - commonly tested in Microsoft certifications such as DP-080 (Querying Data with Microsoft Transact-SQL) or AZ-900/DP-900 data fundamentals tracks.
Question
Drag and Drop Question You have a table named Sales that contains the following data. You need to query the table to return the average sales amount day. The output must produce the following results How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:
Exhibits
Answer Area
Drag items
CREATEGROUP BYORDER BYSELECT
Unlock DP-900 to see the answer
You've previewed enough free DP-900 questions. Unlock DP-900 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL Aggregation#GROUP BY#AVG Function#T-SQL Querying