Solve Using SQL code :

Data model notes: - The total value of each deal was least $1 billion. - A deal could be carried out in parts, with each part being of a different type (stock swap, cash, etc.) - Each deal involved at least 2 players. A player here is a company that is the subject of the deal. If there are multiple bidders for a company being acquired, then each bidder is a Player. - Each player is supported by several firms that provide legal, banking, PR, or other services. Warmups to Get Familiar with the Data Use aliases to give each column a meaningful name. We're pros here. 1. What are the types of deals? 2. What are the possible roles a player may play in a deal? 3. What kinds of support do the firms provide? 4. How many companies are there? 5. How many deals are there? 6. What kinds of firms are represented in the database? 7. How many investment banks are listed in the database? 8. How many law firms are there? More advanced queries that demonstrate mastery 9. How many firms are there of each type? For each firm type, calculate the total number of firms. 10. For each deal, which companies were involved and what was the role of each one? Show the deal name, company names, and roles. Limit your answer to 20 rows. (Optional challenge: limit it to 10 deals.) 11. What is the total value of each deal? Show the deal name, the number of parts, and the total value. Limit your answer to the 10 deals. 12. What were the ten biggest deals by total dollar value. Repeat query 11 but only show the 10 biggest deals. 13. Which companies were players in the top 10 deals? Show the deal name, total value, company, and role. You will have at least two rows per deal. 14. Break down the deals by type. For each deal type, provide the type code, number of deals, and total value of deals. 15. Which law firms supported the most deals? How much was the total value of the deals for each firm Show the firm name, number of deals, and the total values of the deals. You may need to use a subquery (or two) for this one