In general, I don't like those X-to-Y translation pages, when the underlying concepts fundamentally change. You can't use your existing sql mindset to translate to their query language, but instead try to learn from scratch.
We have a similar page at ArangoDB to help developers used to SQL to understand the general differences in AQL: https://www.arangodb.com/why-arangodb/sql-aql-comparison/