Cacher is the code snippet organizer for pro developers

-- To count rows you can use the COUNT() function.
SELECT COUNT(*) FROM <table>;

-- To count unique entries use the DISTINCT keyword too:
SELECT COUNT(DISTINCT <column>) FROM <table>;

-- count and alias column
select COUNT(*) as "scifi_book_count" from books where genre = "Science Fiction";