Database: cre_Doc_and_collections
Question: For the document subset with the most number of different documents , what are the ids and names of the subset , as well as the number of documents ?
SQL:
select t1.document_subset_id ,  t2.document_subset_name , count(distinct t1.document_object_id) from document_subset_members as t1 join document_subsets as t2 on t1.document_subset_id =  t2.document_subset_id group by t1.document_subset_id order by count(*) desc limit 1;