Calculating Remaining Hours from Multiple Time Entries on Individual Tickets

We have a KACE K1000 that uses a MYSQL DB to house all of our ticket data.

From the below table I would like to make a new table/report that for each "HD_TICKET_ID" want to add up the total of each associated "Total Hours Worked" row and subtract that sum from the "Hours Purchased" Column and have the result in a new column, "Hours Remaining".

I'm sorry, I'm not a DBA, or really a PowerBI guy. Please let me know any other info I can provide that will assist.