Aspire Lifestyles interview question

How would you handle missing or inconsistent data in a dataset? Write an SQL query to find the second highest salary from a table of employees. Explain a situation where your analysis impacted a business decision.