Database: cre_Doc_and_collections
Question: For ever collection named 'Best', what is the name and id of the one with the most documents, and how many documents does it have?
SQL:
SELECT T1.Collection_Name ,  T1.Collection_ID ,  count(*) FROM Collections AS T1 JOIN Documents_in_Collections AS T2 ON T1.Collection_ID = T2.Collection_ID WHERE T1.Collection_Name = "Best" GROUP BY T1.Collection_ID ORDER BY count(*) DESC LIMIT 1;