SELECT 日時, 商品名, SUM(売上) FROM TABLE_A 
 GROUP BY DATE_FORMAT(日時, '%Y%m')