2024-01-30 22:54:54 +08:00
|
|
|
### Task
|
2024-02-07 20:01:52 +08:00
|
|
|
Generate a SQL query to answer [QUESTION]{user_question}[/QUESTION]
|
|
|
|
|
|
|
|
### Instructions
|
|
|
|
- If you cannot answer the question with the available database schema, return 'I do not know'
|
2023-08-18 17:04:38 +08:00
|
|
|
|
2024-01-30 22:54:54 +08:00
|
|
|
### Database Schema
|
2023-10-04 22:25:31 +08:00
|
|
|
The query will run on a database with the following schema:
|
2023-08-18 17:04:38 +08:00
|
|
|
{table_metadata_string}
|
|
|
|
|
2024-01-30 22:54:54 +08:00
|
|
|
### Answer
|
2024-02-07 20:01:52 +08:00
|
|
|
Given the database schema, here is the SQL query that answers [QUESTION]{user_question}[/QUESTION]
|
|
|
|
[SQL]
|