create table cities (
	country varchar(24),
	state varchar(24),
	city varchar(24)
);

insert into cities values (
	'USA',
	'California',
	'Los Angeles');
	
insert into cities values (
	'USA',
	'California',
	'San Francisco');

insert into cities values (
	'USA',
	'California',
	'Sacremento');

insert into cities values (
	'Malaysia',
	'Wilayah',
	'Kuala Lumpur');

insert into cities values (
	'Malaysia',
	'Wilayah',
	'Labuan');

insert into cities values (
	'USA',
	'Texas',
	'Houston');

insert into cities values (
	'USA',
	'Texas',
	'Alamo');

insert into cities values (
	'USA',
	'Texas',
	'Dallas');

insert into cities values (
	'Malaysia',
	'Selangor',
	'Petaling Jaya');

insert into cities values (
	'Malaysia',
	'Selangor',
	'Shah Alam');


insert into cities values (
	'Malaysia',
	'Selangor',
	'Kajang');
	

insert into cities values (
	'United Kingdom',
	'Scotland',
	'Edinburgh');
	
insert into cities values (
	'United Kingdom',
	'England',
	'London');

insert into cities values (
	'United Kingdom',
	'England',
	'Manchester');

insert into cities values (
	'United Kingdom',
	'England',
	'Bristol');
	
create table people (
	name varchar(24),
	country varchar(24),
	state varchar(24),
	city varchar(24)
);

insert into  people values (
	'Tom Hanks',
	'USA',
	'California',
	'Los Angeles');
	
insert into  people values (
	'John Lim',
	'Malaysia',
	'Selangor',
	'Petaling Jaya');
	
insert into  people values (
	'Queen Elizabeth',
	'United Kingdom',
	'England',
	'London');

insert into  people values (
	'Thrifty Mary',
	'United Kingdom',
	'Scotland',
	'Edinburgh');	