How to use [sqlite.scalar]

The reference page of sqlite.scalar has its arguments, constraints and declaration.

Executes an arbitrary SQL statement, and returns the result as a scalar value to caller