CREATE TABLE Player (player_name VARCHAR2, player_api_id VARCHAR2)
CREATE TABLE Player_Attributes (overall_rating NUMBER)

List all player names who have an overall rating higher than the average.
SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T2.overall_rating > (SELECT AVG(overall_rating) FROM Player_Attributes)
SELECT DISTINCT "T1"."player_name" FROM "Player" "T1" JOIN "Player_Attributes" "T2" ON "T1"."player_api_id" = "T2"."player_api_id" AND "T2"."overall_rating" > (SELECT AVG("overall_rating") FROM "Player_Attributes")