What i Need: I want to show the sales by dish category

**I have three tables for this problem:**

```
1.order(dish_id,dish_price,dish_quantity)
2.dish(dish_id,dish_name,dish_cat_id)
3.dish_category(dish_cat_id,dis_cat_name

```

**what result i want is :**
I want to show the report that , how many quantity has been sold, by dish category wise , and the total price , total\_quantity

**result to be expected:**
dish\_cat\_id, dish\_cat\_name, total\_price , total\_quantity\_sold

**what i have tried:**

```
    SELECT  d.dish_name, 
            d.dish_id,
            SUM(o.price) as total_price,
            SUM(o.dish_quantity) as total_qauntity 
    FROM order as o , dish as d
    WHERE o.dish_id = d.dish_id
    GROUP BY o.dish_id

```

Now here i can get all the dish and their total price by **dish** wise , how to i get them **dish\_category** wise

As right i am getting no idea expected to fire another query on the selected result about this query to get them dish\_category wise