Which query will retrieve the names of all document owners and provide a count of the number of documents each user owns?

Question

Options

• Aselect "owner_name", count(*) from "dm_document" group by "owner_name"
• Bselect "owner_name", count(*) from "dm_document" order by "owner_name"
• Cselect "owner_name", count(*) from "dm_document" having owner_name like '%'
• Dselect distinct "owner_name", count(*) from "dm_document"

• A
  80% (24)
• B
  13% (4)
• C
  3% (1)
• D
  3% (1)

No community discussion yet for this question.