subselect.sql

SELECT 
  "user".id,
  "user".name,
  (
    SELECT l.name
    FROM location l
    WHERE location.user_id=l.user_id
    ORDER BY l.moved_on DESC
    LIMIT 1
  ) current_location,
  CASE WHEN 
    EXISTS (
      SELECT l.id 
      FROM location l
      WHERE 
        location.user_id = l.user_id AND 
        location.moved_on > l.moved_on
    )
    THEN 'True'
    ELSE 'False'
  END AS is_miami_latest_location
FROM location
JOIN "user"
  ON "user".id = location.user_id
WHERE
  location.name = 'Miami'
;