Database: cre_Doc_and_collections
Question: Which document subset has most of number of distinct documents ? List subset id , name and 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;