Show tickets created by a user
This will also show them in descending order, which will give you the most recently created issues first.
reporter = <username> order by created DESC
Query by project
project = "Project Name"
Find issues belonging to an inactive user
reporter in (inactiveUsers())