what i liked about this is that the answer provided had used "AND" between joins as well

PHOTO EMBED

Wed Mar 22 2023 03:16:20 GMT+0000 (Coordinated Universal Time)

Saved by @vnmshenoy #undefined

​the answer as hint (see how AND is used for multiple join conditions between same table ...last line)
SELECT
  couples.couple_name,
  couples.pref_location,
  apartments.id
FROM couples
JOIN apartments
  ON apartments.price NOT BETWEEN couples.min_price AND couples.max_price
  AND location != pref_location

///////////////////
btw my answer also worked

SELECT c.couple_name,c.pref_location,a.id
FROM apartments a
join 
couples c on c.pref_location <> a.location
where a.price not between c.min_price and c.max_price

content_copyCOPY

https://learnsql.com/track/sql-practice/course/joins/non-equi/exercises/exercise-2