SQL Query to fetch Information of Order and RMA who entered

Hello,

I wanted to know if there is any way that I can get a report setup to run weekly, monthly, quarterly and yearly, that would provide me the following productivity numbers  per person who processed the activity listed below.

I need to build up a SQL Query which will fetch the below information:

# Orders - Entered

# Orders - Booked

# Orders - Cancelled

# Orders - Shipped Confirmed

# Sales Orders Invoices - Ran

# RMA’s - Entered

# RMA’s - Booked

# RMA’s - Cancelled

# RMA’s - Received (Good receipt processed)