Cosmos supports all the basic SQL syntax, so you can run the normal SELECT statments with WHERE clauses.
Some typical SQL statements don’t work as expected, but the output messages in the Data Explorer should help you find the problem.
Need more? Here’s the solution.