CREATE TABLE table_15475116_1 (league VARCHAR2, nickname VARCHAR2)

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"