Don't forget to congratulate X!

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)

Qlik Sense - Level-ups 2021 - November 27, 2021.png

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

Qlik Sense - Level-ups 2020 - November 27, 2021.png

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!