c# sqlite how to search date inside start and end dates

How To Search Date in SQLite ..

TABLE1

ID __ NAME __ MOBILE _______ START _____ END

0 ___ RAJ __ 99999 99999 ____ 25-03-2015 __ 31-01-2017

1 ___ SIVA __ 88888 88888 ____ 25-07-2015 __ 23-12-2016

2 ___ RAJ __ 77777 77777 ____ 18-03-2015 __ 16-08-2016

---

QUERY - SELECT MOBILE FROM TABLE1 WHERE NAME = RAJ && DATE = 12-04-2016

OUTPUT - 99999 99999
_________ 77777 77777

---

Like - 25-0-2015 to 31-01-2017 < 12-04-2016 this date is available.. sorry for bad english.. please help..
I mean -- raj is available in the date 12-04-2016.. because raj join date 25-0-2015 and resign date 31-01-2017..