AlisdairO / pgexercises

PostgreSQL Exercises web site code
Other
400 stars 62 forks source link

Joins - self join 2 right answer seemingly incorrect #34

Closed kennes913 closed 6 years ago

kennes913 commented 6 years ago

URL: https://www.pgexercises.com/questions/joins/self2.html

Question is How can you output a list of all members, including the individual who recommended them (if any)? Ensure that results are ordered by (surname, firstname).

memfname, memsname combinations should be unique by nature of question, but I see this in the correct response:

screen shot 2017-10-23 at 5 15 27 pm
AlisdairO commented 6 years ago

Hey, in this case, the issue you're running into is that there are two members named 'Darren Smith' in the dataset, so it's correct for this case.