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

More By Author:

Check out these other kata created by jhoffner

Stats:

CreatedOct 16, 2016
PublishedOct 16, 2016
Warriors Trained31699
Total Skips1875
Total Code Submissions76709
Total Times Completed22414
SQL Completions22413
Total Stars124
% of votes with a positive feedback rating87% of 2376
Total "Very Satisfied" Votes1836
Total "Somewhat Satisfied" Votes443
Total "Not Satisfied" Votes97
Total Rank Assessments9
Average Assessed Rank
7 kyu
Highest Assessed Rank
6 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • jhoffner Avatar
  • Chrono79 Avatar
  • user5036852 Avatar
Ad