ADD CONSTRAINT fk_compos_on_post FOREIGN KEY (posts_id) REFERENCES posts (id);

psql postgresql://root:root@localhost:5432/blog

CREATE VIEW USER_STATISTICS (USER_ID, NUMBER_OF_POSTS) AS

SELECT

U.ID AS USER_ID,

COUNT(P.ID) AS NUMBER_OF_POSTS

FROM

USERS U

JOIN POSTS P ON U.ID = P.AUTHOR_ID

GROUP BY

U.ID;