Q: 13
DRAG DROP 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.
Drag & Drop
Discussion
Nah, CREATE and ORDER BY are tricks here. It should be SELECT for Target 1 and GROUP BY for Target 2, since you need aggregation by date not just sorting. Seen similar questions on practice exams.
SELECT -> Target 1, GROUP BY -> Target 2
It should be SELECT and then GROUP BY. You need SELECT to choose what columns/aggregations to show, and GROUP BY to aggregate averages by date. CREATE is a distractor here, that’s for table definitions not queries. I’m pretty sure this matches the needed output, but if anyone disagrees let me know.
It should be SELECT and then GROUP BY. You need SELECT to choose what columns/aggregations to show, and GROUP BY to aggregate averages by date. CREATE is a distractor here, that’s for table definitions not queries. I’m pretty sure this matches the needed output, but if anyone disagrees let me know.
SELECT -> Target 1, GROUP BY -> Target 2. Seen similar on the official practice-GROUP BY is needed anytime you aggregate with a non-aggregated column, not ORDER BY. Pretty confident, but always best to double-check the learning path.
SELECT for Target 1, GROUP BY for Target 2. This matches what you need to average by date, pretty sure that's it but open to other ideas.
CREATE -> Target 1, ORDER BY -> Target 2
I thought ORDER BY was for sorting by date like in the output example, and CREATE since it feels like building a new result. Not sure if GROUP BY is really needed if averaging, but this is what I'd try first. ORDER BY might be a trap but looks right to me.
CREATE first, ORDER BY for the second target. I figured CREATE since we're making a new result set, and ORDER BY would sort it by date like the output table. Not totally sure but GROUP BY seemed odd here since we just want averages.
SELECT, CREATE. I think CREATE goes in the second spot because we're building something new here (maybe a view?), and SELECT obviously starts a query. Not super sure, but that's how I'd map them. Anyone see where I messed up?
Be respectful. No spam.
