API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 12th, 2015
247
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.18 KB | None | 0 0
raw download clone embed print report
  1. mysql> SELECT * FROM players;
  2. +-----------+---------+----------------------+----------------------+-----------------+------------------------------+-----------------------+---------------------+
  3. | player_id | team_id | player_name | player_jersey_number | player_position | player_email | player_contact_number | player_timestamp |
  4. +-----------+---------+----------------------+----------------------+-----------------+------------------------------+-----------------------+---------------------+
  5. | 1 | 4 | Popoy Alfonso | 2 | | popoyalfonso@gmail.com | 09263453234 | 2015-08-05 00:48:10 |
  6. | 2 | 4 | Karlo Ripas | 10 | | karloripas@yahoo.com | 09212354324 | 2015-08-05 00:50:03 |
  7. | 3 | 4 | VHaughn Von | 32 | | von@outlook.com | 09361234565 | 2015-08-05 00:51:00 |
  8. | 4 | 4 | Lordie Zalbahe | 23 | | lordiezalbahe@gmail.com | 09391222334 | 2015-08-05 00:52:42 |
  9. | 5 | 4 | Jigs Selda | 8 | | jigsselda@gmail.com | 09325566323 | 2015-08-05 00:53:36 |
  10. | 6 | 4 | Rhan Garniel | 3 | | rhangarniel@ymail.com | 09129503400 | 2015-08-05 00:54:20 |
  11. | 7 | 5 | Johnritz Rodriguez | 11 | | johnritz@gmail.com | 09231112346 | 2015-08-05 00:56:02 |
  12. | 8 | 5 | Garret Van Sarmiento | 7 | | garretvansarmiento@gmail.com | 09264565600 | 2015-08-05 00:56:53 |
  13. | 9 | 5 | Lester Selda Lineses | 12 | | lesterlineses@yahoo.com | 09068746354 | 2015-08-05 00:57:47 |
  14. | 10 | 5 | Laurence Lineses | 44 | | laurencelineses@yahoo.com | 09847354672 | 2015-08-05 00:59:33 |
  15. | 11 | 5 | Xandrix Buendia | 1 | | xandrixbuendia@yahoo.com | 09234665590 | 2015-08-05 01:00:12 |
  16. | 12 | 5 | Betoyskie Limpiada | 45 | | betoyskie@outlook.com | 09213456667 | 2015-08-05 01:01:15 |
  17. +-----------+---------+----------------------+----------------------+-----------------+------------------------------+-----------------------+---------------------+
  18.  
  19. mysql> SELECT * FROM teams;
  20. +---------+-----------+----------------------+---------------------+
  21. | team_id | season_id | team_name | team_timestamp |
  22. +---------+-----------+----------------------+---------------------+
  23. | 4 | 1 | Quiapo A | 2015-08-05 00:30:13 |
  24. | 5 | 1 | Quiapo B | 2015-08-05 00:30:25 |
  25. | 6 | 1 | Balik-Balik Warriors | 2015-08-05 00:31:13 |
  26. | 7 | 1 | Adamson Falcons | 2015-08-05 00:31:42 |
  27. | 8 | 1 | Pasay Flooders | 2015-08-05 00:32:04 |
  28. | 9 | 1 | Marina Dragons | 2015-08-05 00:32:22 |
  29. | 10 | 1 | MDC Archers | 2015-08-05 00:33:12 |
  30. | 11 | 2 | Quiapo A | 2015-08-05 00:34:25 |
  31. | 12 | 2 | Quiapo B | 2015-08-05 00:34:38 |
  32. | 13 | 2 | Marikina Eagels | 2015-08-05 00:35:11 |
  33. | 14 | 2 | TIP Steallers | 2015-08-05 00:35:32 |
  34. | 15 | 2 | Gasan Blue Eagles | 2015-08-05 00:36:12 |
  35. +---------+-----------+----------------------+---------------------+
  36.  
  37. mysql> SELECT * FROM seasons;
  38. +-----------+-------------+----------------------+---------------------+
  39. | season_id | season_name | season_event_name | season_timestamp |
  40. +-----------+-------------+----------------------+---------------------+
  41. | 1 | Season 1 | Summer Games | 2015-08-05 00:23:15 |
  42. | 2 | Season 2 | Aniversary Sportfest | 2015-08-05 00:25:10 |
  43. +-----------+-------------+----------------------+---------------------+
  44.  
  45. SELECT teams.team_name, (SELECT COUNT(*) FROM teams INNER JOIN players ON teams.team_id = players.team_id) as num_of_players, teams.team_timestamp FROM teams INNER JOIN seasons ON seasons.season_id = teams.season_id GROUP BY teams.team_name;
  46.  
  47. +----------------------+----------------+---------------------+
  48. | team_name | num_of_players | team_timestamp |
  49. +----------------------+----------------+---------------------+
  50. | Adamson Falcons | 12 | 2015-08-05 00:31:42 |
  51. | Balik-Balik Warriors | 12 | 2015-08-05 00:31:13 |
  52. | Gasan Blue Eagles | 12 | 2015-08-05 00:36:12 |
  53. | Marikina Eagels | 12 | 2015-08-05 00:35:11 |
  54. | Marina Dragons | 12 | 2015-08-05 00:32:22 |
  55. | MDC Archers | 12 | 2015-08-05 00:33:12 |
  56. | Pasay Flooders | 12 | 2015-08-05 00:32:04 |
  57. | Quiapo A | 12 | 2015-08-05 00:30:13 |
  58. | Quiapo B | 12 | 2015-08-05 00:30:25 |
  59. | TIP Steallers | 12 | 2015-08-05 00:35:32 |
  60. +----------------------+----------------+---------------------+
  61.  
  62. +----------------------+----------------+---------------------+
  63. | team_name | num_of_players | team_timestamp |
  64. +----------------------+----------------+---------------------+
  65. | Adamson Falcons | 0 | 2015-08-05 00:31:42 |
  66. | Balik-Balik Warriors | 0 | 2015-08-05 00:31:13 |
  67. | Gasan Blue Eagles | 0 | 2015-08-05 00:36:12 |
  68. | Marikina Eagels | 0 | 2015-08-05 00:35:11 |
  69. | Marina Dragons | 0 | 2015-08-05 00:32:22 |
  70. | MDC Archers | 0 | 2015-08-05 00:33:12 |
  71. | Pasay Flooders | 0 | 2015-08-05 00:32:04 |
  72. | Quiapo A | 6 | 2015-08-05 00:30:13 |
  73. | Quiapo B | 6 | 2015-08-05 00:30:25 |
  74. | TIP Steallers | 0 | 2015-08-05 00:35:32 |
  75. +----------------------+----------------+---------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!