data/scripts/q_test_state_table.sql

create table state
(
    name    varchar(255) not null,
    country int          not null
);

insert into state (name, country)
values ('Maharashtra', 1);
insert into state (name, country)
values ('Madhya Pradesh', 1);
insert into state (name, country)
values ('Moscow', 3);
insert into state (name, country)
values ('Something', 4);
insert into state (name, country)
values ('Florida', 4);
insert into state (name, country)
values ('Texas', 4);