I have this SQL query that displays the report of categories and the total quantity of the products sold in that category. I want to see which user has sold how many products, when I use the code below it only displays the total quantity sold for one product by the specific user. I have 2 products in the category that is sold by the user, but it displays only the quantity sold for one product.

elif data.get('report_type') == 'report_by_categories':

            user_id = res_users.id = %s

               AND sale_order.state = 'sale'  -- Filter for confirmed sales

               ''' % user_id

            if data.get('date_from'):

                query += "AND sale_order.date_order >= '%s' " % data.get('date_from')

            if data.get('date_to'):

                query += "AND sale_order.date_order

            query += "GROUP BY product_category.name"

            self._cr.execute(query)

            report_by_categories = self._cr.dictfetchall()

            report_sub_lines.append(report_by_categories)