Select Query To Get Last 9 Months Data in SQLite3

Without giving you the answer (because you need to do some work yourself), this should gvie you a starting point.

SELECT * FROM GuestInfo 
WHERE ArrivalDate >= (Today's date - your definition of 9 months before today)