MENU
You have a record type, ABC_Author, backed by a database table. You need to retrieve the number of authors for each country. Review the following basic query expression: Which code snippet should be added to the fields parameter?
A)
B)
C)
D)
Suggested Answer: B
Get Premium ACD101 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
5 comments · newest first
RI
Rikki
3 days ago
Option B looks solid for counting authors by country.
HE
Helaine
9 days ago
I think we should be looking for a snippet that uses COUNT and GROUP BY, but I’m torn between Options A and D.
AL
Alex
14 days ago
I feel like Option C looks familiar, but I can't remember if it includes the necessary aggregation function.
AS
Ashley
19 days ago
I remember practicing a similar question where we had to count records, but I can't recall the exact syntax for this one.
BR
Brett
24 days ago
I think we need to group by country to get the count of authors, but I'm not sure which option does that correctly.