YEs I will thanks.

Data type is DATE

My error.. apologies. DB is oracle and I am using Oracle SQL Developer. I am not sure if DateDiff function works.

I have not used that keyword before.

This is my statement so far. Essentially I need the calculation within the statement I have completed so far.

SELECT L.LocationID, COUNT(C.CableBoxID)...

Apologies for not providing an example of the table. I will best describe it below.

LocationTable

PK (Surrogate Key), LocationID

12345, 0000001

12312, 0000002

12329, 0000003

** LocationID could technically be the PK but it is...