SELECT City, COUNT(Clients.ClientNo) AS AmountOfClients, Orders.Pieces*products.Price    TotalPrice
FROM Clients
INNER JOIN ClientOrder ON Clients.ClientNo = ClientOrder.ClientNo
INNER JOIN Orders ON ClientOrder.OrderNo = Orders.OrderNo
INNER JOIN products ON Orders.ProductNo = products.ProductNo
GROUP BY City, ClientOrders.Pieces, products.Price
HAVING COUNT(Clients.ClientNo) > 1