q5aKctLZ

1CREATE TABLE IF NOT EXISTS people_table(people_id serial,
2									  peopleName VARCHAR(50),
3									  likesIn integer,
4									  likesOut integer,
5									  PRIMARY KEY(people_id));
6									  
7CREATE TABLE IF NOT EXISTS sharedLikes_table(first_id serial,
8											 second_id serial,
9											 sharedLikes integer,
10											 Primary key(first_id));
11--insert into people_table (peopleName, likesIn, likesOut) values ('Krasava', 5, 1);
12
13Select peopleName, likesIn, likesOut  from people_table order by -likesIn;
14--select peopleName from people_table;