以下SQL 语句如何使用 TP5.1 查询构造器 查询

原生SQL

SELECT
    count( `id` ) AS num 
FROM
    `houses` h 
WHERE
    (
    `id` NOT IN (
SELECT
    `house_id` 
FROM
    `contract_lord` 
WHERE
    `deleted_at` IS NULL 
    AND ( end_type IS NULL OR end_type = '' ) 
    AND ( end_at > curdate( ) ) 
    AND `house_id` IS NOT NULL 
GROUP BY
    `house_id` 
    ) 
    OR `id` NOT IN ( SELECT `house_id` FROM `contract_lord` WHERE `house_id` IS NOT NULL AND `deleted_at` IS NULL GROUP BY `house_id` ) 
    ) 
    AND h.`is_nrcy` = 0 
    AND `h`.`deleted_at` IS NULL 
    AND 1 = 1