The aggregate / window function in Sqlite.
Sqlite supports the following aggregate /window function 1):
You use a aggregate/window function and you apply the all partition with the syntax over ()
Example:
select
sold,
(sold / sum(sold) OVER () * 100) as perc
from mySales
We sqlite you create bin (Statistics - (Discretizing|binning) (bin)) with the ntile function
select
orderNumber,
amountSold,
ntile(6) over (order by amountSold asc) as bin
from
mySales
order by amountSold desc