Hans Eisenman1,315 Points
Having a little trouble with this derived table query. Error I'm getting is just "Bummer: try again!" :-\
This is my first derived table query and I'm not sure what I'm doing wrong. Would appreciate any help.
Steven Parker177,727 Points
You don't need to join the entire Customer table here. The instructions say they want only the "Sale" table columns, so the only thing you need from the Customer table is the CustomerID to join on:
SELECT * FROM Sale AS s INNER JOIN (SELECT CustomerID FROM Customer WHERE Gender = 'F') AS c ON s.CustomerID = c.CustomerID;