Prompt
“Draw a simple visual with boxes and arrows that shows what this SQL query is doing—like a mini flowchart.”
SELECT titles.pub_id, AVG(titles.price)
FROM titles INNER JOIN publishers
ON titles.pub_id = publishers.pub_id
WHERE publishers.state = 'CA'
GROUP BY titles.pub_id
HAVING AVG(price) > 10
Model
I tested this prompt using ChatGPT 4o.
Result
