Group rows with COUNT
Create a tiny dataset and practice an aggregate query.
CREATE TABLE visits (page TEXT);
INSERT INTO visits VALUES ('home'), ('tools'), ('tools');
SELECT page, COUNT(*) AS visits FROM visits GROUP BY page;Expected: home | 1 tools | 2
Try in editor