human
Schema:
Roles (role_code, role_description)
Users (user_id, role_code, user_name, user_login, password)
Document_Structures (document_structure_code, parent_document_structure_code, document_structure_description)
Functional_Areas (functional_area_code, parent_functional_area_code, functional_area_description)
Images (image_id, image_alt_text, image_name, image_url)
Documents (document_code, document_structure_code, document_type_code, access_count, document_name)
Document_Functional_Areas (document_code, functional_area_code)
Document_Sections (section_id, document_code, section_sequence, section_code, section_title)
Document_Sections_Images (section_id, image_id)
Please answer with SQL.
assistant
Sure, I understand.
human
Find all the name of documents without any sections.
assistant
SELECT document_name FROM documents WHERE document_code NOT IN (SELECT document_code FROM document_sections)
human
What are all the section titles of the document named 'David CV'?
assistant
SELECT t2.section_title FROM documents AS t1 JOIN document_sections AS t2 ON t1.document_code = t2.document_code WHERE t1.document_name = 'David CV'
human
Find the name of the document that has been accessed the greatest number of times, as well as the count of how many times it has been accessed?
assistant
SELECT document_name , access_count FROM documents ORDER BY access_count DESC LIMIT 1
human
What document types have more than 2 corresponding documents?
assistant
SELECT document_type_code FROM documents GROUP BY document_type_code HAVING count(*) > 2
human
What is the structure of the document with the least number of accesses?
assistant
SELECT t2.document_structure_description FROM documents AS t1 JOIN document_structures AS t2 ON t1.document_structure_code = t2.document_structure_code GROUP BY t1.document_structure_code ORDER BY count(*) DESC LIMIT 1
human
What is the name of the document with the most number of sections?
assistant
SELECT t1.document_name FROM documents AS t1 JOIN document_sections AS t2 ON t1.document_code = t2.document_code GROUP BY t1.document_code ORDER BY COUNT( * ) DESC LIMIT 1 ;