How do I translate SQL to a native query?

In the console, write out the SQL query, then use the Explain SQL query button:

Screen Shot 2022-05-17 at 9.40.27 AM

Here’s a bit of context.