SELECT T2.name ,  sum(T1.total_hours) FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T2.id
Show the name and total hours of renting for each vehicle.
CREATE TABLE "Customers" (
"id" int,
"name" text,
"age" int,
"membership_credit" int,
PRIMARY KEY ("id")
);
CREATE TABLE "Discount" (
"id" int,
"name" text,
"membership_credit" int,
PRIMARY KEY ("id")
);
CREATE TABLE "Vehicles" (
"id" int,
"name" text,
"Model_year" int,
"Type_of_powertrain" text,
"Combined_fuel_economy_rate" int,
"City_fuel_economy_rate" int,
"Highway_fuel_economy_rate" int,
"Cost_per_25_miles" real,
"Annual_fuel_cost" real,
"Notes" text,
PRIMARY KEY ("id")
);
CREATE TABLE "Renting_history" (
"id" int,
"customer_id" int,
"discount_id" int,
"vehicles_id" int,
"total_hours" int,
PRIMARY KEY ("id"),
FOREIGN KEY ("customer_id") REFERENCES "Customers"("id"),
FOREIGN KEY ("vehicles_id") REFERENCES "Vehicles"("id"),
FOREIGN KEY ("discount_id") REFERENCES "Discount"("id")
);
INSERT INTO  "Customers" VALUES (1, "Griffiths",26, 100);
INSERT INTO  "Discount" VALUES (1, "no discount", 0);
INSERT INTO  "Vehicles" VALUES (1, "Chevrolet Spark EV","2014","Electric","119","128","109","0.87","500","See (1)")
INSERT INTO  "Renting_history" VALUES (1,1,1,2,1);