Вычитая общее количество из таблицы 1 в таблицу 2

Question

Ребята, у меня есть эта проблема на вычитание двух таблиц (Deliveries а также Returns) его TOTAL_QUANTITY сгруппированы по их CONTAINER_TYPE а также CUSTOMER_NAMEэтот пример запроса возвращает столбец Customer_Balance из 0 если бы я вычитал например 5 - 0, но если я вычел 5 -1 это возвращается 4,

select TOTAL_DELIVERY.CUSTOMER_NAME,
    TOTAL_DELIVERY.CONTAINER_TYPE,
    coalesce(TOTAL_DELIVERY.TOTAL_QUANTITY, 0) as TOTAL_DELIVERY,
    coalesce(TOTAL_PULLOUT.TOTAL_QUANTITY, 0) as TOTAL_PULLOUT,
    coalesce((TOTAL_DELIVERY.TOTAL_QUANTITY - TOTAL_PULLOUT.TOTAL_QUANTITY), 0) as CUSTOMER_BALANCE
from TOTAL_DELIVERY
left join TOTAL_PULLOUT
on TOTAL_DELIVERY.CUSTOMER_NAME = TOTAL_PULLOUT.CUSTOMER_NAME
and TOTAL_DELIVERY.CONTAINER_TYPE = TOTAL_PULLOUT.CONTAINER_TYPE


Deliveries Table (View)
================
----------------------------------------------
CUSTOMER_NAME| CONTAINER_TYPE | TOTAL_QUANTITY
-------------+----------------+---------------
Bryan        | Slim           | 5
-------------+----------------+---------------
Bryan        | Jug            | 5
-------------+----------------+---------------


Returns Table (View)
=============

CUSTOMER_NAME| CONTAINER_TYPE| TOTAL_QUANTITY
-------------+---------------+---------------
Bryan        | Slim          | 5
-------------+---------------+---------------

Expected output
===============

Customer | Container | Total_Delivery | Total_Return | Customer_Balance |
---------+-----------+----------------+--------------+------------------ 
Bryan    | Slim      | 5              | 5            | 0                |
---------+-----------+----------------+--------------+------------------
Bryan    | Jug       | 5              | 0            | 5                |
---------+-----------+----------------+---------------------------------

My INCORRECT Result output (incorrect result at the bottom right cell)
=========

Customer | Container | Total_Delivery | Total_Return | Customer_Balance |
---------+-----------+----------------+--------------+------------------ 
Bryan    | Slim      | 5              | 5            | 0                |
---------+-----------+----------------+--------------+------------------
Bryan    | Jug       | 5              | 0            | 0                |
---------+-----------+----------------+---------------------------------

подскажите пожалуйста что я делаю не так? благодарю вас!

Answer 1

(TOTAL_DELIVERY.TOTAL_QUANTITY - TOTAL_PULLOUT.TOTAL_QUANTITY)

должно быть

(coalesce(TOTAL_DELIVERY.TOTAL_QUANTITY,0) - coalesce(TOTAL_PULLOUT.TOTAL_QUANTITY, 0))