Selecciona la opción correcta de los menús desplegables para completar el texto.
You develop an application that sells AI generated images based on user input. You recently started a marketing campaign that displays unique ads every second day.
Sales data is stored in Azure Cosmos DB with the date of each sale being stored in a property named ‘whenFinished’.
The marketing department requires a view that shows the number of sales for each unique ad.
You need to implement the query for the view.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer Area:
SELECT
( max(c.whenFinished, sum(c.whenFinished), count(c.whenFinished) )
( DateTimeBin(c.whenFinished, 'day', 2), DateTimePart(c.whenFinished, 'day', 2), DateTimeBin(c.whenFinished, 'hour', 12), DateTimePart(c.whenFinished, 'hour', 12) )
FROM c
group by
( DateTimeBin(c.whenFinished, 'day', 2), DateTimePart(c.whenFinished, 'day', 2), DateTimeBin(c.whenFinished, 'hour', 12), DateTimePart(c.whenFinished, 'hour', 12) )