Postgres 11

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

CREATE TABLE wordcount (id SERIAL NOT NULL PRIMARY KEY, description TEXT NOT NULL);
CREATE TABLE result (id INTEGER NOT NULL, word TEXT NOT NULL);

CREATE TABLE



CREATE TABLE


INSERT INTO wordcount (description) VALUES ('What a great day');
INSERT INTO wordcount (description) VALUES ('This is a product. It is useful');

INSERT 0 1



INSERT 0 1


WITH arranged AS
(
  SELECT id, UNNEST(STRING_TO_ARRAY(
                   REGEXP_REPLACE(description,  '[^\w\s]', '', 'g'), ' ')) 
                   AS word, description 
  FROM wordcount
) -- try SELECT FROM arranged; here 
SELECT a.id, COUNT(a.word), COUNT(DISTINCT(a.word)), a.description
FROM arranged a
GROUP BY a.id, a.description;



id
count
count
description


1
4
4
What a great day

2
7
6
This is a product. It is useful



SELECT 2