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
List all the document names which contains 'CV'.
assistant
SELECT document_name FROM documents WHERE document_name LIKE '%CV%'
human
Find the total access count of all documents in the most popular document type.
assistant
SELECT sum(access_count) FROM documents GROUP BY document_type_code ORDER BY count(*) DESC LIMIT 1
human
Find the name and access counts of all documents, in alphabetic order of the document name.
assistant
SELECT document_name , access_count FROM documents ORDER BY document_name
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
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
Return the name of the document that has the most 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 ;