7 kyu
SQL Basics: Simple JOIN with COUNT
20,384matt c
Description:
For this challenge you need to create a simple SELECT statement that will return all columns from the people
table, and join to the toys
table so that you can return the COUNT of the toys
people table schema
- id
- name
toys table schema
- id
- name
- people_id
You should return all people fields as well as the toy count as "toy_count".
NOTE: Your solution should use pure SQL. Ruby is used within the test cases to do the actual testing.
SQL
Databases
Fundamentals
Similar Kata:
Stats:
Created | Oct 20, 2016 |
Published | Oct 20, 2016 |
Warriors Trained | 31061 |
Total Skips | 1874 |
Total Code Submissions | 73067 |
Total Times Completed | 20384 |
SQL Completions | 20384 |
Total Stars | 147 |
% of votes with a positive feedback rating | 86% of 2012 |
Total "Very Satisfied" Votes | 1528 |
Total "Somewhat Satisfied" Votes | 403 |
Total "Not Satisfied" Votes | 81 |
Total Rank Assessments | 9 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 7 kyu |
Lowest Assessed Rank | 8 kyu |