learn-co-curriculum / sql-aggregate-functions-lab Goto Github PK
View Code? Open in Web Editor NEWLicense: Other
License: Other
There is no data in the insert.sql file. It doesn't state that we need to add this.
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.
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
Hi, every time i press the open ide to this lab it will not open up. please help :(
Test looks for: #average_student_gpa_for_9th_grade
The ruby method is called: #average_gpa_for_9th_grade
When looking for the files for this lab github declares- 404! These are not the files you're looking for.
The test for #counts_all_students_groups_by_grade is missing.
Can't open or submit, although passed.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.