What is the project detail for the project with document "King Book"?
select t1.project_details from projects as t1 join documents as t2 on t1.project_id = t2.project_id where t2.document_name = "King Book"
What is the document date for the project with document "King Book"?
select t2.document_date from projects as t1 join documents as t2 on t1.project_id = t2.project_id where t2.document_name = "King Book"
How many documents are there with the document type code "CV"?
select count ( t2.document_date ) from projects as t1 join documents as t2 on t1.project_id = t2.project_id where t2.document_type_code = "CV"
How many documents are there with the document type code "BK"?
select count ( t2.document_date ) from projects as t1 join documents as t2 on t1.project_id = t2.project_id where t2.document_type_code = "BK"
What are the document dates of all documents with the document type code "BK"?
select t2.document_date from projects as t1 join documents as t2 on t1.project_id = t2.project_id where t2.document_type_code = "BK"