DP-900 Question 73

Question

DRAG DROP You have a table named Sales that contains the following data. *(refer to diagram in explanation below)* You need to query the table to return the average sales amount per day. The output must produce the following results. *(refer to diagram in explanation below)* 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.

Accepted Answer

Hotspot Solution:
### Recommended Community Solution:
SELECT - to have any results, you need a SELECT statement. GROUP BY - The sales date is our criteria of aggregating the rows. Because there is an AVG() function call in the SELECT, the resulting groups will have 1 row each, resulting in the table below

DP-900 Question 73

Explanation

Recommended Community Solution:

Community Discussion

Preparing Practice Exam…

DP-900 Question 73

Explanation

Recommended Community Solution:

Community Discussion