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

How many players were awarded more than ten times?
SELECT COUNT(*) FROM (SELECT player_id FROM player_award GROUP BY player_id HAVING COUNT(*) > 10)
WITH "cte" AS (SELECT 1 AS "_" FROM "player_award" GROUP BY "player_id" HAVING COUNT(*) > 10) SELECT COUNT(*) FROM "cte" AS "cte"