Count (distinct col)
select Category,count(distinct Rating) as cntDis,count(1) as cnt,max(`Rental Duration`) as maxDuration,min(`Rental Duration`) as minDuration,sum(`Length`) as sumLength,avg(`Length`) as avgLength from films group by Category
Aggregate functions in binary expressions
select (max(`Length`) + max(`Replacement Cost`) + 1) * min(To_int(`Rental Duration`)) as totVal from films
Fixes:
select Category,count(distinct Rating) as cntDis,count(1) as cnt,max(`Rental Duration`) as maxDuration,min(`Rental Duration`) as minDuration,sum(`Length`) as sumLength,avg(`Length`) as avgLength from films group by Category
select (max(`Length`) + max(`Replacement Cost`) + 1) * min(To_int(`Rental Duration`)) as totVal from films
Functions