I'm working on converting results from a MySQL database to a Postgresql one, and finding random syntax issues that searching isn't helping with.

For this one: I am trying to return a list of results for users who have not created a job in our system for over 90 days. I've tried a few variations, but here is where my code is at right now:

```
 select  law_firms.name as "Law Firm"
from law_firms
left join jobs on jobs.law_firm_id = law_firms.id
  where jobs.id IN (SELECT jobs.created_at::date >= 90) IS NULL
  and law_firms.deleted_at IS NULL
  and law_firms.name not like '%Temp%"'
  and law_firms.name not like '%Individual%'
  GROUP BY law_firms.name

```

I've tried a few different variations of ::date between and CASTS, but it's coming back with an error message of **"ERROR: operator does not exist: date >= integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts"**

For reference, the MySQL code that worked in our BI originally was:

```
where `jobs`.`id` IN (SELECT `jobs`.`created_at` BETWEEN NOW() - INTERVAL 90 DAY AND NOW()) IS NULL

```