Hard
SQL Query Performance Analysis
Analyze and optimize a slow SQL query with index suggestions.
📝 Nội dung Prompt
Analyze the following SQL query for performance bottlenecks. Suggest an optimized version of the query and recommend which indexes should be created to improve execution speed on a table with 1 million rows.