query to generate the report in mysql

query to generate the report in mysql

I am new to MySQL developing, we have tables in our database like below
Tables Details :
vox_cdr_admin : Containing call details
vox_gateway : Stored gateways information
vox_org_gatemap : Origination gateway & origination gateway subscriber
mapping
vox_org_gateway : Origination Gateway information
vox_org_gateway_subscriber : Origination gateway susbcriber information
vox_reseller : reseller information ( Group of subscribers{vox_subscriber})
vox_subscriber : Subscriber informations
Now i want to write the query like below.
Write the Query and generate the CDR report with following
Subsciber username, origination gateway subscriber / reseller username,
gateway name, call start time. Call end time, call billsec, dialled
number, sale cost, buy cost, profit
Write the Query for between 2 dates CDR report with following
Subsciber username, origination gateway subscriber / reseller username,
gateway name, call start time. Call end time, call billsec, dialled
number, sale cost, buy cost, profit
Please help me how to write it.