Uri - Beecrowd | 2605 | Executive Representatives

 | 2605

Executive Representatives

Paulo R. Rodegheri  Brazil

The financial sector needs a report on the providers of the products we sell. The reports include all categories, but for some reason, providers of products whose category is the executive, are not in the report.

Your job is to return the names of the products and providers whose category ID is 6.

Schema

products

Column	Type
id (PK)	numeric
name	varchar
amount	numeric
price	numeric
id_providers (FK)	numeric
id_categories (FK)	numeric

 

providers

Column	Type
id (PK)	numeric
name	varchar
street	varchar
city	varchar
state	char

 

categories

Column	Type
id (PK)	numeric
name	varchar

Tables

products

id	name	amount	price	id_providers	id_categories
1	Two-door wardrobe	100	800	6	8
2	Dining table	1000	560	1	9
3	Towel holder	10000	25.50	5	1
4	Computer desk	350	320.50	4	6
5	Chair	3000	210.64	3	6
6	Single bed	750	460	1	2

 

providers

id	name	street	city	state
1	Henrique	Av Brasil	Rio de Janeiro	RJ
2	Marcelo Augusto	Rua Imigrantes	Belo Horizonte	MG
3	Caroline Silva	Av São Paulo	Salvador	BA
4	Guilerme Staff	Rua Central	Porto Alegre	RS
5	Isabela Moraes	Av Juiz Grande	Curitiba	PR
6	Francisco Accerr	Av Paulista	São Paulo	SP

 

categories

id	name
1	old stock
2	new stock
3	modern
4	commercial
5	recyclable
6	executive
7	superior
8	wood
9	super luxury
10	vintage

Output Sample

name	name
Computer desk	Guilerme Staff
Chair	Caroline Silva

N.B.: It's better if you solve this by your own. Thank you!

  URI - BEECROWD Online Judge 2605 Solve in SQL:                                          

-- Solved by Intesar
SELECT p.name as name, pr.name as name
from categories c, products p, providers pr
where c.id = 6 and (c.id = p.id_categories and p.id_providers = pr.id);