Following SQL query help to find all the application responsibilities assigned to a specific user or users with start date and end dates, provided a user name.
Query can be further tweaked to suit to your needs and fetch additional information life user names in detail, responsibility ID other responsibility details.