Make a list of buyers who made more than 2 orders. The result is sorted alphabetically by the last names of the buyers. The problem here is "COUNT (*) AS buyersShopping" and here "buyersShopping> 2".

SELECT Orders.personalNumberBuyer, Buyers.name, COUNT(*) AS buyersShopping FROM Orders, Buyers WHERE Buyers.personalNumber = Orders.personalNumberBuyer AND buyersShopping > 2 /* Что-то в этом духе */ GROUP BY Orders.personalNumberBuyer, Buyers.name ORDER BY Buyers.name ASC

Result without checking for qty Base diagram

    1 answer 1

     SELECT Orders.personalNumberBuyer, Buyers.name, COUNT(*) AS buyersShopping FROM Orders, Buyers WHERE Buyers.personalNumber = Orders.personalNumberBuyer GROUP BY Orders.personalNumberBuyer, Buyers.name having COUNT(*) > 2 ORDER BY Buyers.name ASC

    Having