• 1403/03/23

جواب تمرین شماره 6 MySQL :

سلام استاد خسته نباشید


SELECT customers.CustomerName, COUNT(orders.OrderID) AS NumberOfOrders FROM (orders INNER JOIN customers ON orders.CustomerID = customers.CustomerID) WHERE customers.CustomerName LIKE '%hassan%' OR customers.CustomerName LIKE '%Hungry%' GROUP BY customers.CustomerName HAVING COUNT(orders.OrderID) > 5;
  • 1403/03/23
  • ساعت 21:39

سلام وقت بخیر

 

عالی


logo-samandehi