====== Oracle - SQL - Select - Select Count ======

<code sql>
SELECT COUNT(*) FROM 
(
SELECT a.*, b.CMPY_N, b.CUST_ACNT_N FROM [BeaconPhase2_DEV].[BCN].[AGENTS_LOG_MSG] a left join 
[BeaconPhase2_DEV].[BCN].[CUST_STATIC] b on a.CUST_K = b.CUST_K
) AS subquery;  
</code>