Uri - Beecrowd | 2602 | Basic Select

 | 2602

Basic Select

Paulo R. Rodegheri  Brazil

Your company is doing a survey of how many customers are registered in the states, however, lacked to raise the data of the state of the 'Rio Grande do Sul'.

Then, you must show the names of all customers whose state is 'RS'.

Schema

customers

Column	Type
id (PK)	numeric
name	varchar
street	varchar
city	varchar
state	char
credit_limit	number

Tables

customers

id	name	street	city	state	credit_limit
1	Pedro Augusto da Rocha	Rua Pedro Carlos Hoffman	Porto Alegre	RS	700,00
2	Antonio Carlos Mamel	Av. Pinheiros	Belo Horizonte	MG	3500,50
3	Luiza Augusta Mhor	Rua Salto Grande	Niteroi	RJ	4000,00
4	Jane Ester	Av 7 de setembro	Erechim	RS	800,00
5	Marcos Antônio dos Santos	Av Farrapos	Porto Alegre	RS	4250,25

Output Sample

name

Pedro Augusto da Rocha

Jane Ester

Marcos Antônio dos Santos

N.B.: It's better if you solve this by your own. Thank you!

  URI - BEECROWD Online Judge 2602 Solve in SQL:                                          

-- Solved by Intesar
SELECT name 
FROM customers 
WHERE state = 'RS';