Tell me the vehicle id and staff id for all lesson id's...
select t1.vehicle_id, t2.staff_id from vehicles as t1 join lessons as t2 on t1.vehicle_id = t2.vehicle_id
What is the vehicle details of vehicle id 1 and 2 ?
select vehicle_details from vehicles where vehicle_id = "1" or vehicle_id = "2"
What is the price of vehicle id 2 ?
select price from lessons where vehicle_id = "2"
What is the id and detail of the vehicle used in lessons for most of the times ?
select t1.vehicle_id, t1.vehicle_details from vehicles as t1 join lessons as t2 on t1.vehicle_id = t2.vehicle_id group by t1.vehicle_id order by count ( * ) desc limit 1