Рассмотрим следующий запрос: select corpus_date as alias ,lead(word, 1) over (partition by corpus order by word_count desc) lead ,max(word_count) over (partition by corpus) max_word_count from [publicdata:samples.shakespeare] where...

Учти это: SELECT review.clicker_id, sum(review.done - review.due) as timespent, PERCENTILE_DISC(0.5) WITHIN GROUP(ORDER BY timespent ASC) as median FROM review WHERE monologue_id=7142 GROUP BY clicker_id ORDER BY timespent ASC; Я...