card_games Database Schema

SQL Query:

SELECT type FROM sets WHERE name LIKE '%FROM the Vault: Lore%'

Evidence:

set "From the Vault refers to name which contains 'From the Vault: Lore'; expansion type refers to type

SQL Query:

SELECT T1.name FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T2.name = 'Journey into Nyx Hero''s Path' ORDER BY T1.convertedManaCost DESC LIMIT 1

Evidence:

set 'Journey into Nyx Hero's Path' refers to name = 'Journey into Nyx Hero''s Path'

SQL Query:

SELECT DISTINCT T1.type FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T1.name = 'Benalish Knight'

Evidence:

Benalish Knight' is the name of card;

SQL Query:

SELECT SUM(CASE WHEN T1.power LIKE '*' OR T1.power IS NULL THEN 1 ELSE 0 END) FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T2.name = 'Coldsnap' AND T1.convertedManaCost > 5

Evidence:

card set Coldsnap refers to name = 'Coldsnap'; converted mana cost higher than 5 refers to convertedManaCost > 5; unknown power refers to power = '*' or T1.power is null

SQL Query:

SELECT DISTINCT T2.language, T1.type FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T2.uuid = T1.uuid WHERE T1.watermark = 'azorius'