card_games Database Schema

SQL Query:

SELECT artist FROM cards WHERE flavorName = 'Battra, Dark Destroyer'

Evidence:

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

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

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'

SQL Query:

SELECT DISTINCT manaCost FROM cards WHERE name = 'Ancestor''s Chosen'

Evidence:

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

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'