you need to do a query to fetch the data about the first call. Include the phone number, towerID and the customer details (customerID and name) on which the number was registered. Note: you may get multiple records.I would need the query in sql

 

COOPP///// 111111 ASSESMENT 2 TABLES CALLS PK CALLSID FK MOBILE CD L CALLED NUMBER CALL DATE CALL TIME CALL DURATION DATAUSAGE CONNECT CUSTOMER MOBILE PLAN PK CONNECT ID PR CUSTOMERID PK MOBILE IP PAPLAN NAME SURNAME PHONE NUMBER BREAKFEE GIVEN DOB SEX PRTOWER ID FK CALLS ID PHONE HOME PHONE WORK BRANDNAME JOINED CANCELLED PLAN NAME PHONE COLOUT PHONEFAX CUSTOMERID ADDRESS FR STAFF ID SUBURB STATE POSTCODE DATA ALLOWANCE MONTHLY FEE PLAN DURATION CALLCHARGE Tema STAFF TOWER PASTAFFID PR TOWER ID SURNAME LOCATION GIVEN BANDWIDTH DOB MAXCONN SIGNALTYPE Q SEX JOINED RESIGNED ADDRESS SUBURB POSTCODE PHONE SUPERVISORID COMMISSION RATE PER HOUR