By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablename (`Name` VARCHAR(1), `Value` VARCHAR(7));
INSERT INTO tablename (`Name`, `Value`) VALUES
('A', 'Sample1'),
('A', 'Sample2'),
('A', 'Sample3'),
('B', 'Sample3'),
('B', 'Sample1'),
('C', 'Sample2'),
('C', 'Sample3'),
('D', 'Sample1');
Records: 8 Duplicates: 0 Warnings: 0
SELECT DISTINCT COUNT(*) AS count,
COUNT(*) OVER (PARTITION BY COUNT(*)) AS numberOfTimes
FROM tablename
GROUP BY Name;
| count | numberOfTimes |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 1 |