Custom mysql query

Hi,
Can someone help me to create a query report that shows open/pending requests older than 3 days (not onhold), sorted by technician with subject, category and request status.

Regards
Stefan