What are the response received dates for the documents described as 'Regular'?
select t1.response_received_date from documents as t1 join document_types as t2 on t1.document_type_code = t2.document_type_code join grants as t3 on t1.grant_id = t3.grant_id where t2.document_description = 'Regular'
What are the response received dates for the documents with a grant amount more than 100?
select t1.response_received_date from documents as t1 join document_types as t2 on t1.document_type_code = t2.document_type_code join grants as t3 on t1.grant_id = t3.grant_id where t3.grant_amount > 100
How many documents have the document description "Initial Application"?
select count ( * ) from documents as t1 join document_types as t2 on t1.document_type_code = t2.document_type_code join grants as t3 on t1.grant_id = t3.grant_id where t2.document_description = 'Initial Application'
Can you list all of the grant start dates of those documents please?
select t3.grant_start_date from documents as t1 join document_types as t2 on t1.document_type_code = t2.document_type_code join grants as t3 on t1.grant_id = t3.grant_id where t2.document_description = 'Initial Application'
What are the grant amounts of those?
select t3.grant_amount from documents as t1 join document_types as t2 on t1.document_type_code = t2.document_type_code join grants as t3 on t1.grant_id = t3.grant_id where t2.document_description = 'Initial Application'