CREATE TABLE player_award_vote (award_id CLOB, year NUMBER, league_id CLOB, player_id CLOB, points_won NUMBER, points_max NUMBER, votes_first CLOB)
CREATE TABLE player_award (player_id CLOB, award_id CLOB, year NUMBER, league_id CLOB, tie CLOB, notes CLOB)
CREATE TABLE hall_of_fame (player_id CLOB, yearid NUMBER, votedby CLOB, ballots CLOB, needed CLOB, votes CLOB, inducted CLOB, category CLOB, needed_note CLOB)
CREATE TABLE salary (year NUMBER, team_id CLOB, league_id CLOB, player_id CLOB, salary NUMBER)
CREATE TABLE player (player_id CLOB, birth_year CLOB, birth_month CLOB, birth_day CLOB, birth_country CLOB, birth_state CLOB, birth_city CLOB, death_year CLOB, death_month CLOB, death_day CLOB, death_country CLOB, death_state CLOB, death_city CLOB, name_first CLOB, name_last CLOB, name_given CLOB, weight CLOB)

What is the average weight of players who were awarded third-base man in TSN all-star award?
SELECT AVG(T1.weight) FROM player AS T1 JOIN player_award AS T2 ON T1.player_id = T2.player_id WHERE T2.award_id = "TSN All-Star" AND notes = "3B"
SELECT AVG("T1"."weight") FROM "player" "T1" JOIN "player_award" "T2" ON "T1"."player_id" = "T2"."player_id" AND "T2"."award_id" = "TSN All-Star" WHERE "3B" = "notes"