HO Stock Take SQL Queries

Hi I would like to send a sql query down to store level from HQ to count x dept / x category (at x retail). Any idea's on the required sql query? We need to do this to prevent the stores from setting the filters incorrectly at store level.

Thanks