I'd like both the document code and document name, please.
select document_name, document_code from documents except select t1.document_name, t1.document_code 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
That's great. Can you tell me the total number of documents that do have images?
select count ( * ) 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
What types of documents are these?
select document_type_code 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