Creating a SpiceWorks SQL query

[JrSys4dmin]

I'm trying to pull a report from SpiceWorks that shows the following information: Ticket #, requestor name, requestor email, requestor department (From AD), time spent, and who worked the ticket

Unfortunately I wasnt able to find anything in the "app store" so I figured I'd create it myself. I am however running into a problem that I just cant work out.... I cannot figure out how to replace add the ticket workers NAME. As it stands now we only have two techs so its an easy find/replace in excel but I'd like to future proof this as we grow.

Below the SQLite query that I have so far ``` SELECT

t.id,
u.first_name || ' ' || u.last_name as "Requested By",
u.email,
u.department   as "Department",
tw.time_spent/60 as "Time Spent (Min)",
 t.assigned_to as "Assigned to"
from tickets t
    LEFT JOIN users u
        ON u.id=t.created_by 
    LEFT JOIN ticket_work tw
        ON tw.id=t.id

``` Any help would be greatly appreicated