Please enable JavaScript to use CodeHS

Points

Activity Points
Hour of SQL
1.1 What is SQL?
1.1.1 Intro to SQL 1
1.1.2 Quiz: What is SQL? 0
1.2 Structuring Data in SQL
1.2.1 How to Structure Data in SQL 1
1.3 Basic Querying in SQL
1.3.1 The SELECT Statement 1
1.3.2 Our first SELECT statement 1
1.3.3 Your first SELECT statement 5
1.3.4 More SELECT Statement 1
1.3.5 Selecting specific columns examples 1
1.3.6 Harry Potter Names 5
1.3.7 Harry Potter Last Names 5
1.4 Filtering Queries in SQL
1.4.1 The WHERE Clause 1
1.4.2 Ravenclaw House 1
1.4.3 People in Gryffindor 1
1.4.4 Filter By ID 1
1.4.5 The Weasleys 5
1.4.6 The Potters 5
1.4.7 Quiz: Condition Operators 0
1.5 Advanced FIlters
1.5.1 Compound and Advanced Filters 1
1.5.2 Compound Filters Example 1
1.5.3 BETWEEN, LIKE, IN Examples 1
1.5.4 The Patil in Ravenclaw 5
1.5.5 Using BETWEEN 5
1.5.6 Hour of SQL Badge 0
SQL Part II: The SQL
2.1 More Filtering Practice
2.1.1 Initials 5
2.1.2 Compound Queries with BETWEEN 5
2.1.3 Gryffindors With G Names 5
2.1.4 R First Names 5
2.1.5 FF Houses 5
2.2 Ordering Results
2.2.1 The ORDER BY Keyword 1
2.2.2 ORDER BY 1
2.2.3 ORDER BY First Name 1
2.2.4 Reverse Order 1
2.2.5 Order By Multiple Fields 1
2.2.6 House Ordering 5
2.2.7 Sort the P Names 5
2.3 Renaming Fields
2.3.1 Renaming Fields with AS 1
2.3.2 Renaming in the House Table 1
2.3.3 Changing Column Names 5
2.4 Joining Tables
2.4.1 The JOIN command 1
2.4.2 Basic Joining 1
2.4.3 Letters and Numbers 1
2.4.4 Person and House 1
2.4.5 Person and House (Correct) 1
2.4.6 Person and House (with namespacing) 1
2.4.7 List All Gryffindors 5
2.4.8 JOIN With Yourself 1
2.4.9 Renaming Tables 1
2.4.10 Quidditch Matchups 1
2.4.11 Quidditch Matchups: Ravenclaw Away Games 5
2.5 More Joining Tables
2.5.1 The Course Table 1
2.5.2 Courses and Professors 5
2.5.3 Courses, Professors, and Houses 5
2.5.4 Courses Taught By Gryffindors 5
2.5.5 The Enrollment Table 1
2.5.6 Students Taking Potions 5
2.5.7 Non-Slytherins Taking Potions 5
2.5.8 Defense Students by House 5
2.5.9 Neville's Courses 5
SQL Functions
3.1 Counting in SQL
3.1.1 The COUNT Function 1
3.1.2 Number of Houses 1
3.1.3 Number of Weasleys 5
3.1.4 Number of Students in Transfigurations 5
3.1.5 People with Z names 5
3.2 Grouping
3.2.1 The GROUP BY Clause 1
3.2.2 Grouping Results 1
3.2.3 People in Houses 1
3.2.4 Course Enrollments 5
3.2.5 How Many Hufflepuffs? 5
3.2.6 Houses of Professors 5
3.3 Filtering Calculations
3.3.1 How to Filter with HAVING 1
3.3.2 Popular Houses 1
3.3.3 Full Courses 5
3.3.4 Families 5
3.3.5 C-Courses 5
3.4 Limiting
3.4.1 LIMIT 1
3.4.2 LIMIT Examples 1
3.4.3 Graduation 5
3.4.4 Bookworms 5
3.4.5 Rate My Professor 5
Data Aggregation
4.1 House Points
4.1.1 The HousePoint Table 1
4.1.2 HousePoint Table 1
4.1.3 HousePoints With Houses 5
4.1.4 Gryffindors With House Points 5
4.1.5 Negative Points 5
4.2 Summing Points
4.2.1 The SUM Function 1
4.2.2 SUM Example 1
4.2.3 Harry's Points 5
4.2.4 Snape, Snape, Severus Snape 5
4.2.5 Ravenclaw Points 5
4.3 Point Distributions
4.3.1 Best Students 5
4.3.2 Debbie Downer 5
4.3.3 House Cup Standings 5
4.3.4 House Cup Winner 5
4.3.5 The Best Weasley 5
4.3.6 Inter-House Points 5
4.3.7 SQL Badge 0