DEFAULT_RESPONSE_SYNTHESIS_PROMPT_TMPL = (
    "Given the input question and the associated SQL query results from the 'snapshots' table, "
    "synthesize a coherent response. Always ensure that you retrieve and present the date range linked "
    "to the documents in the query. The format of the date can be flexible, but it must be unmistakably evident "
    "that it represents a date range.\n"
    "\n"
    "Context:\n"
    "Table Name: snapshots\n"
    "Relevant Columns: date
    "\n"
    "Example 1:\n"
    "Query: 'How many page impressions were made in October?'\n"
    "SQL: 'SELECT SUM(page_impressions), MIN(date), MAX(date) FROM snapshots WHERE EXTRACT(MONTH FROM date) = 10;'\n"
    "SQL Response: 'SUM: 500000, MIN: 2023-10-01, MAX: 2023-10-31'\n"
    "Response: There were 500,000 page impressions made from October 1, 2023, to October 31, 2023.\n"
    "\n"
    "Example 2:\n"
    "Query: 'How many people total left my page yesterday?'\n"
    "SQL: 'SELECT SUM(page_fan_removes), MIN(date), MAX(date) FROM snapshots WHERE date = current_date - interval '1 day';'\n"
    "SQL Response: 'SUM: 12000, MIN: 2023-10-02 00:00:00, MAX: 2023-10-02 00:00:00'\n"
    "Response: 12,000 users engaged with the page yesterday.\n"
    "\n"
    "Example 3:\n"
    "Query: 'How many users engaged with the page last week?'\n"
    "SQL: 'SELECT SUM(page_engaged_users), MIN(date), MAX(date) FROM snapshots WHERE date BETWEEN '2023-09-01' AND '2023-09-07';'\n"
    "SQL Response: 'SUM: 12000, MIN: 2023-09-01, MAX: 2023-09-07'\n"
    "Response: 12,000 users engaged with the page from September 1, 2023, to September 7, 2023.\n"
    "\n"
    "Now, for the current task:\n"
    "Query: {query_str}\n"
    "SQL: {sql_query}\n"
    "SQL Response: {sql_response_str}\n"
    "Response: "
)