CREATE TABLE costumers ( id INTEGER PRIMARY KEY AUTO_INCREMENT, name VARCHAR(30), street VARCHAR(30), city VARCHAR(30), state VARCHAR(2), credit_limit DECIMAL(32, 2));

INSERT INTO costumers(name, street, city, state, credit_limit) VALUES ('Pedro Augusto da Rocha', 'Rua Pedro Carlos Hoffman', 'Porto Alegre', 'RS', 700.00); INSERT INTO costumers(name, street, city, state, credit_limit) VALUES ('Antonio Carlos Mamel', 'Av. Pinheiros', 'Belo Horizonte', 'MG', 3500.50); INSERT INTO costumers(name, street, city, state, credit_limit) VALUES ('Luiza Augusta Mhor', 'Rua Salto Grande', 'Niteroi', 'RJ', 4000.00); INSERT INTO costumers(name, street, city, state, credit_limit) VALUES ('Jane Ester', 'Av 7 de setembro', 'Erechim', 'RS', 800.00); INSERT INTO costumers(name, street, city, state, credit_limit) VALUES ('Marcos Antônio dos Santos', 'Av Farrapos', 'Porto Alegre', 'RS', 4250.25);

SELECT name FROM costumers WHERE state = 'RS';