<p>我有一個名為employee experience的表，包含id、userId、startDate和endDate欄位。 </p> <p>我想計算員工的工作經驗。有人可以幫忙提供mysql查詢或JPA規範的程式碼嗎？ </p> <p>例如，對於以下資料：</p> <table class="s-table"> <thead> <tr> <th>id</th> <th>用戶ID</th> <th>開始日期</th> <th>結束日期</th> </tr> </thead> <tbody> <tr> <td>1</td> <td>1</td> <td>2021-01-01</td> <td>2022-01-01</td> </tr> <tr> <td>2</td> <td>2</td> <td>2019-01-01</td> <td>2020-01-01</td> </tr> <tr> <td>3</td> <td>2</td> <td>2020-01-02</td> <td>2021-01-01</td> </tr> <tr> <td>4</td> <td>3</td> <td>2021-01-01</td> <td>2022-01-01</td> </tr> </tbody> </table> <p>輸出應為：</p> <table class="s-table"> <thead> <tr> <th>用戶ID</th> <th>經驗</th> </tr> </thead> <tbody> <tr> <td>1</td> <td>1</td> </tr> <tr> <td>2</td> <td>2</td> </tr> <tr> <td>3</td> <td>1</td> </tr> </tbody> </table></p>

SELECT SUM(TIMESTAMPDIFF(YEAR, START_DATE, END_DATE)) AS experience,
          SOCIAL_PROFILE_ID
   FROM tableName
   GROUP BY SOCIAL_PROFILE_ID