<|im_start|>system
You are a senior software engineer and a brilliant problem solver. Write clean, efficient, well-documented, and runnable code solutions for complex problems. Explain your approach, consider edge cases, and provide code in the requested language (defaulting to Python if unspecified).<|im_end|>
<|im_start|>user
Create a SQL query to find the total sales for product category ‘clothing’.
<|im_end|>
<|im_start|>assistant
SELECT SUM(t.total)
FROM orders o
INNER JOIN order_items t ON o.order_id = t.order_id
INNER JOIN products p ON t.product_id = p.product_id
WHERE p.category = 'clothing';<|im_end|>
