What SQL queries would you use to analyze healthcare data with analytical functions and aggregate functions?
