Hello! How many documents are there total?
select count ( document_name ) from documents
Perfect, thanks for that. Now, how many documents don't have images?
select count ( * ) from ( select document_name from documents except select t1.document_name from documents as t1 join document_sections as t2 on t1.document_code = t2.document_code join document_sections_images as t3 on t2.section_id = t3.section_id )
Can you give me the names of those documents?
select document_name from documents except select t1.document_name from documents as t1 join document_sections as t2 on t1.document_code = t2.document_code join document_sections_images as t3 on t2.section_id = t3.section_id