【解決方法】番号(10桁)から番号(10桁)と通話時間(HH:MM:SS)で構成される会社の通話ファイルが渡されました。 同社は最近、次のことを示す新しい計画を発表しました

You have been given a call log file of the telecommunication company which consist the From Number(10Digit) To Number(10Digit) and Call Duration (HH:MM: SS). Company recently aunched the new plan stating that,

-If the Call Duration is below 1 min then there will be no cost. (Free)

-If the Call Duration is above 1 min then it will be charged at 30paise/min

Sample call log file is given. Every entry is a va id record. If there is a duplicate entry means person X is calling person Y for more than one times in a day Below is the call log file for a day

From Mobile, Tc Mcbile, Call Duration

9398989898, 8989898989, 00:05:23 1398989898, 9989898989, 01:00:23

2. Find the distinct From Numbers who used the Free Plan. (Call Duration less than 1 min)

4. Find the total income for a day. (Cost to be considered for Call Duration greater 1 min)

3. Find the total call duration with respect to From Number

Based on the plan candidate must find the below things:

1. Find the distinct From Numbers for a day.

2898989898, 8989898989, 00:05:23

1398989898, 8967898989, 00:00:40

7398989898, 2989898989, 00:02:23

8398989898, 1189898989, 00:05:20

1098989898, 8459898989, 00:00:23

5398989898, 3989898989, 00:00:23

4398989898, 5989898989, 00:01:23 5398989898, 4989898989, 00:05:55

2398989898, 6989898989, 00:00:23

2398989898, 7989898989, 00:00:21

私が試したこと：

Based on the plan candidate must find the below things: 1. Find the distinct From Numbers for a day.

2. Find the distinct From Numbers who used the Free Plan. (Call Duration less than 1 min)

3. Find the total call duration with respect to From Number

4. Find the total income for a day. (Cost to be considered for Call Duration greater 1 min)