Database: document_management
Question: What are the names of documents that have both one of the three most common types and one of three most common structures?
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