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
Find the list of documents that are both in the most three popular type and have the most three popular structure.
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
select document_name from documents group by document_type_code order by count ( * ) desc limit value intersect select document_name from documents group by document_structure_code order by count ( * ) desc limit value
Find the list of documents that are both in the most three popular type and have the most three popular structure .