SELECT genre_id, COUNT(*) AS total_count FROM books GROUP BY genre_id;
this is my code for count all books by genre, and it doesn't count as true, give me feedback please