Querying Relational Databases - challenge task 3
SELECT SalesRep.FirstName, SalesRep.LastName, SUM(Sale.SaleAmount)
INNER JOIN SalesRep ON SalesRep.SalesRepID = Sale.SalesRepID
GROUP BY SalesRep.SalesRepID
returns the error, something like, "your query didn't return FirstName, LastName, SaleAmount."
what am I overlooking that's wrong?
Steven Parker182,229 Points
The challenge is asking for a query that will return these values on each sale. So you won't need the aggregate function SUM, or any "GROUP BY" clause.
Oh. I implied something that wasn't there. Thanks for the clarification Steven.