A certain telecom company issues calling cards of various denominations and types. The customer can buy a card and use them to make a call. The card can be renewed on expiration of the amount on the card. A customer can have more than one card in his account. The call duration, the card used for the call , the time of call are recorded. Review the data model below and answer the following questions :
Q1. Write a query to find the list customer_name, customer_id, different cards owned and balance left on each card for all Premium customers?
Q2. List the total renews of customers by different card types. Output should contain customer_id, card_type, card_name and total renewd_amount?
Q3. List total calls made between 4th April 2018 and 5th May 2018 for all premium customers whose call duration is greater than 10 minutes by day.Output should contain total calls , date?
Q4. List total calls, card used, total call duration, customer name, current card balance for all customers for the month of April 2018 by customer, card type ?
Solved by verified study co-pilot
All Study Co-Pilots are evaluated by Gotit Pro as an expert in their subject area.