Create a query that brings back a table of the people that can get in an elevator according to there weight code example

Example: Create a query that brings back a table of the people that can get in an elevator according to there weight

select Candidate, Election_year, sum(Total_$), count(*)
    from combined_party_data
    where Election_year = 2016
    group by Candidate, Election_year
    having count(*) > 80
    order by count(*) DESC;