From the course: SQL for Healthcare Professionals

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Using aggregate functions to manipulate the data

Using aggregate functions to manipulate the data - SQL Tutorial

From the course: SQL for Healthcare Professionals

Start my 1-month free trial Buy for my team

Using aggregate functions to manipulate the data

“

- [Instructor] When working in healthcare analytics, it is common to have questions that require calculations with the data. SQL has built in functions that allow different types of calculations to be performed. Let's discuss some of the most common aggregate functions. Aggregate functions return the basic statistics on a group of records. Average, count, maximum and minimum are some examples of those types of functions. As the name indicates, average calculates the arithmetic means of a set of values in the column. Count returns the number of records in a data set or the number of non null values in a column. Maximum returns the highest value in a column of numeric or date-time data types. It's useful for finding the maximum value of a certain parameter, such as the highest blood pressure reading among patients. Minimum returns the smallest value in a column of numeric or date-time data types. It's handy identifying the…

Contents