There was a question in sql
Are the following:
there are three tables
first, let's say, with fields "person-titles-city (code)", the second "city (code)-city(transcript)-country (code)", the third "country (code)-country (transcript) — the continent."
At the entrance are the variable that defines the person. How to query in database to get all the information from three tables related to person, i.e. "title-town (transcript)-the country (transcript)-the continent"
A particularly interesting option with the use of a correlated nested subqueries.