I have a large table in Teradata that gets new data loaded into it daily. It has a column called
You can count the number of rows and divide by the number of days:
select count(*) / count(distinct cal_dt) from t;
This gives the average for each day when data was loaded.