Pergunta de entrevista da empresa PhonePe
1st round: SQL MCQ Question: asks to write an SQL query to match customers who are from the same city and country.
Resposta da entrevista
Sigiloso
15 de out. de 2024
SELECT City, Country, GROUP_CONCAT(FirstName, LastName) AS name FROM CUSTOMERS GROUP BY City, Country HAVING COUNT(*) > 1;