CREATE TABLE player (player_id NUMBER, sponsor_name CLOB, player_name CLOB, gender CLOB, residence CLOB, occupation CLOB, votes NUMBER, rank CLOB)
CREATE TABLE coach (coach_id NUMBER, coach_name CLOB, gender CLOB, club_id NUMBER, rank NUMBER)
CREATE TABLE club (club_id NUMBER, club_name CLOB, region CLOB, start_year NUMBER)
CREATE TABLE player_coach (player_id NUMBER, coach_id NUMBER, starting_year NUMBER)
CREATE TABLE match_result (rank NUMBER, club_id NUMBER, gold NUMBER, big_silver NUMBER, small_silver NUMBER, bronze NUMBER, points NUMBER)

What are the gender and occupation of players?
SELECT gender, occupation FROM player
SELECT "gender", "occupation" FROM "player"