7 kyu

GROCERY STORE: Support Local Products

8,633baaart

Description:

You are the owner of the Grocery Store. All your products are in the database, that you have created after CodeWars SQL excercises!:)

You care about local market, and want to check how many products come from United States of America or Canada.

Please use SELECT statement and IN to filter out other origins.

In the results show how many products are from United States of America and Canada respectively.

Order by number of products, descending.

products table schema

  • id
  • name
  • price
  • stock
  • producer
  • country

results table schema

  • products
  • country
SQL
Databases
Fundamentals

Stats:

CreatedFeb 22, 2018
PublishedFeb 22, 2018
Warriors Trained11844
Total Skips790
Total Code Submissions34378
Total Times Completed8633
SQL Completions8633
Total Stars54
% of votes with a positive feedback rating81% of 884
Total "Very Satisfied" Votes613
Total "Somewhat Satisfied" Votes201
Total "Not Satisfied" Votes70
Total Rank Assessments3
Average Assessed Rank
7 kyu
Highest Assessed Rank
7 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • baaart Avatar
  • smile67 Avatar
  • marbiru Avatar
Ad