sql请教

SELECT count(*) AS AGGREGATE FROM `order_originals`
AND EXISTS (
    SELECT
        * 
    FROM
        `order_original_labels` 
    WHERE
        `order_originals`.`id` = `order_original_labels`.`order_original_id` and (os != 'win' and os != 'mac')
) 
    AND `order_time` BETWEEN '2024-01-09 00:00:00 '
    AND '2024-01-09 23:59:59'

这个把 win 和 os 排除按理应该是除过他两所有的 但是为null的也被排除了，然后不为mac和win的也排除了