use `mycompiler`;


create table `city`(
  `name` varchar (255) primary key
);
create table `users` (
  `id` int unique,
  `name` varchar(255),
  `city` varchar(255),
  CONSTRAINT `users_pr` foreign key (`city`) references `city`(`name`)
);
insert into `city`  (`name`) values ('Azaz');
insert into `city`  (`name`) values ('Efrin');
insert into `city`  (`name`) values ('bzaa');
insert into `city`  (`name`) values ('ksa');
insert into `users` (`id`,`name`,`city`) values (1,'Ahmed','ksa');
insert into `users` (`id`,`name`,`city`) values (2,'Osama','ksa');
insert into `users` (`id`,`name`,`city`) values (3,'Ali','bzaa');
insert into `users` (`id`,`name`,`city`) values (4,'Elzero','bzaa');
insert into `users` (`id`,`name`) values (5,'aya');
insert into `users` (`id`,`name`,`city`) values (6,'Husam','Azaz');


select * from `city` 
RIGHT JOIN `users` ON
`city`.`name` = `users`.`city`;