MySQL 8.0

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

CREATE TABLE products(
   id     INTEGER NOT NULL
  ,name    VARCHAR(50) NOT NULL
  ,categ VARCHAR(50)  NOT NULL 
);
INSERT INTO products(id,name,categ) VALUES (1,'name1','cat1'); 
INSERT INTO products(id,name,categ) VALUES (2,'name2','cat2'); 
INSERT INTO products(id,name,categ) VALUES (3,'name3','cat3'); 
INSERT INTO products(id,name,categ) VALUES (4,'name4','cat5'); 
INSERT INTO products(id,name,categ) VALUES (5,'name5','cat5'); 
INSERT INTO products(id,name,categ) VALUES (6,'name6','cat6'); 
INSERT INTO products(id,name,categ) VALUES (7,'name7','cat7'); 
INSERT INTO products(id,name,categ) VALUES (8,'name8','cat8'); 
INSERT INTO products(id,name,categ) VALUES (9,'name9','cat9'); 
INSERT INTO products(id,name,categ) VALUES (10,'name10','cat10'); 
INSERT INTO products(id,name,categ) VALUES (11,'name11','cat11'); 
INSERT INTO products(id,name,categ) VALUES (12,'name12','cat12'); 
INSERT INTO products(id,name,categ) VALUES (13,'name13','cat13'); 
INSERT INTO products(id,name,categ) VALUES (14,'name14','cat14');

id	name	categ	numberRows
1	name1	cat1	14
2	name2	cat2	14
3	name3	cat3	14
4	name4	cat5	14
5	name5	cat5	14
6	name6	cat6	14
7	name7	cat7	14
8	name8	cat8	14
9	name9	cat9	14
10	name10	cat10	14