Investments in 2016 | Leetcode 585 | Crack SQL Interviews in 50 Qs #mysql #leetcode

Want to crack SQL interviews? Check out our latest video!!!

A 50-questions SQL study plan to ace any interview.
This tutorial will walk you through the solution in easy steps. This is an easy-level question from Leetcode.

Consistency is what transforms average into excellence.
So be consistent & keep Coding💻!!

Timecodes
0:00 - Introduction
0:27 - Question Explanation
2:19 - Understanding Concept with the help of Example
4:03- Writing SQL Query
7:12 - Explanation of SQL Query
8:00 - Outro

Connect With Me -

#coding
#leetcode
#mysql
#sql
#interview
#sqlinterview
#sqlinterviewquestionsandanswers
#sql_server
#learnwithchirag
#investement

[learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on

Instagram Handles :-



Let's stay connected and keep the creativity flowing! 💡

[Sparzzzzzzzzzzz]

bhai you explain so well. to the point. love this

[nilamaniswain]

Hi Bro best content Ever. So much thing to learn from u. U r pro in SQL

[ShivamGupta-ioen]

Your channel is really under rated, I just subscribed your channel to get more such insights,
Specially the way you explain.

Thanks

[krsnabnsl]

Hi @chirag, I write the query but only 3 test cases are passed
with unique_location as (
select pid, concat(lat, ', ', lon) as location, count(1) as cnt
from Insurance
group by location
having cnt=1
)

, cte as (
select i.pid as pid, sum(tiv_2016) final_sum, count(1) as cnt
from Insurance i join unique_location ul on i.pid = ul.pid
group by tiv_2015
having cnt>1
)

select round(sum(final_sum), 2) as tiv_2016 from cte

I'm not able to find what is the problem there

[saiteja-gbho]

@Learn With Chirag bhai tu toh jalwah jai jalwahh .Keep rocking bro . Your way of explanation is very simple . Thanks for your useful content.