Question
Answering the questions using the database provided with the SQL statments a)List the callsID and destination phone number of calls made in 2006 whose duration
Answering the questions using the database provided with the SQL statments
a)List the callsID and destination phone number of calls made in 2006 whose duration was greater than 150.
b) As in query a) plus show the calling mobiles phone number.
c) As in query b) plus show the calling customers full name.
d) As in query c) except select only calls made on Saturday or Sunday (weekend) and show the cost of the call.
e) List all the pink mobile phones that are currently active and are on the Yes10 plan. Show the customer ID, customer's full name, phone number, joined date and the brand name of phone and the connection fee for the mobile.
f) Show a list of the tower usage. Display the tower ID and the number of calls connected through each tower, the location and the maximum connections
g) Show the full name and sex of each staff member and the name and sex of their supervisor (Hint: self join)
h) Display the full names of customers that have not bought any mobile phones. (Hint: outer outer join).
staff staffID customer customerID surname given Name dob calls callID mobileID phoneNumber callDate callDuration surname tower towerID location bandwidth maxConn connection connectID tower ID callID givenName sex mobile mobileID phone Number brandName joinDate cancelDate planName phoneColour customerID staffID sex phoneHome phone Work phone Fax address suburb state postcode joinDate resignDate address suburb postcode phone supervisorID commission rate PerHour plan planName connectFee peakFee offPeakFee weekendFee Entity-Relationship Diagram customer superv Dses plan Gas mobile staff call ses tower
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started