Question

4. Telecommunications Billing Invoice>L>A telecommunications company charges its customers for both incoming>and outgoing calls based on the number of call units. A call unit is an>internal representation of the amount that the company should charge its>customers. It maintains the records of all the calls made on its network in>table, call_record, storing information such as incoming number, outgoing>number, duration of the call and the date on which the call was made.>Write a query to calculate the bills of all the customers for the month of>May, 2018. It should only include customers who have made or received>any calls in the given period. The order of output does not matter. The>result should be in the following format: name phone_number call_units>2>The company calculates charges as follows:>3>• For incoming calls, a standard charge of 1 call unit/second is levied. Example:>For an incoming call of 2 m

Answer 1

Answer:

What da fuq .... 5 inch question ?????