Database containing superhero information including powers, attributes, and publishers.
| Column Name | Description |
|---|---|
id |
- |
superhero_name |
- |
full_name |
- |
gender_id |
- |
eye_colour_id |
- |
hair_colour_id |
- |
skin_colour_id |
- |
race_id |
- |
publisher_id |
- |
alignment_id |
- |
height_cm |
- |
weight_kg |
- |
| Column Name | Description |
|---|---|
id |
- |
gender |
- |
| Column Name | Description |
|---|---|
id |
- |
colour |
- |
| Column Name | Description |
|---|---|
id |
- |
race |
- |
| Column Name | Description |
|---|---|
id |
- |
publisher_name |
- |
| Column Name | Description |
|---|---|
id |
- |
alignment |
- |
| Column Name | Description |
|---|---|
id |
- |
power_name |
- |
| Column Name | Description |
|---|---|
id |
- |
attribute_name |
- |
| Column Name | Description |
|---|---|
hero_id |
- |
power_id |
- |
| Column Name | Description |
|---|---|
hero_id |
- |
attribute_id |
- |
attribute_value |
- |
SELECT colour.colour AS EyeColor, COUNT(superhero.id) AS Count, RANK() OVER (ORDER BY COUNT(superhero.id) DESC) AS PopularityRank FROM superhero INNER JOIN colour ON superhero.eye_colour_id = colour.id INNER JOIN publisher ON superhero.publisher_id = publisher.id WHERE publisher.publisher_name = 'Marvel Comics' GROUP BY colour.colour
the superheroes from Marvel Comics refers to publisher_name = 'Marvel Comics'; most common color refers to COUNT(superhero.id) DESC;
SELECT COUNT(T1.id) FROM superhero AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id WHERE T2.publisher_name = 'Dark Horse Comics'
published by Dark Horse Comics refers to publisher_name = 'Dark Horse Comics';
SELECT superhero_name FROM superhero AS T1 WHERE EXISTS (SELECT 1 FROM hero_power AS T2 INNER JOIN superpower AS T3 ON T2.power_id = T3.id WHERE T3.power_name = 'Super Strength' AND T1.id = T2.hero_id)AND EXISTS (SELECT 1 FROM publisher AS T4 WHERE T4.publisher_name = 'Marvel Comics' AND T1.publisher_id = T4.id)
the superheroes from Marvel Comics refers to publisher_name = 'Marvel Comics'; super power of "Super Strength" refers to power_name = 'Super Strength';
SELECT T3.power_name FROM superhero AS T1 INNER JOIN hero_power AS T2 ON T1.id = T2.hero_id INNER JOIN superpower AS T3 ON T2.power_id = T3.id WHERE T1.superhero_name = '3-D Man'
3-D Man refers to superhero_name = '3-D Man'; superpowers refers to power_name
SELECT superhero_name FROM superhero WHERE id = 294
name of superhero refers to superhero_name; superhero ID 294 refers to superhero.id = 294;