Happy New Year!✨
To start off the year strong, I'm learning SQL through a Khan Academy course. I was tasked with creating tables of 'famous' people for a project. I decided to make it more fun for myself by creating tables about Marvel Rivals, a video game released recently that has taken the world by storm, myself included. I know I'm not the only data nerd that likes to game in their downtime, so I thought I'd share the SQL code I wrote in case it could be of use.😊
I constructed two tables. The first has every playable character in the game listed in each row, along with their role, difficulty, HP, and affiliation. The second table represents all of the different team-up abilities possible by combining characters 2-3 from the first table. The tables consist of the following columns:
heroes
| hero_id | name | role | hp | difficulty | affiliation |
team_ups
| id | combo_name | activator_id | party1_id | party2_id |
The SQL code to generate these tables can be found on GitHub at github.com/mbreshock/MarvelRivalsDB/blob/main/rivals.sql. This repository also provides a script with example commands for querying these tables. All of the information in these tables was sourced from Marvel Rivals Wiki.
Top comments (0)