CompTIA
DA0-002 · Question #49
A table contains several rows of cellular numbers with call timestamps, call durations, called numbers, and carriers of the called number. Which of the following allows a data analyst to sort the cell
Sign in or unlock DA0-002 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
Data Analysis
Question
A table contains several rows of cellular numbers with call timestamps, call durations, called numbers, and carriers of the called number. Which of the following allows a data analyst to sort the cellular numbers based on the carriers of the called numbers and include the total call durations?
Options
- ASELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY
- BSELECT cellular_number, SUM(call_duration) FROM calls GROUP BY call_duration ORDERBY
- CSELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY
- DSELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY
Unlock DA0-002 to see the answer
You've previewed enough free DA0-002 questions. Unlock DA0-002 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#Aggregate Functions#GROUP BY Clause#Data Querying