ChatGPT is an awesome collaborative SQL assistant and tutor! With guidance, it produced this: select countryname, statename, cityname from country left join city on country.countryid = city.countryid left join state on city.stateid = state.stateid;