>SELECT OrderID, COUNT(*), COUNT(Lineitems.Quantity > 500) FROM Orders INNER JOIN Lineitems on Lineitems.orderid = Orders.orderid GROUP BY 1 >>
SELECT OrderID, COUNT(*), sum(iif(lineItems.quantity > 500, 1, 0)) as bigQuantity ; FROM Orders ; INNER JOIN Lineitems on Lineitems.orderid = Orders.orderid ; GROUP BY 1Yes, the 500 can be a view parameter.