First of all thank you so much sir for this interview series , You are literally giving a lot to the community. I wanted to ask how to figure out in every question that it could be done through joins, subquery, clauses. Basically how to strike our mind that this is problem of subquery or joins etc.

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

what if we dont use the min function in the subquery. isnt just select player_id, event_date enough?

select case when income < 20000 then "Low Salary" when income between 20000 and 50000 then "Average Salary" when income > 50000 then "High Salary" end as category,count(*) as accounts_count from Accounts group by category; but the problem is how to put 0 for average salary. please reply sir

Leetcode 😃😄

bhaai css me ghabraa gayaa 😐

1:52:00 in this solution DISTINCT is redundant. why ? (contest_id, user_id) is the primary key and final answer is grouped by (contest_id) . after LEFT JOIN's ON condtion each of the group is going to have distinct user_id. there cannot be two (208, 5) 1:57:30 SELECT query_name, ROUND(AVG(rating/position),2) AS quality, ROUND(SUM(rating<3)*100/COUNT(*),2) AS poor_query_percentage FROM Queries q GROUP BY query_name HAVING query_name IS NOT NULL

1:40:25 A point worth considering while performing SUM() on column containing some or all values as NULL is : # SUM() function ignores NULL values when calculating the sum of a set of values # SUM(null) returns NULL # null/null returns NULL DEMO : mysql> select * from num; +----+------+ | id | val | +----+------+ | 1 | NULL | | 4 | NULL | +----+------+ 2 rows in set (0.00 sec) mysql> select SUM(val) from num; +----------+ | SUM(val) | +----------+ | NULL | +----------+ 1 row in set (0.00 sec) mysql> select SUM(val)/SUM(val) from num; +-------------------+ | SUM(val)/SUM(val) | +-------------------+ | NULL | +-------------------+ 1 row in set (0.00 sec) After inserting a valid number : mysql> select * from num; +----+------+ | id | val | +----+------+ | 1 | NULL | | 2 | 3 | | 4 | NULL | +----+------+ 3 rows in set (0.00 sec) mysql> select SUM(val) from num; +----------+ | SUM(val) | +----------+ | 3 | +----------+ 1 row in set (0.00 sec)

you have a great solution, but decided to explain only to people who can understand hindi.

bhai agar solutin hi dekhna hota to chat gpt kar leta main

58:40 For question like these always start as shown below TO GET THE FEELING OF WHAT IS GOING UNDER THE HOOD : ``` SELECT * # l.machine_id as machine_id, # ROUND(( SUM(r.timestamp-l.timestamp) / COUNT(DISTINCT(l.process_id)) ), 3) as processing_time FROM Activity l JOIN Activity r ON l.machine_id = r.machine_id AND l.process_id = r.process_id AND l.timestamp < r.timestamp #GROUP BY l.machine_id ```

bhai ye SQL ki query ka syntax kitna hard h ye interval vala new syntax aa gya

Hi I got selected in carelon's for "associate software engineer" role in February 2024, they made me wait till September telling we will onboard soon. But after these 8 months, i got a mail today saying that onboarding is deferred to next year due to some reasons. How is this acceptable? Can you please help me with this. Can I do something to Join work soon? I had created workplace account. I was waiting for offer letter. Waiting for your response. Thank you

🤨🤨🤨🤨🤨🤨🤨🤨

cant believe showing only 224 likes.... should be 2M likes

This is also working is JOIN instead of CROSS JOIN. What the difference between them?

Let's say we have one more salary 400 here, so in e1 salary 300 will be less than e2 salary 400. And if we take max of e1 salary it will be 300 not 200. So how can we solve this using method that you've used in the video

thanks

nice

Came here for "Just enough information for the solution". Stayed and subbed for the EPIC explanation! Thank you :0

Amazing Bhai , your expalnation is AWESOME

not clear transction count

can you upload bigfrontend dev js questions??

Great Explanation I finally understood aggregate function for confirmation_rate

This is impressive stuff, NGL

please explain what is does in function

Top class bro

Hi chirag, I am passed out of 2024 from KL University And I too selected for the carelon global solutions as an associate software engineer But till now I recieved only an LOI around in the month of May and I have been waiting for offer letter May I know How many days did u taken to recieve the offer letter and can you please help me out with the above problem Waiting for your reply Thank you

what is ids r nt consecutive.. wt will be the query ?

amazing

Thanks sir

Sir make one shot on sql in depth

select max(num) as num from MyNumbers where (num) IN (select num from MyNumbers group by num having count(num) = 1) group by num maine ye likha tha ... Maloom nahi kyuu nahi chal raha hai ye

TLE mar gya ye to

Second Highest Salary: with Sub query SELECT (SELECT DISTINCT salary FROM Employee ORDER BY salary DESC LIMIT 1 OFFSET 1) AS SecondHighestSalary;

can we use between clause into this ?

sir mujhe ye function compostions mai doubt hai clear samjh mai nhi aya

Sir, the syntax you are using is for MYSQL or POSTGRESQL?

Bhai kaam chahiye

# Write your MySQL query statement below SELECT product_id, MIN(year) AS first_year, quantity, price FROM Sales GROUP BY product_id what is the problem with this solution?

people dont know how underrated this guy is...... you deserve a lot bro

*Immediate Food Delivery* Why am I getting an error when I use AVG() function in the query? SELECT ROUND(AVG(IF(MIN(order_date) = customer_pref_delivery_date, 1, 0)),2) immediate_percentage FROM Delivery WHERE (customer_id, order_date) IN (SELECT customer_id, MIN(order_date) first_order_date FROM Delivery GROUP BY customer_id)

*Queries Quality and Percentage* In question 19, all test cases are passing with your solution but one is failing which has NULL values in the query_name column. To pass all test cases: SELECT query_name,ROUND(AVG(rating/position),2) quality, ROUND(AVG(IF(rating <3, 1,0)*100),2) poor_query_percentage FROM Queries WHERE query_name IS NOT NULL GROUP BY query_name;

Great explanation! I was trying a new approach and came across this query, the runtime of 197ms, beating 87.71% SELECT a1.machine_id, ROUND(AVG(a2.timestamp - a1.timestamp), 3) AS processing_time FROM Activity a1 JOIN Activity a2 ON a1.machine_id = a2.machine_id AND a1.process_id = a2.process_id AND a1.activity_type = 'start' AND a2.activity_type = 'end' GROUP BY a1.machine_id;

Very Well Explained

🥲omg it was so easy why i did not think in this way i have written such long query 😓 I still need lot of practice 😓

Bhai agar aap Striver ki DSA A2Z sheet pe Bna sakte ho , RU-vid pe Javascript DSA hai nhi ache se

Bhai yaar best series itna depth me kisi ne nhi karayi ye JS series on RU-vid hats off bro 👍👍

if we are using group by then it will count the number of user_id in each group right ? no need of distinct worked for me without it

@Learn With Chirag why this problem cant be solved using self join plz answer