SQL query to retrieving recent 8 tickets

Hello,

  I am implementing Kitchen display for my store where I need to display last 8 tickets with items, void and other details.  What would be the SQL query to retrieve this data?

My idea is running a python web server on a back office computer where MS SQL Server is running.   Web Server will process incoming request, execute SQL query to retrieve recent 8 tickets details and return data in a formated HTML page.

Client (Raspberry Pi) will be accessing web page and refresh every 1 minute.

Thanks,

DQ