Database: vehicle_rent
Question: Find the name and powertrain type of the cars that rented for more than 30 total hours.
SQL:
SELECT T2.name ,  T2.Type_of_powertrain FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T1.vehicles_id HAVING sum(T1.total_hours)  >  30