PostgreSQL Where count condition
SELECT
    COUNT(a.log_id) AS overall_count
FROM
    "Log" as a,
    "License" as b
WHERE
    a.license_id=7
AND
    a.license_id=b.license_id
AND
    b.limit_call > overall_count
GROUP BY
    a.license_id;

License(license_id, license_name, limit_call, create_date, expire_date)
Log(log_id, license_id, log, call_date)

SELECT a.license_id
      ,a.limit_call
      ,count(b.log_id) AS overall_count
FROM   "License" a
LEFT   JOIN "Log" b USING (license_id)
WHERE  a.license_id = 7
GROUP  BY a.license_id, a.limit_call
HAVING (count(b.log_id) > a.limit_call) IS NOT TRUE

SELECT
COUNT(a.log_id) AS overall_count
FROM
"Log" as a,
"License" as b
WHERE
a.license_id=7
AND
a.license_id=b.license_id
GROUP BY
a.license_id
having b.limit_call > count(a.log_id);