Siddharth Mohapatra

I have selected 1 column - flake_type and their corresponding count, whose column name is unique_count. I have used the table called snowfall_log. But the condition here is that fall_time should be 24th December, 2025 followed by grouping by the flake_type.

I just solved this easy SQL problem from @InterviewMstr. I have shared my approach in the comments below. #sql

I retrieved elf_name and used COALESCE function to replace null values in return_date column to 'Still resting'. I joined these 2 tables using LEFT JOIN on the basis of elf_id primary key followed by sorting the elf_name in ascending order.

This is my day 5 of staying in touch with solving SQL problems by @InterviewMstr . I have mentioned my approach in the comments. #Analytics

Curiosity is a requirement for greatness. You win when you keep asking new questions every day. That’s why I am proud to announce my investment in Perplexity. Perplexity is powering the world’s curiosity, and together we will inspire everyone to ask more ambitious questions. Perplexity.ai/ronaldo is just the beginning!

I retrieved all the columns from the table 'hall_decorations' sorting the energy_cost_per_hour in ascending order. Just because it was mentioned to show top 5 records so, I used LIMIT 5 to retrieve only the top 5 rows from this table.

I recently wrapped up the SQL problem for Day 4 by @InterviewMstr. I have solved my thought process in the comments. #Analytics

In this query, I tried to assign a ROW_NUMBER to each record. But, I have grouped it by target_name, but sorted it by evilness_score in descending order, created_at in ascending order. Then I am selecting those records whose rank is 1.

I recently wrapped up the Hard level SQL problem from @InterviewMstr. I have shared my approach in the comments. #Analytics

I recently solved a medium level SQL challenge by @InterviewMstr . It was a simple inner join implementation problem to retrieve only those toy_ids, toy_names which was delivered. #Analytics

In this query, we can see I tried to retrieve the name and rank from the given table, ordering by rank in ascending order. But, it has shown to display 7 rank records so I used LIMIT 7 to limit the rank from 1 to 7.

Kicking off December by leveling up my SQL skills! ❄️📊 I found this SQL Advent coding challenges perfect for strengthening problem-solving and consistency. Excited to take one challenge a day and keep improving. I have shared the problem and the query I wrote. #sql

Whereas in case of Machine Learning, it takes both input and output data as it's input and it generates a pattern or a logiv which we call it as a model. Then, we feed new inputs so that the model can predict the outputs accordingly.

Recently, I was brushing up on some ML basics from @ShradhaKhapra_ YT channel. She has explained everything in detail, which is very helpful for both students & working professionals. Here's what I got to learn: #machinelearningpython #machinelearningtutorial

There is a key difference between a tradional CS algorithm and a machine learning algorithm. In case of a CS algorithm, the program takes an input and gives an output on the basis of the input.

I just earned the "Data Modeling Day 1" badge! 🎉 Check out my achievement: dataexpert.io/badge/siddhart… #DataDriven

I've signed up for Interview Master's free SQL Advent Calendar Challenge! Join me for 24 days of SQL challenges this December! interviewmaster.ai/advent #Analytics #SQL

only the top_genre column which is 'Drama' here in this case.

As we can see the question contains 2 tables one is oscar_nominees & another is nominee_information. I started joining the two tables and grouped by the genres with their corresponding winners counts. Then, I kept that table in a temporary table using CTE followed by choosing

platform.stratascratch.com/coding/10171-f… I recently tried solving 1 hard level SQL problem asked in @netflix from Stratascratch. I have shared my approach in the comments. #Analytics