Forem: Aditya Nikhil

This SQL solution is GENIUS!!🤩

Aditya Nikhil — Fri, 07 Oct 2022 08:06:31 +0000

I recently started off solving SQL problems on Leetcode and I come across atleast one problem every day whose solutions I think are pure genius.

It's one such problem I came across today which I'll discuss below,

Databases (608. Tree Node)

Problem statement
We need to find the type of each node in a tree. Whether it's a root, inner or a leaf node.

Input: 
Tree table:
+----+------+
| id | p_id |
+----+------+
| 1  | null |
| 2  | 1    |
| 3  | 1    |
| 4  | 2    |
| 5  | 2    |
+----+------+
Output: 
+----+-------+
| id | type  |
+----+-------+
| 1  | Root  |
| 2  | Inner |
| 3  | Leaf  |
| 4  | Leaf  |
| 5  | Leaf  |
+----+-------+

Checkout the description thoroughly from the link above and try get an idea of solving it before checking out below approaches

1. My approach

I solved it using CASE.
I don't want to go into nitty gritty details of it but here's an overview,
1.1 If p_id is null, then it's a Root node.
1.2 If id is in p_id, then it's an Inner node.
1.3 Else, it's a Leaf node.

2. Genius approach (Atleast I think)

Using If function

Here's the code,

SELECT
    atree.id,
    IF(ISNULL(atree.p_id),
        'Root',
        IF(atree.id IN (SELECT p_id FROM tree), 'Inner','Leaf')) Type
FROM
    tree atree
ORDER BY atree.id

Let's break it down,

Sets atree as an Alias to our Tree table.
Selects id from the Tree table.

Here's what's interesting!!!!
3.Creates an If function

General usage of If function 👇

`If(10>27, YES, NO)` 
It states that if condition `10>27` is true then **YES** else **NO**.

Now,
IF(ISNULL(atree.p_id),'Root'
states that,
if p_id is null, then set it as Root.
(And just like that our condition from 1.1 was satisfied)
4.Yet another If function embedded inside the first If function as an Else condition,
IF(atree.id IN (SELECT p_id FROM tree), 'Inner','Leaf')
This states that,
If id is in p_id set it as 'Inner' else as 'Leaf'.

(And just like that our conditions 1.2, 1.3 were satsified🤩)

The genius behind this solution is designing it by utilizing of simple functions ordered in a perfect way.
As complex as it may seem, as simple it is I believe.

If you made it till here, let me know what you think of this and also mention down in the comments if there are any more problems/solutions you find interesting.

Stay consistent with learning ML

Aditya Nikhil — Fri, 26 Nov 2021 15:07:18 +0000

Machine learning has created such a massive hype over the past decade that no other technology has ever created.

Well I can clearly anticipate that, AI's definitely here to stay for a little bit longer than we thought. Now as the field is growing, competition's growing too.

No matter what the background of the individual, everybody's ready to learn ML. And I think, it's a good thing UNLESS the individual starts feeling intimidated and afraid tending to leave the course mid way. There are several reasons causing this to happen, which is quite common and it did happened to me too, resulting in constant procrastination.

So here are few things which helped me to stay consistent and motivated with learning ML,

1. What's your motivation?

4 years ago before I started my undergraduate studies, I was constantly trying out new things like programming, game development and of course web dev too. The issue was, I never could keep myself stick with one thing at a time. My mind was always, revolving around new things.

Until, Sophia the robot was released. I was so fascinated seeing a robot behave like a human. I heard the term Artificial Intelligence for the first time and the term itself was so intriguing that I couldn't resist myself learning it.
Though there were not many courses back then unlike now except for Andrew NG's, that didn't stop me from learning it.

I might not be near to building a robot as powerful as Sophia but I do believe I could one day. That's my motivation and still keeps me going to learn more and to build more.

So ask yourself, What's your motivation to learn ML?

2. Ask questions

I used to be very shy at asking doubts even at the forums. 😅

I used to feel, people might think that my doubt is too lame or very generic or silly. But that's all in my mind(overthinking).
Trust me, people are too busy thinking about themselves.

Hence, you stop learning and hanging with your unsolved doubt and never moving forward.
Here are few forums where I think you can post your doubts, no matter how silly you think they are but people are kind enough to answer them for you,

https://community.wandb.ai/
https://datascience.stackexchange.com/
- Make sure to check if your question's been previously answered by someone else before you post here.
https://www.kaggle.com/discussion

3. Reward yourself with a project

Okay, you learnt a new algorithm but now what? It's time to implement it.

Implementing an algorithm is more fun after learning it. It's not just the algorithm but utilizing it to perform a certain task. Why is it fun?
Because, that's what you learnt it for, right?
You're now fully able to implement any algorithm you learnt to perform a given task.
It does feel more rewarding than you think it is. ✨
Do participate in hackathons or OSS(open Source Software) programs to put your ability to test. Here are a few hackathons and OSS programs which definitely you should try,
For starters,

GSSoC
GWoC
SWoC
MLH
GSoC
Above listed are some of the OSS programs which definitely you should participate in. You'll end up learning A LOT!
Machine Hack
Kaggle
Analytics Vidhya
Above are some communities which conduct hackathons quite frequently. There's always discussion groups associated with these hackathons, feel free to ask questions.

Keep finding and working on unique projects and publish them, which we're going to discuss next!

4. Learn in public 🔥

Like I said, I am a very shy person and this task feels daunting too. 😂(But don't worry, it isn't.)

No matter how big or small your work is, do talk about it. Do share it. By this I don't mean it in a way like sharing memes over instagram. NO!
Do post about your work on community platforms like Medium, WandB, Dev.

About your post, make sure it fits in any of these categories,

Winning hackathon solution to an ML problem
A concise implementation of something
A new technology which you found useful
A new research you like to talk about
And finally, tips/techniques that helped you to help the community. (Just like this one😉)

Doing this, it makes you an active member in the community and opens door for numerous opportunities. 🤩🤩

Conclusion

Hence, these are few things which helped me stay consistent with whatever I do. Hope they help you too. Please feel free to share your thoughts in the comments down below, I'd love to hear them.

Above all,

Dont rush, take it one step at a time😉

You can connect with me here,

How to get rid of Overwhelming

Aditya Nikhil — Sat, 26 Sep 2020 15:24:35 +0000

I really need some support and motivation to move forward, it's so intimidating and daunting looking at the amount of participation and everything. Am hoping someone to shed some light to help me move forward.
Also I am all into AI and data science, and I cannot find much projects related to these areas where I can help. Everything's all about NodeJS, or databases and stuff. I kind of feel like am no use here.