I want to display the remaining quantity in a supply.

I have two tables:

**`supply\_inventory\_list` table:**

```
supply_id  quantity  unit    item_name         supply_description       date_received        
---------  --------  ------  ----------------  -----------------------  -------------
        1         5  REAM    LEGAL BOND PAPER  CANON LEGAL BOND PAPER   2019-08-27
        2         5  REAM    A4 BOND PAPER     PAPER ONE A4 BOND PAPER  2019-08-27
        3         5  REAM    LEGAL BOND PAPER  HP LEGAL BOND PAPER      2019-08-30

```

**`supply\_employee\_list` table:**

```
emp_supply_id  supply_id  deployed_quantity  employee_name            date_deployed        
-------------  ---------  -----------------  -----------------------  --------------------
            1          3                  2  ALEX WARD                2019-08-29 16:00:00  
            2          3                  1  EDWARD COLLINS           2019-08-29 16:00:00

```

This is the query I tried, but I am not getting the result that i want:

```
SELECT 
    supply_inventory_list.supply_id,
    quantity,
    quantity - IFNULL(deployed_quantity, 0) AS 'AVAILABLE QUANTITY',
    unit,
    item_name,
    supply_description,
    date_received,
    IFNULL(deployed_quantity, 0) AS 'deployed_quantity'
FROM supply_inventory_list 
LEFT JOIN supply_employee_list 
    ON supply_employee_list.`supply_id` = supply_inventory_list.`supply_id` 
WHERE item_name = 'LEGAL BOND PAPER'
ORDER BY date_received DESC

```

This is the result I'm getting:

```
supply_id  quantity  AVAILABLE QUANTITY  unit    item_name         supply_description      date_received  deployed_quantity  
---------  --------  ------------------  ------  ----------------  ----------------------  -------------  -------------------
        3         5                   3  REAM    LEGAL BOND PAPER  HP LEGAL BOND PAPER     2019-08-30                       2
        3         5                   4  REAM    LEGAL BOND PAPER  HP LEGAL BOND PAPER     2019-08-30                       1
        1         5                   5  REAM    LEGAL BOND PAPER  CANON LEGAL BOND PAPER  2019-08-27                       0

```

This is not the result I'm looking for. I the `quantity` to be deducted based on `deployed\_quantity`. This is the result I'm looking for:

```
supply_id  quantity  AVAILABLE QUANTITY  unit    item_name         supply_description      date_received  deployed_quantity  
---------  --------  ------------------  ------  ----------------  ----------------------  -------------  -------------------
        3         5                   2  REAM    LEGAL BOND PAPER  HP LEGAL BOND PAPER     2019-08-30                       3
        1         5                   5  REAM    LEGAL BOND PAPER  CANON LEGAL BOND PAPER  2019-08-27                       0

```

As you can see the `AVAILABLE QUANTITY` is 2 and the `deployed\_quantity` is 3 because the first employee deployed 2 quantities and the second one deployed 1.

How do I produce this result?