Technical Analyst Interview Questions

35,206 technical analyst interview questions shared by candidates

There are two tables: users and countries. Each has two columns. Countries lists a city name and then the country it is in (Moscow : Russia, New York : USA, etc). Users lists an ID and a city name (1 : New York, 2 : Helsinki, etc). Note that there are cities listed in users that do NOT appear in countries. Output a table listing all the IDs and the corresponding countries, but be sure any NULL value is changed to "unknown."
avatar

Technical Support Expert

Interviewed at Crossover for Work

4
Sep 11, 2020

There are two tables: users and countries. Each has two columns. Countries lists a city name and then the country it is in (Moscow : Russia, New York : USA, etc). Users lists an ID and a city name (1 : New York, 2 : Helsinki, etc). Note that there are cities listed in users that do NOT appear in countries. Output a table listing all the IDs and the corresponding countries, but be sure any NULL value is changed to "unknown."

Viewing 221 - 230 interview questions

Glassdoor has 35,206 interview questions and reports from Technical analyst interviews. Prepare for your interview. Get hired. Love your job.