Query - group and login

Hi everyone, I need a query that gives me the following information:

Request ID, Technician, Status, Created Time, Completed Time, Login and group.

Tks a lot,
Thaiz Cabral