-- Database schema
| state : StateCode [ TEXT ] primary_key , State [ TEXT ] , Region [ TEXT ] | callcenterlogs : Date received [ DATE ] , Complaint ID [ TEXT ] primary_key , rand client [ TEXT ] callcenterlogs.rand client = client.client_id , phonefinal [ TEXT ] , vru+line [ TEXT ] , call_id [ INTEGER ] , priority [ INTEGER ] , type [ TEXT ] , outcome [ TEXT ] , server [ TEXT ] , ser_start [ TEXT ] , ser_exit [ TEXT ] , ser_time [ TEXT ] | client : client_id [ TEXT ] primary_key , sex [ TEXT ] , day [ INTEGER ] , month [ INTEGER ] , year [ INTEGER ] , age [ INTEGER ] , social [ TEXT ] , first [ TEXT ] , middle [ TEXT ] , last [ TEXT ] , phone [ TEXT ] , email [ TEXT ] , address_1 [ TEXT ] , address_2 [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zipcode [ INTEGER ] , district_id [ INTEGER ] client.district_id = district.district_id | district : district_id [ INTEGER ] primary_key , city [ TEXT ] , state_abbrev [ TEXT ] district.state_abbrev = state.StateCode , division [ TEXT ] | events : Date received [ DATE ] , Product [ TEXT ] , Sub-product [ TEXT ] , Issue [ TEXT ] , Sub-issue [ TEXT ] , Consumer complaint narrative [ TEXT ] , Tags [ TEXT ] , Consumer consent provided? [ TEXT ] , Submitted via [ TEXT ] , Date sent to company [ TEXT ] , Company response to consumer [ TEXT ] , Timely response? [ TEXT ] , Consumer disputed? [ TEXT ] , Complaint ID [ TEXT ] events.Complaint ID = callcenterlogs.Complaint ID , Client_ID [ TEXT ] events.Client_ID = client.client_id | reviews : Date [ DATE ] primary_key , Stars [ INTEGER ] , Reviews [ TEXT ] , Product [ TEXT ] , district_id [ INTEGER ] reviews.district_id = district.district_id |
-- -- How many of the complaints are longer than 15 minutes?

SELECT COUNT(ser_time) FROM callcenterlogs WHERE strftime('%M', ser_time) > '15';