How to write query to find issues completed ("Done" status) in a given sprint ?

[Ashutosh Salgarkar]

How to write query to find issues completed ("Done" status) in a given sprint ? 

If I write a query with status is done and sprint is equal sprint name, it gives me isssues with status done and these issues were once in the sprint which I mention in the query. This does not mean the status was changed to done in that sprint. This may have issues which are done but may be they were pushed to the next sprint (next to the sprint mentioned in the query) and status was changed to done in next sprint.

I want issues that were closed (status changed to done) in give sprint.

[Suhas P]

You can use Sprint report from the scrum board for this purpose. There you have dropdown option to select a specific sprint. You also get an option to 'View in Issue Navigator' option.