URI Problem 2618 Solution Imported Products - URI Online Judge Solution

URI Online Judge Solution 2618 Imported Products Using PostgreSQL Query Language.

Our company's import sector needs a report on the import of products from our Sansul providers.

Your task is to display the name of the products, the name of the supplier and the name of the category, for the products supplied by the supplier 'Sansul SA' and whose category name is 'Imported'.

Schema

products

Column	Type
id (PK)	numeric
name	character varying (255)
amount	numeric
price	numeric
id_providers (FK)	numeric
id_categories (FK)	numeric

 

providers

Column	Type
id (PK)	numeric
name	character varying (255)
street	character varying (255)
city	character varying (255)
state	char (2)

 

categories

Column	Type
id (PK)	numeric
name	character varying (255)

Tables

products

id	name	amount	price	id_providers	id_categories
1	Blue Chair	30	300.00	5	5
2	Red Chair	50	2150.00	2	1
3	Disney Wardrobe	400	829.50	4	1
4	Blue Toaster	20	9.90	3	1
5	TV	30	3000.25	2	2

 

providers

id	name	street	city	state
1	Ajax SA	Rua Presidente Castelo Branco	Porto Alegre	RS
2	Sansul SA	Av Brasil	Rio de Janeiro	RJ
3	South Chairs	Rua do Moinho	Santa Maria	RS
4	Elon Electro	Rua Apolo	São Paulo	SP
5	Mike Electro	Rua Pedro da Cunha	Curitiba	PR

 

categories

id	name
1	Super Luxury
2	Imported
3	Tech
4	Vintage
5	Supreme

Output Sample

name	name	name
TV	Sansul SA	Imported

URI 2618 Solution in SQL:

SELECT products.name,providers.name,categories.name
FROM products
INNER JOIN providers ON products.id_providers = providers.id
INNER JOIN categories ON products.id_categories = categories.id
WHERE providers.name = 'Sansul SA' AND categories.name = 'Imported'