Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE news (
  id INTEGER,
  title VARCHAR(59),
  body VARCHAR(255),
  published_at DATE,
  deleted_at DATE,
  created_at DATE
);

INSERT INTO news
  (id, title, body, published_at, deleted_at, created_at)
VALUES
  ('1', 'Tax are Increasing Again, But Why?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor i', NULL, NULL, '2021-06-06 14:11:24'),
  ('2', 'AwanKinton are Making Brand New University Named DragonBall', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor i', NULL, NULL, '2021-06-06 14:11:24'),
  ('3', 'AwanKinton Released New Car that Can Fly', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor i', NULL, NULL, '2021-06-06 14:11:24'),
  ('4', 'Indonesia National Team Are Not Gonna Make it to World Cup', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor i', '2021-06-06 14:11:24', NULL, '2021-06-06 14:11:24'),
  ('10', '10 Penyebab Istri Sebel Sama Suami', 'Sebel aslkdjas askldjlsajd alskdjlkas alskdjsalk asldkjaslk asdlkjasld asdljasl asldjsalk alsdjals lajsdlkaj', NULL, NULL, '2021-06-06 14:34:08');

CREATE TABLE topics (
  id INTEGER,
  name VARCHAR(13),
  created_at DATE
);

INSERT INTO topics
  (id, name, created_at)
VALUES
  ('1', 'politics', '2021-06-06 18:43:13'),
  ('2', 'economy', '2021-06-06 18:43:13'),
  ('3', 'auto', '2021-06-06 18:43:13'),
  ('4', 'education', '2021-06-06 18:43:13'),
  ('5', 'tech', '2021-06-06 18:43:13'),
  ('6', 'culture', '2021-06-06 18:43:13'),
  ('7', 'money', '2021-06-06 18:43:13'),
  ('8', 'sports', '2021-06-06 18:43:13'),
  ('9', 'uncategorized', '2021-06-06 18:43:13');

CREATE TABLE news_topics (
  id INTEGER,
  news_id INTEGER,
  topics_id INTEGER
);

INSERT INTO news_topics
  (id, news_id, topics_id)
VALUES
  ('1', '1', '7'),
  ('2', '1', '4'),
  ('3', '2', '3'),
  ('4', '2', '4'),
  ('5', '2', '5'),
  ('6', '3', '3'),
  ('7', '3', '4'),
  ('8', '4', '8');

5 rows affected

9 rows affected

8 rows affected

id	title	body	published_at	deleted_at	created_at	topics
2	AwanKinton are Making Brand New University Named DragonBall	Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor i	null	null	2021-06-06	auto
3	AwanKinton Released New Car that Can Fly	Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor i	null	null	2021-06-06	auto