Skip to contentSkip to footer

Technical Expert Interview Questions

Salaries
Interviews

7,576 technical expert 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.1★
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 21 - 30 interview questions

Glassdoor has 7,576 interview questions and reports from Technical expert interviews. Prepare for your interview. Get hired. Love your job.