STIF: looking for some sql help
Posted by
zork
Jun 11 '12, 13:58
|
a table that tracks calls we make to try to survey people that has ID, date-time, dial number (for that person), call outcome (busy, no answer, refusal, complete, etc.)(integer), plus a bunch of other fields:
I want to find records (IDs really I guess) for a specific date that had less than 3 call attempts, and what was the outcome of the last of the one or two tries that were made.
I then want to find out which of those had refusal outcomes on previous days.
Any suggestions as I don't feel like trying to figure it out if someone else has done something similar.
|
Responses:
|
