URI Problem 2622 Solution Legal Person - URI Online Judge Solution

URI Online Judge Solution 2622 Legal Person Using PostgreSQL Query Language. 

The sales industry wants to make a promotion for all clients that are legal entities. For this you must display the name of the customers that are legal entity.

Schema

customers

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

 

legal_person

Column	Type
id_customers (FK)	numeric
cnpj	char (18)
contact	character varying

Tables

customers

id	name	street	city	state	credit_limit
1	Nicolas Diogo Cardoso	Acesso Um	Porto Alegre	RS	475
2	Cecília Olivia Rodrigues	Rua Sizuka Usuy	Cianorte	PR	3170
3	Augusto Fernando Carlos Eduardo Cardoso	Rua Baldomiro Koerich	Palhoça	SC	1067
4	Nicolas Diogo Cardoso	Acesso Um	Porto Alegre	RS	475
5	Sabrina Heloisa Gabriela Barros	Rua Engenheiro Tito Marques Fernandes	Porto Alegre	RS	4312
6	Joaquim Diego Lorenzo Araújo	Rua Vitorino	Novo Hamburgo	RS	2314

 

legal_person

id_customers	cnpj	contact
4	85883842000191	99767-0562
5	47773848000117	99100-8965

Output Sample

name

Nicolas Diogo Cardoso

Sabrina Heloisa Gabriela Barros

 

URI 2622 Solution in SQL:

SELECT name 
FROM customers 
WHERE id IN (SELECT id_customers FROM legal_person)