Top Equipment Failures with Window Functions

Given a table of production logs, how would you identify the top three equipment failures using a window function?

Use the production_logs table and consider only rows representing failures with a non-null failure code.

Output

1. One row per failure code ranked among the most frequent failures.
2. Columns: failure_code, failure_count, and failure_rank.
3. Include ranks 1 through 3, order by failure_rank ascending, then failure_code ascending, and include ties at the third rank.