我是一个SQL初学者，我需要你的帮助。很抱歉，我不知道这个问题是否正确。
现在代码给出了这个;

+---------+----------+-------------+------------+
|      id | CompanyId| DealId      | price      |
+---------+----------+-------------+------------+
|       1 | 1        | 1           | 100        | 
|       2 | 1        | 2           | 50         | 
|       3 | 1        | 3           | 25         |
|       4 | 2        | 1           | 1000       |
|       5 | 2        | 2           | 2000       |
|       6 | 2        | 3           | 2500       |
+---------+----------+-------------+------------+

但这是我想要的

+---------+----------+-------------+------------+------------+--+
|      id | companyId| DealName1   | DealName2  | DealName3  |  |
+---------+----------+-------------+------------+------------+--+
|       1 |  1       | 100         | 50         |   25       |  |
|       2 |  2       | 1000        | 2000       |   2500     |  |
|       3 |  3       | value       | value      |   value    |  |
|       4 |  4       | value       | value      |   value    |  |
+---------+----------+-------------+------------+------------+--+