SQL Forecasting Query

Please look at the picture attached. I need an sql query that will tell me forecast the future and tell me the revenue per day per widget. I will adapt this sql query to my current application. I want this forecasted 6 months into the future.

It is a on a PostgreSQL server. If you have a MySQL solution show it to me and if it works I will pay you for it! :)