Write a SQL query to identify the top three highest-performing user segments based on multi-table joins and window functions.
