SELECT*
FROM products
WHERE price>1000 AND stock > 50;
SELECT c.name,o.order_id,o.total_amount
FROM orders o
JOIN customers c ON o.customers_id=c.customer_id
WheRE o.order_status='已完成';
SELECT category,SUM(stock)AS total_stock,AVG(price)AS avg_price
FROM products
GROUP BY category
SELECT*
FROM customers
WHERE customer_id NOT IN(SELECT DISTIMCTcustomer_id
FROM orders)
SELECT DISTINCT c.*
FROM customers c
JOIN orders o ON c.customer_id=o.customer_id
JOIN order_items oi ON o.order_id=oi.order_id
JOIN products p ON oi.products_id=p.product_id
WHERE c.member_level='黄金'
AND p.category='手机类'
AND o.total_amount>5000;