SHARE
TWEET

Untitled

a guest Apr 23rd, 2019 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> SELECT `player`.`role`, `wizard`.`firstname`, `wizard`.`lastname`, `team`.`name` FROM `wizard` LEFT JOIN `player` ON `wizard`.`id` = `player`.`wizard_id` LEFT JOIN `team` ON `team`.`id` = `player`.`team_id` ORDER BY `role`,`name`,`lastname`,`firstname` ASC;
  2. +--------+-------------+-----------------+------------+
  3. | role   | firstname   | lastname        | name       |
  4. +--------+-------------+-----------------+------------+
  5. | NULL   | Crabbe      |                 | NULL       |
  6. | NULL   | Terry       | Boot            | NULL       |
  7. | NULL   | Remus       | Lupin           | NULL       |
  8. | NULL   | Padma       | Patil           | NULL       |
  9. | NULL   | Parvati     | Patil           | NULL       |
  10. | NULL   | Demelza     | Robins          | NULL       |
  11. | NULL   | Horace      | Slughorn        | NULL       |
  12. | NULL   | Charles     | Weasley         | NULL       |
  13. | NULL   | Molly       | Weasley         | NULL       |
  14. | beater | Sirius      | Black           | Gryffindor |
  15. | beater | Lavender    | Brown           | Gryffindor |
  16. | beater | Seamus      | Finnigan        | Gryffindor |
  17. | beater | Rubeus      | Hagrid          | Gryffindor |
  18. | beater | Alice       | Longbottom      | Gryffindor |
  19. | beater | Minerva     | McGonagall      | Gryffindor |
  20. | beater | Harry       | Potter          | Gryffindor |
  21. | beater | James       | Potter          | Gryffindor |
  22. | beater | Dean        | Thomas          | Gryffindor |
  23. | beater | Arthur      | Weasley         | Gryffindor |
  24. | beater | Percy       | Weasley         | Gryffindor |
  25. | beater | Hannah      | Abbott          | Hufflepuff |
  26. | beater | Justin      | Finch-Fletchley | Hufflepuff |
  27. | beater | Fat         | Friar           | Hufflepuff |
  28. | beater | Hepzibah    | Smith           | Hufflepuff |
  29. | beater | Pomona      | Sprout          | Hufflepuff |
  30. | beater | Nymphadora  | Tonks           | Hufflepuff |
  31. | beater | Penelope    | Clearwater      | Ravenclaw  |
  32. | beater | Quirinus    | Quirrell        | Ravenclaw  |
  33. | beater | Helena      | Ravenclaw       | Ravenclaw  |
  34. | beater | Myrtle      | Warren          | Ravenclaw  |
  35. | beater | Millicent   | Bulstrode       | Slytherin  |
  36. | beater | Vincent     | Crabbe          | Slytherin  |
  37. | beater | Marcus      | Flint           | Slytherin  |
  38. | beater | Pansy       | Parkinson       | Slytherin  |
  39. | beater | Severus     | Snape           | Slytherin  |
  40. | beater | Blaise      | Zabini          | Slytherin  |
  41. | chaser | Katie       | Bell            | Gryffindor |
  42. | chaser | Albus       | Dumbledore      | Gryffindor |
  43. | chaser | Hermione    | Granger         | Gryffindor |
  44. | chaser | Lily        | J.              | Gryffindor |
  45. | chaser | Lee         | Jordan          | Gryffindor |
  46. | chaser | Augusta     | Longbottom      | Gryffindor |
  47. | chaser | Frank       | Longbottom      | Gryffindor |
  48. | chaser | Neville     | Longbottom      | Gryffindor |
  49. | chaser | Peter       | Pettigrew       | Gryffindor |
  50. | chaser | Alicia      | Spinnet         | Gryffindor |
  51. | chaser | George      | Weasley         | Gryffindor |
  52. | chaser | Oliver      | Wood            | Gryffindor |
  53. | chaser | Amelia      | Bones           | Hufflepuff |
  54. | chaser | Newton      | Scamander       | Hufflepuff |
  55. | chaser | Cho         | Chang           | Ravenclaw  |
  56. | chaser | Marietta    | Edgecombe       | Ravenclaw  |
  57. | chaser | Filius      | Flitwick        | Ravenclaw  |
  58. | chaser | Anthony     | Goldstein       | Ravenclaw  |
  59. | chaser | Gilderoy    | Lockhart        | Ravenclaw  |
  60. | chaser | Luna        | Lovegood        | Ravenclaw  |
  61. | chaser | Xenophilius | Lovegood        | Ravenclaw  |
  62. | chaser | Garrick     | Ollivander      | Ravenclaw  |
  63. | chaser | Bloody      | Baron           | Slytherin  |
  64. | chaser | Bellatrix   | Lestrange       | Slytherin  |
  65. | chaser | Rodolphus   | Lestrange       | Slytherin  |
  66. | chaser | Draco       | Malfoy          | Slytherin  |
  67. | chaser | Lucius      | Malfoy          | Slytherin  |
  68. | chaser | Phineas     | Nigellus        | Slytherin  |
  69. | chaser | Theodore    | Nott            | Slytherin  |
  70. | chaser | Tom         | Riddle          | Slytherin  |
  71. | chaser | Andromeda   | Tonks           | Slytherin  |
  72. | keeper | Cadogan     |                 | Gryffindor |
  73. | keeper | Dennis      | Creevey         | Gryffindor |
  74. | keeper | Nicholas    | de              | Gryffindor |
  75. | keeper | Aberforth   | Dumbledore      | Gryffindor |
  76. | keeper | Angelina    | Johnson         | Gryffindor |
  77. | keeper | Ginevra     | Weasley         | Gryffindor |
  78. | keeper | Susan       | Bones           | Hufflepuff |
  79. | keeper | Cedric      | Diggory         | Hufflepuff |
  80. | keeper | Zacharias   | Smith           | Hufflepuff |
  81. | keeper | Regulus     | Black           | Slytherin  |
  82. | seeker | Cuthbert    | Binns           | Gryffindor |
  83. | seeker | Colin       | Creevey         | Gryffindor |
  84. | seeker | Godric      | Gryffindor      | Gryffindor |
  85. | seeker | Romilda     | Vane            | Gryffindor |
  86. | seeker | Fred        | Weasley         | Gryffindor |
  87. | seeker | Ronald      | Weasley         | Gryffindor |
  88. | seeker | William     | Weasley         | Gryffindor |
  89. | seeker | Helga       | Hufflepuff      | Hufflepuff |
  90. | seeker | Michael     | Corner          | Ravenclaw  |
  91. | seeker | Rowena      | Ravenclaw       | Ravenclaw  |
  92. | seeker | Sybill      | Trelawney       | Ravenclaw  |
  93. | seeker | Gregory     | Goyle           | Slytherin  |
  94. | seeker | Rabastan    | Lestrange       | Slytherin  |
  95. | seeker | Narcissa    | Malfoy          | Slytherin  |
  96. | seeker | Salazar     | Slytherin       | Slytherin  |
  97. | seeker | Dolores     | Umbridge        | Slytherin  |
  98. +--------+-------------+-----------------+------------+
  99. 93 rows in set (0,00 sec)
  100.  
  101.  
  102. mysql> SELECT `wizard`.`firstname`, `wizard`.`lastname`, `player`.`role` FROM `wizard` LEFT JOIN `player` ON `wizard`.`id` = `player`.`wizard_id`  WHERE (( `role` = "seeker")) ORDER BY `lastname`, `firstname` ASC;
  103. +-----------+------------+--------+
  104. | firstname | lastname   | role   |
  105. +-----------+------------+--------+
  106. | Cuthbert  | Binns      | seeker |
  107. | Michael   | Corner     | seeker |
  108. | Colin     | Creevey    | seeker |
  109. | Gregory   | Goyle      | seeker |
  110. | Godric    | Gryffindor | seeker |
  111. | Helga     | Hufflepuff | seeker |
  112. | Rabastan  | Lestrange  | seeker |
  113. | Narcissa  | Malfoy     | seeker |
  114. | Rowena    | Ravenclaw  | seeker |
  115. | Salazar   | Slytherin  | seeker |
  116. | Sybill    | Trelawney  | seeker |
  117. | Dolores   | Umbridge   | seeker |
  118. | Romilda   | Vane       | seeker |
  119. | Fred      | Weasley    | seeker |
  120. | Ronald    | Weasley    | seeker |
  121. | William   | Weasley    | seeker |
  122. +-----------+------------+--------+
  123. 16 rows in set (0,00 sec)
  124.  
  125. mysql> SELECT `wizard`.`firstname`, `wizard`.`lastname`, `player`.`role` FROM `wizard` LEFT JOIN `player` ON `wizard`.`id` = `player`.`wizard_id`  WHERE `role` IS NULL;
  126. +-----------+----------+------+
  127. | firstname | lastname | role |
  128. +-----------+----------+------+
  129. | Terry     | Boot     | NULL |
  130. | Crabbe    |          | NULL |
  131. | Remus     | Lupin    | NULL |
  132. | Padma     | Patil    | NULL |
  133. | Parvati   | Patil    | NULL |
  134. | Demelza   | Robins   | NULL |
  135. | Horace    | Slughorn | NULL |
  136. | Charles   | Weasley  | NULL |
  137. | Molly     | Weasley  | NULL |
  138. +-----------+----------+------+
  139. 9 rows in set (0,01 sec)
  140.  
  141. mysql>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top