> For the complete documentation index, see [llms.txt](https://certil-remy.gitbook.io/learn/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://certil-remy.gitbook.io/learn/sql/untitled-8.md).

# SQL Aggregate Functions Lab

1. Find the min and max of a number set
2. Count the total of a number set
3. Find the average of a number set

We have a database full of students. The schema is as follows: [![](https://camo.githubusercontent.com/22e439929bfcbd349311d578caae1440cf657045/687474703a2f2f726561646d652d706963732e73332e616d617a6f6e6177732e636f6d2f73716c2d73747564656e74732e706e67)](https://camo.githubusercontent.com/22e439929bfcbd349311d578caae1440cf657045/687474703a2f2f726561646d652d706963732e73332e616d617a6f6e6177732e636f6d2f73716c2d73747564656e74732e706e67) Run `learn` to get started. Write your `SQL` in `lib/students.rb` to get the specs in `spec/student_spec.rb` to pass.

Note: Since it's a Ruby file, write your queries as strings inside each method already defined in `lib/students.rb` .

View [Objectives:](https://learn.co/lessons/sql-aggregate-functions-lab) on Learn.co and start learning to code for free.

View [SQL Aggregate Functions Lab](https://github.com/learn-co-curriculum/sql-aggregate-functions-lab) on Learn.co and start learning to code for free.