Write a program in embedded SQL to retrieve the total trip expenses of the salesman named ‘John' for the relations of SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, From_city, To_city, Departure_Date, Return_Date, Trip_ID) EXPENSE(TripID, Account#, Amount)