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.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

To complete the sentence, select the appropriate option in the answer area.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

To complete the sentence, select the appropriate option in the answer area.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Comment: *

Name: *

Email: *

Verification: *

To complete the sentence, select the appropriate option in the answer area.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Comment: *

Name: *

Email: *

Verification: *

Select the answer that correctly completes the sentence.

Correct Answer:

Explanation
Table Description automatically generated

An aggregate function performs a calculation on a set of values, and returns a single value. The following are
aggregate functions:
* APPROX_COUNT_DISTINCT
* AVG
* CHECKSUM_AGG
* COUNT
* COUNT_BIG
* GROUPING
* GROUPING_ID
* MAX
* MIN
* STDEV
* STDEVP
* STRING_AGG
* SUM
* VAR
* VARP

Comment: *

Name: *

Email: *

Verification: *