7 kyu
SQL Basics: Simple JOIN
22,413 of 22,414jhoffner
Description:
For this challenge you need to create a simple SELECT statement that will return all columns from the products
table, and join to the companies
table so that you can return the company name.
products table schema
- id
- name
- isbn
- company_id
- price
companies table schema
- id
- name
You should return all product fields as well as the company name as "company_name".
NOTE: Your solution should use pure SQL. Ruby is used within the test cases to do the actual testing.
Databases
Fundamentals
SQL
Similar Kata:
Stats:
Created | Oct 16, 2016 |
Published | Oct 16, 2016 |
Warriors Trained | 31699 |
Total Skips | 1875 |
Total Code Submissions | 76709 |
Total Times Completed | 22414 |
SQL Completions | 22413 |
Total Stars | 124 |
% of votes with a positive feedback rating | 87% of 2376 |
Total "Very Satisfied" Votes | 1836 |
Total "Somewhat Satisfied" Votes | 443 |
Total "Not Satisfied" Votes | 97 |
Total Rank Assessments | 9 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 6 kyu |
Lowest Assessed Rank | 8 kyu |