Step 6 of 18 of the SQL tutorial. A Mango query is one JSON object with four keys that do the work: selector filters, fields projects, sort orders and limit cuts. skip steps over the front, the way OFFSET does. Read them against the SQL clause by clause — the vocabulary is different, the question is not. Both return listings 6 to 10 of the 24 compounds carried by at least a hundred suppliers.
It opens on the query SELECT preferred_name, formula, nb_suppliers FROM compounds WHERE nb_suppliers >= 100 ORDER BY nb_suppliers DESC LIMIT 5 OFFSET 5, which you can run and change in place.
Ask the same question of a chemical dataset in SQL and in Mango and compare the two answers. The database is a SQLite file your browser downloads once and queries locally, so nothing you write ever leaves your machine — which is also why the tool needs JavaScript.