توثيق SQL بالعربية
مرجع شامل ومتكامل

-- مثال على استعلام SQL لاسترجاع بيانات المبيعات
SELECT p.product_name, 
       c.category_name,
       SUM(o.quantity) AS total_sold,
       ROUND(AVG(p.price), 2) AS avg_price
FROM products p
JOIN categories c
  ON p.category_id = c.id
JOIN order_items o
  ON p.id = o.product_id
WHERE o.order_date > '2023-01-01'
GROUP BY p.product_name, c.category_name
HAVING SUM(o.quantity) > 100
ORDER BY total_sold DESC
LIMIT 10;