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 Hive account@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)

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-up this week (21st-27th Nov. 2021)

• Congratulations on becoming a Minnow: Hive account@m3ss, Hive account@ratna9864, Hive account@abrahan414, Hive account@kerwinjz, Hive account@raj808, Hive account@esther-emmanuel, Hive account@dimascastillo90, Hive account@ismaelgranados, Hive account@thegoodbi, Hive account@tawadak24, Hive account@charcoalbuffet, Hive account@danielcarrerag, Hive account@stytchh, Hive account@erilej, Hive account@soychalbed, Hive account@critic-on, Hive account@nateonsteemit, Hive account@zenai, Hive account@mama-mimosa, Hive account@monycatt, Hive account@numpypython, Hive account@ying82, Hive account@coinnexus, Hive account@vickyli, Hive account@gvkanten, Hive account@asmaniasmu, Hive account@hrissm, Hive account@andryscarias01, Hive account@familia.linares, Hive account@blockheadgames, Hive account@reiseamateur
• Congratulations on becoming a Dolphin: Hive account@nbs.gmbh, Hive account@fotostef, Hive account@fatimajunio, Hive account@xabi, Hive account@namelessnameless, Hive account@sanjeev021, Hive account@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!