Senior Technical Support Interview Questions

600 senior technical support interview questions shared by candidates

SQL Challenge (During Technical Interview): Validate Company Names Using TIN You are given two tables representing internal client records and external tax authority data. 🔹 internal_clients id | tin | company_name ---|------------|----------------------------- 1 | 123456789 | Google Limited Services 2 | 987654321 | Apple International Inc 3 | 567890123 | Amazon Logistics LLC 4 | 111222333 | Meta Platforms Ltd 🔹 external_tax_office tin | registered_name -----------|---------------------------- 123456789 | Google Services LTD 567890123 | Amazon Logistics LLC 999888777 | Netflix Corp Write a SQL query that: Compares the TINs from both tables. Returns a result showing: Which TINs exist in both tables Which TINs exist only in one table Label each row with one of the following: 'match' → TIN exists in both tables 'internal_only' → TIN exists only in internal_clients 'external_only' → TIN exists only in external_tax_office Your output should have just 2 columns: tin, source Paste your final query below.
Sep 12, 2025

SQL Challenge (During Technical Interview): Validate Company Names Using TIN You are given two tables representing internal client records and external tax authority data. 🔹 internal_clients id | tin | company_name ---|------------|----------------------------- 1 | 123456789 | Google Limited Services 2 | 987654321 | Apple International Inc 3 | 567890123 | Amazon Logistics LLC 4 | 111222333 | Meta Platforms Ltd 🔹 external_tax_office tin | registered_name -----------|---------------------------- 123456789 | Google Services LTD 567890123 | Amazon Logistics LLC 999888777 | Netflix Corp Write a SQL query that: Compares the TINs from both tables. Returns a result showing: Which TINs exist in both tables Which TINs exist only in one table Label each row with one of the following: 'match' → TIN exists in both tables 'internal_only' → TIN exists only in internal_clients 'external_only' → TIN exists only in external_tax_office Your output should have just 2 columns: tin, source Paste your final query below.

Viewing 161 - 170 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 600 interview questions and reports from Senior technical support interviews. Prepare for your interview. Get hired. Love your job.