URI Online Judge SQL | 2605

Executive Representatives

Paulo R. Rodegheri BR Brazil

Timelimit: 1

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