URI Online Judge Solution SQL | 2605 Executive Representatives - Solution in PostGreSQL

URI Online Judge Solution SQL | 2605 Executive Representatives - Solution in PostGreSQL

URI Online Judge Solution 2605 Executive Representatives   | SQL
URI Problem Link -  URI 2605 Executive Representatives  Link

Problem Name: URI 2605 Executive Representatives
Problem Number : URI - 2605 Executive Representatives
Online Judge : URI Online Judge Solution
Category: SQL
Solution Language : SQL, PostgreSQL

URI Solution 2605 Executive Representatives  Code in PostgreSQL:

SELECT products.name, providers.name
FROM products, providers
WHERE products.id_categories = 6 and products.id_providers = providers.id;

Demonstration:

In this URI 2605 problem,
We've to find the name of the products and name of the providers.
So first line,

SELECT products.name, providers.name

Then  From which table(products, providers) needs to calculate/joining

FROM products, providers

Finally the actual condition: The matching condition whose id_categories = 6 and the provider id also, So the SQL Query for that condition-

WHERE products.id_categories = 6 and products.id_providers = providers.id;

[Having any problem since, just comment here and I'll try to help to solve all URI online judge problems at most.]

Tags: URI Online Judge Solution, URI OJ Solution list, URI Problems Solution, URI solver, URI all problem solution list, URI 2605 Executive Representatives Code in mysql, URI 2605 Executive Representatives solution in sql, URI 2605 solution, URI 2605 code example, URI Online judge 2605 Code solution, URI 2605 solution, URI Solution,