How to retrieve information from orders with SQL

[PrestaSG]

Hello,

 

I would like to retrieve some information that are shown in the backend order page.

 

I would like to write SQL queries that will allow me to get information for several orders at a time, for instance all orders for the last month or the last 6 months.

 

What I would like to retrieve:

 

- the number of 1st orders within a certain period (for instance how many orders in the last month were 1st orders for those customers). On each order it shows whether or not it is the client's first order, but I can't find this information in the database.

 

- the way the client arrived on the page. I have a "Source" menu in each order where I can see how the client arrived on the page (email, google, ...) and if applicable the keywords that he typed. I can't seem to find these information anywhere in the database. Where can I find them?

 

Thank you very much for your help!