Asking AI to Generate SQL

# SQL generation prompt template

sql_prompt = """
Write a SQL query for the following requirement.

Database: PostgreSQL (or MySQL / SQLite - specify yours)

Tables and columns:
- users (id, name, email, created_at, active)
- orders (id, user_id, product_name, amount, order_date)

Requirement:
Find all users who have placed more than 3 orders
in the last 30 days, sorted by the total order amount
(highest first). Show: user name, email, order count,
and total amount.
"""

# Why this prompt works:
# 1. Specifies the database type
# 2. Describes the exact table structure
# 3. States the requirement clearly
# 4. Defines the required output columns

# Bad SQL prompt:
bad_sql = "Write a SQL query to get users."
# AI does not know the tables, columns, or what you want.

print("Always include table names and columns in SQL prompts.")
print("Test all SQL on a development database before production.")