At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Select * From ContactHistory c

Where c.ContactHistoryID In

(

Select Top 2 ContactHistoryID From ContactHistory c1

Where C1.ContactID = C.ContactID

ContactID Exists

(

select 1

from ContactHistory c2

where ContactResultID in (5,8) and C1.ContactID = C2.ContactID

group by ContactID

having count(*) > 1 )

order by 1 Desc

)

and ContactResultID in (5,8)