Solution: Do Math with Your Data
Explore how to perform mathematical operations on data with SQL. Learn to count records, calculate averages, and use aliases for clear results. This lesson helps you summarize information effectively using aggregate functions like COUNT and AVG in your SQL queries.
We'll cover the following...
We'll cover the following...
Query
SELECT COUNT(*) AS total_pets, AVG(age) AS average_ageFROM pets;
...