card_games Database Schema

Database Description

Database for card games.

Schema Structure
Schema information not available for this database.
Example Queries

SQL Query:
SELECT artist FROM cards WHERE flavorName = 'Battra, Dark Destroyer'
Evidence:

promotional name is "Battra, Dark Destroyer" refers to flavorName = 'Battra, Dark Destroyer'

Difficulty: simple

SQL Query:
SELECT CAST(SUM(CASE WHEN borderColor = 'borderless' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(id) FROM cards
Evidence:

borderless card refers to borderColor = 'borderless'; percentage = Divide(Count (id) where borderColor = 'borderless', Count(id)) *100

Difficulty: simple

SQL Query:
SELECT COUNT(DISTINCT T2.translation) FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T1.name = 'Tenth Edition' AND T2.translation IS NOT NULL
Evidence:

translations of the name refers to translation; translation is not NULL; set "Salvat 2011" refers to name = 'Tenth Edition'

Difficulty: moderate

SQL Query:
SELECT DISTINCT manaCost FROM cards WHERE name = 'Ancestor''s Chosen'
Evidence:

card "Ancestor's Chosen" refers to name = 'Ancestor`s Chosen'

Difficulty: simple

SQL Query:
SELECT COUNT(id) FROM cards WHERE artist = 'Matthew D. Wilson' AND availability = 'paper'
Evidence:

card designed by Matthew D. Wilson refers to artist = 'Matthew D. Wilson'; available only in the paper refers to availability = 'paper'

Difficulty: simple
Back to Database Explorer