[Solved] List of locations with number of unchecked items

[Kirjava]

I have a query to check how many items are in each location, but how do I tell it I only want it to count those marked unchecked?
Current: SELECT "Location", COUNT( * ) AS "count" FROM "Master List" GROUP BY "Location"
There's 86 items listed as being on Shelf 4, but I want to know how many of them are checked or not.
Thank you.

[FJCC]

If the column that marks the checked status is called Status, the query would look something like

Code: Select all

 SELECT "Location", COUNT( * ) AS "count" FROM "Master List" WHERE "Status" = 'checked' GROUP BY "Location"

[Kirjava]

Yep, does exactly what I want. Thank you.