Assume we are using PostgreSQL, Write the SQL query that would show:

-For each Ultimate Parent ID, show the highest value Closed Won Opportunity by Type (New Customer and Renewal) -Show the Opportunity Type, Closed Date and value of each opportunity

Ultimate Parent ID Close Date Value Rank 0012K00001ak9EZQAY Opportunity Type New Customer Renewal 1/1/2020 1 Opportunity ID 0062K00000juOOBQAQ 006A000000aq4Y21RW 006A000000ae5D2IAI 0062K00000jGOKTQAO 12/9/2019 0012K00001ak9F1QAT 0012K00001ak8WrQAI 0012K00001ak8WrQAI 1 10,000 15,000 18,500 25,000 New Customer 9/12/2018 1 Renewal 9/30/2021 1