mysql> SELECT lastname, firstname
    -> FROM wizard
    -> JOIN player ON wizard_id = wizard.id
    -> WHERE player.role = "seeker"
    -> ORDER BY lastname, firstname;
+------------+-----------+
| lastname   | firstname |
+------------+-----------+
| Binns      | Cuthbert  |
| Corner     | Michael   |
| Creevey    | Colin     |
| Goyle      | Gregory   |
| Gryffindor | Godric    |
| Hufflepuff | Helga     |
| Lestrange  | Rabastan  |
| Malfoy     | Narcissa  |
| Ravenclaw  | Rowena    |
| Slytherin  | Salazar   |
| Trelawney  | Sybill    |
| Umbridge   | Dolores   |
| Vane       | Romilda   |
| Weasley    | Fred      |
| Weasley    | Ronald    |
| Weasley    | William   |
+------------+-----------+
16 rows in set (0.00 sec)