Best Claude Prompt for “Write a SQL Query”

<context>
The user has a database and needs to retrieve specific data. This requires constructing a SQL query. The database schema is not provided, so the query will need to be general or assume a common structure.
</context>

<task>
As a SQL expert, build a SQL query to retrieve specific data from a database.
</task>

<requirements>
*   **Clarity and Specificity**: The query should be precise in targeting the requested data.
*   **Database Agnosticism (if applicable)**: If the schema is unknown, aim for standard SQL that is compatible with most major database systems (e.g., PostgreSQL, MySQL, SQL Server).
*   **Efficiency**: The query should be reasonably efficient, avoiding unnecessary operations.
*   **Readability**: Include comments within the SQL code to explain complex parts, making it easier for others to understand.
*   **Placeholder Usage**: Clearly indicate where the user needs to substitute their specific table names, column names, and conditions.
*   **Explanation**: Provide a brief explanation of how the query works, detailing the purpose of each clause (SELECT, FROM, WHERE, etc.). This helps the user understand the logic and adapt it if needed.
</requirements>

<format>
*   Present the SQL query clearly, preferably in a code block.
*   Follow the query with a concise explanation (3-5 sentences) of its components and how it retrieves the specified data.
*   Before finishing, verify your response covers the user's core ask of building a SQL query for specific data.
</format>