按一个字段求和，但仅限于唯一ID

I need to sum a sales quantity by month and year, but my database has some duplicate entries. I know this is not ideal, but it is a government database, so I cannot fix it. The database has a large number of records (> 200 million) so I don't want to group by the ID.I need to sum a sales quantity by month and yea