please help me with a mysql query report
Dear support team ,
please help me create a query report that our new boss asked. we are using version 7604 and MySql.
the report is a MONTHLY report , its' columns are :
1. ID : not request id, but the sequence number of record in this report, starting from 1
2. Create Time: request created time , displayed as yyyy-mm-dd hh:mm:ss
3. Dept: the requester's department
4. Requester: the requester name
5. Tel: the requester's phone number
6. Engineer: the first technicain assigned to this request
7. Description: the request description
8. Resolution: the request resolution
thank you very much for helping me :)
please help me create a query report that our new boss asked. we are using version 7604 and MySql.
the report is a MONTHLY report , its' columns are :
1. ID : not request id, but the sequence number of record in this report, starting from 1
2. Create Time: request created time , displayed as yyyy-mm-dd hh:mm:ss
3. Dept: the requester's department
4. Requester: the requester name
5. Tel: the requester's phone number
6. Engineer: the first technicain assigned to this request
7. Description: the request description
8. Resolution: the request resolution
thank you very much for helping me :)