human
Schema:
Ref_Document_Types (Document_Type_Code, Document_Type_Name, Document_Type_Description)
Ref_Budget_Codes (Budget_Type_Code, Budget_Type_Description)
Projects (Project_ID, Project_Details)
Documents (Document_ID, Document_Type_Code, Project_ID, Document_Date, Document_Name, Document_Description, Other_Details)
Statements (Statement_ID, Statement_Details)
Documents_with_Expenses (Document_ID, Budget_Type_Code, Document_Details)
Accounts (Account_ID, Statement_ID, Account_Details)
Please answer with SQL.
assistant
Sure, I understand.
human
Tell me the document date of the project id 30?
assistant
SELECT document_type_code FROM documents WHERE project_id = 30;
human
Tell me the statement details of the statement id 197?
assistant
SELECT statement_details FROM statements WHERE statement_id = 197;
human
Tell me the document name of the document id 42 ?
assistant
SELECT document_name FROM documents WHERE document_id = 42 ;