You are required to query an index in an Azure AI Search solution. The query needs to include syntax for sorting, filtering, and using wildcards. Describe the steps you would take to construct and execute this query, ensuring it meets the requirements for sorting, filtering, and wildcard usage.