Q&A for students, teachers, and linguists wanting to discuss the finer points of the Italian language
select id, count(votetypeid) as upvotes from votes where votetypeid = 2 group by id