learn-co-curriculum/sql-aggregate-functions-lab

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 .

sql-aggregate-functions-lab's Issues

Tests not working

All of the tests in the lab pass before any code is entered, except the one for #average_gpa_for_9th_grade.

Looks like all of the methods are included/completed at the bottom of the spec file.

There is no data in the insert.sql file

There is no data in the insert.sql file. It doesn't state that we need to add this.

Method name dissagreement

Test looks for: #average_student_gpa_for_9th_grade

The ruby method is called: #average_gpa_for_9th_grade

404- page not found

When looking for the files for this lab github declares- 404! These are not the files you're looking for.

need more instructions

The first lab where we actually write SQL and pass tests is "SQL Aggregate
Functions Lab" and the only instructions provided are "Run learn to get
started. Write your SQL in lib/students to get the specs in
spec/student_spec.rb to pass."

Then, the next lab, "SQL Bear Organizer" it includes these instructions:

Part 3: SELECT

Get the tests in spec/select_spec.rb to pass. Note that for this section,
the database will be seeded with external data from the lib/seed.sql file
so don't expect it to reflect the data you added above. Note: Since it's a
Ruby file, write your queries as strings in the lib/sql_queries.rb.

This was the part I had difficulty with in the first lab. Where do I write
my SQL code? How do I write my SQL code into a Ruby file? I found out
after asking on the slack channel, I think, but it'd be nice to just have
that info inside the lab instructions.

In the lessons and codealongs proceeding the SQL aggregate functions lab,
we never wrote code into a .rb file.

Best,

Adam

Missing Test #counts_all_students_groups_by_grade

The test for #counts_all_students_groups_by_grade is missing.

lab won't open up

Hi, every time i press the open ide to this lab it will not open up. please help :(

can't submit

Can't open or submit, although passed.

Mention about wrapping the query in quotes

no specs for the counts_all_students_groups_by_grade method