What is Self-service purchase? · Ultra Transcenders glossary

A trial or paid plan an individual signs up for and pays for themselves. Admins see it, yet can only hand out its licences after taking it over.

In the Ultra Transcenders books

Each book explains Self-service purchase in context, with comparison tables and the common traps.

OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.