URI Online Judge Solution SQL | 2609 Products by Categories - Solution in PostgreSQL - Online Judge Solution

Latest

It is a free Online judges problems solution list. Here you can find UVA online Judge Solution, URI Online Judge Solution, Code Marshal Online Judge Solution, Spoz Online Judge Problems Solution

Friday, April 5, 2019

URI Online Judge Solution SQL | 2609 Products by Categories - Solution in PostgreSQL

URI Online Judge Solution SQL | 2609 Products by Categories - Solution in PostgreSQL

URI Online Judge Solution SQL | 2609 Products by Categories  | Beginner

Problem Name: SQL | 2609 Products by Categories
Problem Number : URI - SQL | 2609 Products by Categories
Online Judge : URI Online Judge Solution
Category: SQL
Solution Language : SQL, postgreSQL. mySQL



URI Solution SQL | 2609 Products by Categories Code in SQL, PostgreSQL, MySQL:


select categories.name, sum(products.amount) 
from products, categories 
where products.id_categories = categories.id 
group by categories.name;






Tags: URI Online Judge Solution, URI OJ Solution list, URI Problems Solution, URI solver, URI all problem solution list, URI SQL | 2608 Higher and Lower Price, URI 2609 Products by Categories SQL Solution, URI Solution - SQL, URI Online Judge Solution, , URI Higher and Lower price solution, URI 2609 Products by Categories solution

No comments:

Post a Comment