What is the difference between these two. I know that max() is an aggregate function
select model,count(distinct cars) from rc_cars where greatest(baught,returned) < current_date - integer '1' group by model; Do i need to have a max () around a greatest() to make sure i get the most recent of the two. select model,count(distinct cars) from rc_cars where max(greatest(baught,returned)) < current_date - integer '1' group by model;