I'm rusty with my SQL. It's been many year and I am struggling with a simple issue. I keep getting an error in my WHERE clause and I don't understand. I am using SQLite
I want to limit my results to only those records returned in "number_of_tracks" that are greater than 12. I tried SELECT AlbumId, Count (TrackId) AS number_of_tracks FROM Tracks WHERE number_of_tracks >= '12' GROUP BY AlbumId ORDER BY number_of_tracks DESC;
I'm sure it's something simple, but I can't seem to even search the issues properly.
