sql script in appwrite ?

is it possible to execute an sql script to one of my collections in the appwrite db ?

No, Appwrite is an abstraction on top of the underlying database and you access the data via the APIs provided

then how can i get the same result as the script i sent without using sql ?

There's a feature request for something like this so you should add a 👍 to https://github.com/appwrite/appwrite/issues/5667.

Doing something like the query you shared is not advised because it will be slower and slower as the number of records in your table grows. If the records don't get updated, the best approach is to keep a running count in some metadata collection