How can I query opportunity information based on the reason for closing?

Expand more criteria on the opportunity list page. You can use the success and failure reasons to query data. The relationship between different conditions is "and" (NOT "or"). If you select success and failure reasons as conditions at the same time, no data will be found.