CREATE TABLE country (country_id NUMBER, country_name CLOB, capital CLOB, official_native_language CLOB)
CREATE TABLE player (player_id NUMBER, player CLOB, years_played CLOB, total_wl CLOB, singles_wl CLOB, doubles_wl CLOB, team NUMBER)
CREATE TABLE match_season (season NUMBER, player CLOB, position CLOB, country NUMBER, team NUMBER, draft_pick_number NUMBER, draft_class CLOB, college CLOB)
CREATE TABLE team (team_id NUMBER, name CLOB)

Which players are from Indonesia?
SELECT T2.player FROM country AS T1 JOIN match_season AS T2 ON T1.country_id = T2.country WHERE T1.country_name = "Indonesia"
SELECT "T2"."player" FROM "country" "T1" JOIN "match_season" "T2" ON "T1"."country_id" = "T2"."country" WHERE "Indonesia" = "T1"."country_name"