2 Way logic thinking solution
\n1)\nselect lastname, firstname, \n         (select top 1 city\n             from address \n          where personid = p.personid\n             ) as city,\n   
```\n1)\nselect lastname, firstname, \n         (select top 1 city\n             from address \n          where personid = p.personid\n             ) as city,\n            \n         (select top 1 state\n             from address\n          where personid = p.personid\n             ) as  state\nfrom person p\n\n2)\nselect p.lastName, p.firstname , a.city,a.state\nfrom person p left join address a on p.personId = a.personId\n```
[]