A couple of days ago I leveled up and became a Minnow! I shared in one of my posts, but something that caught my attention was that not a lot of people were sharing their tips and tricks on how to level up on hive while creating a post on their achievement. I started questioning myself whether there were many of us leveling up on a daily basis.
I went to @hivesql - of course, like always - and retrieved the info for myself to get to know about it. I actually found out that 141 hive accounts have leveled up so far during Novemeber 2021, and the month it is yet not over! I thought that it might be fun to generate some statistics on this over the past year.
Level-ups Novemeber 2021 (until 27th)
| level | total |
|---|---|
| Minnow | 111 |
| Dolphin | 26 |
| Orca | 4 |
This year so far there hasn't been any Whale level-ups - I am hoping to see some before the year ends!
Level-ups 2021 (so far)
Some numbers:
| Level | Januray | February | March | April | May | June | July | August | September | October | November |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Minnow | 104 | 135 | 128 | 124 | 116 | 137 | 150 | 124 | 119 | 117 | 111 |
| Dolphin | 26 | 53 | 41 | 33 | 22 | 32 | 43 | 27 | 25 | 24 | 26 |
| Orca | 1 | 3 | 3 | 5 | 3 | 4 | 3 | 7 | 5 | 5 | 4 |
| Level | Total |
|---|---|
| Minnow | 1365 |
| Dolphin | 352 |
| Orca | 43 |
Level-up this week (21st-27th Nov. 2021)
- Congratulations on becoming a Minnow: @m3ss, @ratna9864, @abrahan414, @kerwinjz, @raj808, @esther-emmanuel, @dimascastillo90, @ismaelgranados, @thegoodbi, @tawadak24, @charcoalbuffet, @danielcarrerag, @stytchh, @erilej, @soychalbed, @critic-on, @nateonsteemit, @zenai, @mama-mimosa, @monycatt, @numpypython, @ying82, @coinnexus, @vickyli, @gvkanten, @asmaniasmu, @hrissm, @andryscarias01, @familia.linares, @blockheadgames, @reiseamateur
- Congratulations on becoming a Dolphin: @nbs.gmbh, @fotostef, @fatimajunio, @xabi, @namelessnameless, @sanjeev021, @brian.rrr
Level-ups 2020
How to
As always, if you wish to explore the data in more depth, you can do it executing the following queries:
Total amount of level-ups by category during 2021
SELECT COUNT(account) as total, level FROM (SELECT account,
CASE
WHEN levelId like 'M' THEN SUBSTRING(body, 179+3*LEN(account), 6)
WHEN levelId like 'D' THEN SUBSTRING(body, 179+3*LEN(account), 7)
WHEN levelId like '*' THEN SUBSTRING(body, 180+3*LEN(account), 4)
WHEN levelId like 'W' THEN SUBSTRING(body, 179+3*LEN(account), 5)
END AS level,
YEAR([created]) AS levelYear,
MONTH([created]) AS levelMonth,
DAY([created]) AS levelDay
FROM (SELECT [parent_author] AS account,
[body],
LEFT(SUBSTRING([body], 179+3*LEN([parent_author]), LEN([body])),1) as levelId,
[created]
FROM [DBHive].[dbo].[Comments]
WHERE [author] LIKE 'hivebuzz' AND body LIKE '%Congratulations%You raised your level and are now %' AND YEAR([created]) LIKE 2021) idTable) levelTable
GROUP BY level
Total amount of level-ups during November
SELECT account,
CASE
WHEN levelId like 'M' THEN SUBSTRING(body, 179+3*LEN(account), 6)
WHEN levelId like 'D' THEN SUBSTRING(body, 179+3*LEN(account), 7)
WHEN levelId like '*' THEN SUBSTRING(body, 180+3*LEN(account), 4)
WHEN levelId like 'W' THEN SUBSTRING(body, 179+3*LEN(account), 5)
END AS level
FROM
(SELECT [parent_author] AS account,
[body],
LEFT(SUBSTRING([body], 179+3*LEN([parent_author]), LEN([body])),1) as levelId,
[created]
FROM [DBHive].[dbo].[Comments]
WHERE [author] LIKE 'hivebuzz' AND body LIKE '%Congratulations%You raised your level and are now %' AND YEAR([created]) LIKE 2021 AND MONTH([created]) LIKE 11) idTable
Hopefully you get the idea! You can pretty much just play with those two queries to retrieve anything relevant reegarding level-ups!
Hope you enjoyed this post you can let me know which other queries you would like to see in the future!