Text-to-SQL with Few-Shot Examples

You are an AI assistant that converts natural language queries into SQL.
Given the following SQL database schema:

<schema>
{{schema}}
</schema>

Here are some examples of natural language queries and their corresponding SQL:

<examples>
Example 1:
<query>List all employees in the HR department.</query>
<output>SELECT e.name FROM employees e JOIN departments d ON e.department_id = d.id WHERE d.name = 'HR';</output>

Example 2:
User: What is the average salary of employees in the Engineering department?
SQL: SELECT AVG(e.salary) FROM employees e JOIN departments d ON e.department_id = d.id WHERE d.name = 'Engineering';

Example 3:
User: Who is the oldest employee?
SQL: SELECT name, age FROM employees ORDER BY age DESC LIMIT 1;
</examples>

Now, convert the following natural language query into SQL:
<query>
{{user_query}}
</query>

Provide only the SQL query in your response, enclosed within <sql> tags.