CREATE TABLE table_15475116_1 (league VARCHAR, nickname VARCHAR)

What league does the team with the nickname Cavaliers belong to
SELECT league FROM table_15475116_1 WHERE nickname = "Cavaliers"
SELECT "league" FROM "table_15475116_1" WHERE "Cavaliers" = "nickname"