Sql Aggregate Functions Lab

Objectives

  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: Run learn test 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 .

Unlock your future in tech
Learn to code.

Learn about Flatiron School's Mission

With a new take on education that falls somewhere between self-taught prodigy and four-year computer science degree, the Flatiron School promises to turn students with little programming experience into developers.

In the six months since the Manhattan coding school was acquired by WeWork, it has spawned locations in Washington, D.C., Brooklyn, and London. Now, WeWork is opening a fourth Flatiron School location, this time in Houston.

Adam Enbar, Flatiron School's cofounder, believes now is the time to grow. "How the world is changing has impacted working and learning in very similar ways. We think education fundamentally is about one thing: enabling people to pursue a better life."

Learn. Love. Code.
Students come to Flatiron School to change their lives. Join our driven community of career-changers and master the skills you need to become a software engineer or a data scientist.
Find Us