select NAME
from PRODUCT_SPECIFICATION
where PRODUCT_ID = 50 ;

select (B.AREA ||' '||B.BRANCH_ID) AS branch , count(B.BRANCH_ID) as stock
from PRODUCT_SPECIFICATION SP, STOCK STK, PRODUCT_IMEI I, BRANCH_PRODUCT_STOCK BP, BRANCH B
where SP.PRODUCT_ID = STK.STOCK_PRODUCT_ID AND STK.STOCK_IMEI = I.IMEI_NO
			AND I.IMEI_NO = BP.STOCK_IMEI AND BP.STOCK_BRANCH_ID = B.BRANCH_ID
			AND SP.PRODUCT_ID = 50
group by (B.AREA ||' '||B.BRANCH_ID) ;