Skip to content
DEVDIGEST
⌘K
Videos
Blog
AI Tools
About
Subscribe
Watch
Skip to content
DEVDIGEST
⌘K
Videos
Blog
AI Tools
About
Subscribe
Watch
SQL
Paste SQL, get clean output. Auto-formats on paste.
select u.id, u.name, u.email, p.bio, count(o.id) as order_count from users u left join profiles p on p.user_id = u.id left join orders o on o.user_id = u.id where u.is_active = true and u.created_at > '2025-01-01' and u.email not like '%test%' group by u.id, u.name, u.email, p.bio having count(o.id) > 0 order by order_count desc limit 50 offset 10
Pretty
Compact