data/scripts/q_test_city_table.sql

create table if not exists city
(
    name       varchar(255) not null,
    state int          not null
);

insert into city (name, state)
values ('Mumbai', 1);
insert into city (name, state)
values ('Pune', 1);
insert into city (name, state)
values ('Bhopal', 2);
insert into city (name, state)
values ('Indore', 2);
insert into city (name, state)
values ('Klin', 3);
insert into city (name, state)
values ('Los Angeles', 5);
insert into city (name, state)
values ('Plant City', 5);
insert into city (name, state)
values ('Arlington', 6);