麦田
园地
首页
留言板
手机归属地
城市区号
邮政区号
SQL格式化
JSON格式化
SQL格式化工具
格式化
压缩
清空
复制结果
验证SQL
美化
输入SQL
SELECT users.id, users.name, orders.order_date, SUM(order_items.quantity * products.price) AS total_amount FROM users JOIN orders ON users.id = orders.user_id JOIN order_items ON orders.id = order_items.order_id JOIN products ON order_items.product_id = products.id WHERE orders.order_date BETWEEN '2023-01-01' AND '2023-12-31' GROUP BY users.id, users.name, orders.order_date HAVING SUM(order_items.quantity * products.price) > 1000 ORDER BY total_amount DESC LIMIT 10;
格式化结果
示例SQL：
SELECT * FROM users WHERE status = 'active'...
INSERT INTO products (name, price, stock) VALUES...
UPDATE orders SET status = 'completed' WHERE id IN...