Paulo R. Rodegheri Brasil
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'.
Column | Type |
id (PK) | numeric |
name | character varying (255) |
amount | numeric |
price | numeric |
id_providers (FK) | numeric |
id_categories (FK) | numeric |
Column | Type |
id (PK) | numeric |
name | character varying (255) |
street | character varying (255) |
city | character varying (255) |
state | char (2) |
Column | Type |
id (PK) | numeric |
name | character varying (255) |
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 |
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 |
id | name |
1 | Super Luxury |
2 | Imported |
3 | Tech |
4 | Vintage |
5 | Supreme |
name | name | name |
TV | Sansul SA | Imported |