Sql qUERY

file.sql

/*CREATE TABLE posts (
    id int NOT NULL,
    title varchar(255) NOT NULL,
    PRIMARY KEY (id)
);*/

/*CREATE TABLE view_table (
    id int NOT NULL,
    post_id int NOT null,
    view_col int default 0
);*/


//query 
select
	p.*,
	count(vt.id) as total
from
	view_table vt
left join posts p on
	p.id = vt.post_id
group by
	vt.post_id
order by
	total desc;
  
  //data fetched
  id|title  |total|
--+-------+-----+
 1|title 1|    2|
 2|title 2|    2|
 3|title 3|    1|