Count function behavior.

SELECT COUNT(ALL ADDRESS) FROM TEST1; --ROWS EXCEPT NULL VALUES 
SELECT COUNT(DISTINCT ADDRESS) FROM TEST1; --ELEMINATE DUPLICATE ROWS 
SELECT COUNT(ADDRESS) FROM TEST1; --ROWS EXCEPT NULL VALUES 
SELECT COUNT(*) FROM TEST1; -- ALL ROWS INCLUDE NULL VALUES