-
List the premium customers who is not using the service within the last one week.
List the premium customers who is not using the service within the last one week.if you have these tables: 1-'Premuim_USER'columns: Customer_ID, post_paid.2-'calls'columns: called_number, Customer_ID, call_date, call_time_started, Call_time_ended, transaction_no.
-
For each hour, list the number of called, total transactions' values, and total duration.
For each hour, list the number of called, total transactions' values, and total duration?if you have these tables:1- 'calls'columns: called_number, Customer_ID, call_date, call_time_started, Call_time_ended,transaction_no.2- 'tariff'columns: Tarriff_per_Sec, country_code, time_started, time_ended.
-
List all customer (user id, name, and e-mail), number of charging
List all customer (user id, name, and e-mail), number of charging, total charging,number of transaction and total number of transaction value?If u have these tables:1- 'Credit_card'columns: credit_number,type,value,Customer_ID.2-'Coupon'columns: Coupon_number,value,password,Customer_ID3-'Customer'columns: Customer_ID,Fname,Mname,lname,E_mail,password,bdate,tot_trans,mobil_no,hom_no,ex_id_date,current_Balance.