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 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
- + 16 ||
on
06
ner
AVET
WE
1
Gure
pe
Vert
DES
2
w
and can
each
arts.
ME
card als
durf
01. Write a query to find the west customer name, customer_id, different cards owned and
balance left on each cand for all Premium customers?
02 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 catis made between 4th April 2018 and 5th May 20 for all premium
mers
whose call duration is greater than 10 minutes by day Output should contain total cals, date?
Q4 List total cals card used total call duration customer name, current card balance for all
customers for the month of April 2018 by customer card type ?​

Answer 1

Answer:

l don't know this questions

Explanation:

l don't know this questions