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 stripped AS
(
  SELECT id, REGEXP_REPLACE(description,  '[^\w\s]', '', 'g') AS newdesc, description FROM wordcount
),
newcte AS
(
  SELECT id, UNNEST(STRING_TO_ARRAY(newdesc, ' ')) AS words, description
  FROM stripped
),
newcte2 AS
(
  SELECT n.id, 
         COUNT(n.words) AS wc ,
         COUNT(DISTINCT(n.words)) AS dwc
  FROM newcte n
  GROUP BY n.id
)
SELECT n2.id, n2.wc AS "Word_Count", n2.dwc AS "Unique_Word_Count" , s.description 
FROM newcte2 n2
JOIN stripped s ON n2.id = s.id;




id
Word_Count
Unique_Word_Count
description


1
4
4
What a great day

2
7
6
This is a product. It is useful



SELECT 2