SQLite Create view by session

I'm faced with the following problem... I have plain table, that contains columns

(record_id, frame, ssid, date, mac)

I need to create view in sqlite database, that will contains sessions for each unique mac from table. Session should reference to rows from table and defined in such way: take string one by one and if

current_string.date - previous_string.date > 30

create new session. Is it possible to do in SQL?