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
Similar Kata:
Stats:
Created | Feb 22, 2018 |
Published | Feb 22, 2018 |
Warriors Trained | 11844 |
Total Skips | 790 |
Total Code Submissions | 34378 |
Total Times Completed | 8633 |
SQL Completions | 8633 |
Total Stars | 54 |
% of votes with a positive feedback rating | 81% of 884 |
Total "Very Satisfied" Votes | 613 |
Total "Somewhat Satisfied" Votes | 201 |
Total "Not Satisfied" Votes | 70 |
Total Rank Assessments | 3 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 7 kyu |
Lowest Assessed Rank | 8 kyu |