What SQL queries would you use to analyze analytical related queries and aggregate functions in a healthcare dataset?