Question: Task 1: A certain telecom company issues calling cards of various denominations and types. The customer can buy a card and use them to make


Task 1: 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 : card master antomer telecom_operator Pand hor ENUM( ] Guld An DATEIN Warmand let off offerent calling cards walktly card denomina tion 1. Ropes 2 Premium Gold ontoner_cards when INT Master lot of all customer of the calling card company A calling and can have one or more A cullomen can have one or more +assand INT Pard d INT Call donate off the customer. (Many to Marg) Unemotional + 1- True. 9- Dominic cullen 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
