Technical Support Analyst Interview Questions

33,062 technical support 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 211 - 220 interview questions

Glassdoor has 33,062 interview questions and reports from Technical support analyst interviews. Prepare for your interview. Get hired. Love your job.