beecrowd SQL | 2622

Legal Person

Paulo R. Rodegheri BR Brasil

Timelimit: 1

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