Domanda di colloquio di American Express

SQL: How would you identify and fix dual redundant transaction errors in a table of transactions using SQL? Case Study: Guesstimate question: Identify the number of cars currently being used in Gurugram. How would you approach this query?