I need help I want to "List the ID, first and last name of all customers who are male and have purchased 10 books or more."
*
(SELECT CustomerID, CustomerGender, CustomerFirstName, CustomerLastName FROM tbl_Customer WHERE Gender = “M” AND BuyingOrderLineQuantity FROM tbl_CustomerBuyingOrderLine >=10)
It doesn't work, just says "Syntax ERROR".
I need it in SQL format please