I am using this code:

```sql
create or replace view VIEW_MAXMIN as
select c.country_name,
       max(salary) max_salary,
       min(salary) min_salary
from   employees e,
       departments d,
       locations l,
       countries c
where  e.department_id = d.department_id
and    d.location_id = l.location_id
and    l.country_id = c.country_id = not in(select country_name
                                            from   countries
                                            where  country_name = 'Mexico');

```

but always error saying 'SQL command not properly ended'