Database: vehicle_rent
Question: What are the names and powertrain types of cars that have more than 30 total rental 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