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.
Column | Type |
id (PK) | numeric |
name | varchar |
amount | numeric |
price | numeric |
id_providers (FK) | numeric |
id_categories (FK) | numeric |
Column | Type |
id (PK) | numeric |
name | varchar |
street | varchar |
city | varchar |
state | char |
Column | Type |
id (PK) | numeric |
name | varchar |
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 |
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 |
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 |
name | name |
Computer desk | Guilerme Staff |
Chair | Caroline Silva |