CREATE TABLE League (name VARCHAR2, country_id VARCHAR2)
CREATE TABLE Country (name VARCHAR2, id VARCHAR2)

List all country and league names.
SELECT T1.name, T2.name FROM Country AS T1 JOIN League AS T2 ON T1.id = T2.country_id
SELECT "T1"."name", "T2"."name" FROM "Country" "T1" JOIN "League" "T2" ON "T1"."id" = "T2"."country_id"