Database: document_management
Question: Find the list of documents that are both in the most three popular type and have the most three popular structure.
SQL:
SELECT document_name FROM documents GROUP BY document_type_code ORDER BY count(*) DESC LIMIT 3 INTERSECT SELECT document_name FROM documents GROUP BY document_structure_code ORDER BY count(*) DESC LIMIT 3