Функция UCASE() Функция SQL UCASE() преобразует строку в верхний регистр. Синтаксис: UCASE(text).

Channel
Senior SQL Developer
@seniorsql
On this record: Growth · Engagement · What this channel posts · Posts · Citations · Cite this entry
14,449subscribers
-31 since we began measuring on 7 August 2026
Risers and fallers across the register · movement among entries of 10,000–31,623.
Register entry
| Telegram ID | -1001468396285 |
|---|---|
| Type | Channel |
| Username | @seniorsql |
| Description | № 4931128435 Изучаем SQL. По вопросам сотрудничества: @adv_and_pr |
| Created | Between 1 April 2019 and 30 September 2021— estimated from Telegram’s id allocation, not measured. How this range is calculated. |
| First recorded | 7 August 2026 |
| Last confirmed live | 14 August 2026 |
| Measurements held | 9 |
| Confirmed unchanged | 1 time, most recently 14 August 2026 |
| On Telegram | t.me/seniorsql |
Growth
| Measured (UTC) | Subscribers | Change |
|---|---|---|
| 14 Aug 2026, 07:57 | 14,449 | -7 |
| 12 Aug 2026, 23:57 | 14,456 | -7 |
| 12 Aug 2026, 01:33 | 14,463 | -1 |
| 11 Aug 2026, 00:08 | 14,464 | -2 |
| 10 Aug 2026, 03:31 | 14,466 | -6 |
| 9 Aug 2026, 01:40 | 14,472 | -5 |
| 8 Aug 2026, 03:59 | 14,477 | -3 |
| 7 Aug 2026, 06:30 | 14,480 | no change |
| 7 Aug 2026, 06:24 | 14,480 | first reading |
Engagement
26 posts held, back to 6 July 2026 — the reader has not yet reached the start of this channel’s public history, so older posts may sit further back, unread. Read across 19 pagesof Telegram’s post history, 20 posts per page.
- ERR · 30 days
- 7.39%
- avg views ÷ 14,449 subscribers
- Avg views / post
- 1,070
- 20 posts measured
- Reaction rate
- —
- this channel exposes no reaction counts
- Posts in window
- 20
- of 26 held
ERR is average views per post over the last 30 days divided by subscribers, the definition TGStat uses, so this figure is comparable with the one you will see elsewhere. It falls structurally as a channel grows: a high ERR on a small channel and a low one on a large channel describe reach mathematics, not quality. We publish the figure and the sample it came from and pass no verdict on it.
ER is defined industry-wide as (forwards + reactions + comments) ÷ views— note the denominator is views, not subscribers. Telegram’s public web preview carries views and reactions but not forward or comment counts, so the reaction rate above is the reactions term only and is therefore a floor: the true ER for this channel is higher by an amount we have not measured and will not estimate.
| Window | Rolling 30 days · latest post in window 14 August 2026 |
|---|---|
| Posts held | 26 (6 July 2026 – 14 August 2026) |
| Views total | 21,355 |
| Reactions total | — |
| Forwards / comments | not exposed by the public surface — not measured, not estimated |
| Readings taken | 14 Aug 2026, 21:56 UTC |
Views are a single reading per post, taken at the time above. A post published in the last day or two is still accumulating views, which pulls the 30-day average down slightly. That is a property of the standard definition rather than a fault in it, so we keep the definition rather than “correcting” the number into something nobody can reproduce.
Precision. Telegram publishes view counts on its public widget in short form — 8.12K, 3.7M — so any reading at or above 1,000 reaches us rounded to three significant figures, and only counts below 1,000 are exact. Averages and rates derived from them are shown to the same precision rather than to the unit: a figure like 3,701,250 would assert digits nobody measured.
Reaction counts are published per emoji and rounded the same way, so a total below 1,000 is exact and a larger one is a sum that may carry a rounded component from each emoji above 1,000. Because it is a sum, it does not look rounded — read a large reaction total as three significant figures per contributing emoji rather than as the figure it prints.
What this channel posts
- Photos
- ≈1,200
- Videos
- ≈2
- Links
- ≈511
Lifetime counters from Telegram’s own channel header, read 14 August 2026 — not the date at the top of this page, which is when the subscriber count was last read. A count marked ≈ was rounded by Telegram before we ever saw it — t.me prints these counters in full below 1,000 and to three significant figures above, so ≈142,000 means somewhere between 141,500 and 142,499.
Recent posts
Задача При выборке из таблицы workers создайте новое поле res, в котором будет лежать произведение зарплаты и возраста. Ответ на картинке.
NULL-значения в PostgreSQL: правила и исключения Смотреть статью
#вопросы_с_собеседований Как создать временную таблицу в sql запросе? Создание временной таблицы может быть полезным в случаях, когда нужно сохранить результаты промежуточных вычислений. Для создания временной таблицы используйте ключевое слово CREATE TEMPORARY TABLE, за которым следует определение столбцов таблицы. После создания временной таблицы, вы можете выполнить операции SELECT, INSERT, UPDATE и DELETE на э…
Числовая функция ATAN Функция ATAN в SQL возвращает арктангенс числа. Арктангенс - это обратная функция тангенса, которая возвращает угол, значение тангенса которого равно заданному числу. Функция ATAN возвращает арктангенс в радианах. Синтаксис - ATAN ( numeric_expression ) numeric_expression: числовое выражение, значение арктангенса которого требуется найти.
Функция TRIM Функция TRIM используется для удаления пробелов или других символов из начала или конца строки. Она может быть полезна для очистки данных перед их использованием в запросах или отчетах. Синтаксис функции TRIM следующий: TRIM([{BOTH | LEADING | TRAILING}] [removable_characters FROM] string) 1. BOTH - удаляет символы с обоих концов строки (это значение по умолчанию). 2. LEADING - удаляет символы только…
Операция PIVOT в SQL PIVOT - это операция, которая позволяет преобразовать строки в столбцы для создания сводных таблиц. Она используется для агрегации данных и суммирования значений в соответствии с заданными критериями. Если вы работаете с диалектом SQL, который не поддерживает PIVOT, не волнуйтесь! Вы всё ещё можете достичь аналогичных результатов, используя операторы CASE.
Функция POW() Функция POW() возвращает значение числа, возведенное в степень другого числа.
#вопросы_с_собеседований Что такое AUTO_INCREMENT? AUTO_INCREMENT используется в SQL для автоматической генерации уникального номера при каждом добавлении записи в таблицу. Поскольку первичный ключ уникален для каждой записи, мы добавляем это поле в качестве AUTO_INCREMENT поля, таким образом при каждой вставке новой записи номер будет увеличиваться автоматически. По умолчанию значение AUTO-INCREMENT начинается с …
#вопросы_с_собеседований Сработает ли данный запрос? Ответ: Здесь всё очень просто. При вставке строчек в таблицу количество полей при объявлении не соответствует количеству вставляемых значений в конструкции values. Это должен знать даже начинающий SQL-разработчик.
#вопросы_с_собеседований Что не так с запросом на фото? Исправьте его, если нужно. В тексте обнаружено неверное выражение BillingYear в условии WHERE. Несмотря на то, что оно было определено как алиас в выборке SELECT перед WHERE, логический порядок обработки условий отличается. Как известно, в T-SQL операторы выполняются в другом порядке, что может привести к неожиданным результатам. Чтобы избежать подобных ошибок…
#вопросы_с_собеседований Выберите все записи, где первая буква City начинается с любой буквы от "a" до "f" Ответ на картинке.
Showing the 12 most recent of 26 posts we hold for @seniorsql. View and reaction counts are the latest single reading for each post, not a live figure, and a recent post is still accumulating both. A view count marked ≈ was rounded by Telegram before we ever saw it — t.me prints views in full below 1,000 and to three significant figures above, so ≈1,200,000 means somewhere between 1,150,000 and 1,249,999. Unmarked counts are exact. Text is reproduced from the public post preview and truncated for length.
Citation-graph rank
Citation-graph rank — 1,325,346 of 1,345,403entries in the measured graph. A weighted position computed from the forward and mention edges below — republished posts weigh more than named mentions — and recomputed periodically, over the whole graph. Published only as this ordinal position, never as a score: a position is a fact, and a score printed beside one channel’s name would read as a verdict this register does not make. The two counts beneath stay separate for the same reason mentions are never summed with forwards anywhere else on this page — a named-by count costs nothing to manufacture. The top 100 by this measure, or how it is computed.
Mentions
Named by 1 registered channel — every channel on the register whose own posts have named this one, by its current username or any other username it currently holds, merged from two separately captured readings of the same fact so a namer caught by only one of them is not missed and a namer both caught is not counted twice. A username this channel has since dropped is not matched — that handle may belong to someone else now, and crediting today’s namer to yesterday’s owner would misattribute it.
Named by
Channels on the register whose posts name this channel's handle.
A mention is a weaker signal than a forward and is counted separately for that reason — naming a channel is not republishing it, and a handle in a post body is easy to place deliberately. The post counts beside each row below are distinct posts in which the handle appeared, from posts we have read on both sides — the “Named by N registered channels” figure above is a different count, of distinct NAMING CHANNELS rather than posts, and is not the sum of the rows under it.
Cite this entry
A live page changes as we take new readings, so a citation should name the measurement it is based on, not just the URL. The line below cites the subscriber count as measured 14 August 2026 — this entry's latest reading, not the date you are reading this.
“Senior SQL Developer” (@seniorsql), 14,449 subscribers as measured 14 August 2026. Telegram Register, tgregister.com/channel/seniorsql.
Full measurement history, CC BY 4.0. Every reading this register holds for this entry, not just the latest one, as a dated, downloadable record: CSV · JSON. Free to use with attribution to tgregister.com. Each file carries its own generation timestamp, which is the figure to cite for exactly when the data was retrieved.