Which contact codes were used for less than 5 minutes?
select channel_code from customer_contact_channels group by channel_code having count ( customer_id ) < 5
What are their contact numbers?
select channel_code,contact_number from customer_contact_channels group by channel_code having count ( customer_id ) < 5
Both of them
select channel_code,active_from_date,active_to_date from customer_contact_channels group by channel_code having count ( customer_id ) < 5