Bex query - templets

Hi,

Can anyone give me some examples or templets of Bex query for Auto mobile service industry please.

Queries like Inventory maintenance, Consumption of Parts each vehicle at the time of service, Number of Vehicles a service engineer attended per day/ week/ month, etc.

Please give me some details about it.

Regards