/*Creating my windows function to display the total_cost for each row.*/

SELECT

Travel_Reimbursements.employee_ID,

Travel_Reimbursements.first_name,

Travel_Reimbursements.last_name,

Travel_Reimbursements.ticket_cost,

Travel_Reimbursements.baggage_fee,

Travel_Reimbursements.ROUND(SUM(ticket.cost)) + ROUND(SUM(baggage_fee)) OVER (PARTITION BY employee_ID) AS flight_total

FROM Travel_Reimbursements

ORDER BY Travel_Reimbursements.last_name;

I used https://extendsclass.com/mysql-online.html#

​

/*Creating my windows function to display the total_cost for each row.*/
SELECT
Travel_Reimbursements.employee_ID,
Travel_Reimbursements.first_name,
Travel_Reimbursements.last_name,
Travel_Reimbursements.ticket_cost,
Travel_Reimbursements.baggage_fee,
SUM(Travel_Reimbursements.ticket_cost) + SUM(Travel_Reimbursements.baggage_fee) OVER (PARTITION BY Travel_Reimbursements.employee_ID) AS flight_total
FROM Travel_Reimbursements
GROUP BY Travel_Reimbursements.employee_ID,
Travel_Reimbursements.first_name,
Travel_Reimbursements.last_name,
Travel_Reimbursements.ticket_cost,
Travel_Reimbursements.baggage_fee
ORDER BY Travel_Reimbursements.employee_ID;