SELECT COUNT(s.*) AS store_id_null_count,COUNT(c.*) AS employee_id_null_count
FROM (SELECT * FROM nexus_stores.cashier_shifts WHERE store_id IS NULL) AS s
FULL JOIN (SELECT * FROM nexus_stores.cashier_shifts WHERE employee_id IS NULL) AS c
ON s.id = c.id