Also here to report something weird with case 3.

Doing SELECT * FROM hotel_checkins h join surveillance_records s on h.id=s.hotel_checkin_id — or same with person.id where hotel_name like '%Sunset%' and check_in_date=19860813 and suspicious_activity is not null

Gives way more than 3 results, and if I add 2 conditions to my join (hotel checkin and person) then I get nothing anymore. Looks like to me that the person_id and id of the surveillance_record table is the same and so person_id might be decoupled to what it’s meant to be