Table: footballers_100_caps
Columns: rank
name
confederation
caps
last

Question: Who had a rank more than 48, and a last in 2005?
SQL: SELECT "name" FROM footballers_100_caps WHERE "rank" > 48 AND "last" = 2005

Question: Which UEFA confederation member had a rank more than 17 and caps of 114?
SQL: SELECT "name" FROM footballers_100_caps WHERE "rank" > 17 AND "confederation" = 'uefa' AND "caps" = 114