Session 35 - Subqueries in SQL | DSMP 2023

sir task ke solution de do pls

hello sir yr Ye Query SQL server par run nhi ho rahi hai? kya krneka iskeliye

-- find all movies of all those actors whose filmography
-- avg rating> 8.5( take 25000 votes as cutoff)

select * from movies where star in(
select star from movies
where votes>25000
group by star having avg(score)>8.5);

this code is not running
Error Code: 2013. Lost connection to MySQL server during query
why is it happening

Can you please share the CTE lecture link.

sir sql workbench kaise run kare

Good job bro, really helpful. Come up with more. Keep growing! You deserve even more than this.

Brain hai ya computer sir ap ka 😅

hello frds ,when am uploading data not all rows present in it, plz help me

Best lecture on subqueries.

corelated subquery k jo pehla ques hai wo iss tarah se v solve ho skta kya.....
select * from movies
where genre in (select genre from movies
group by genre
having score > avg(score));

haa ye insependent subquery se banaye hai... lekin result same de rha..
pls reply..

select name,(gross-budget) as profit from movies
where profit =(select max(gross-budget) from movies);

why it saying unknown com profit even i mentioned it

This man deserves 👑

I cant find the cte lecture from your playlist..Did you upload it?

sir stored procedure in sql pada do pls or in case if you already have a video on that then pls advise

🔥🔥

I can't load the dataset 😮

If you cant load the dataset, here is what you need to do:

Upload to Excel's power query > clean it(if you want more cleaning)
> Load it to the sheet
> Save as "utf-8 CSV file"

Done, you can now upload into your MySql

can anyone please provide the solutions of practice questions ?

Sir ke cte ka lecture he kya kisi ke pass

Join and subquries main kasy pata karen gy ky join lagain yah sub queries

Upload to Excel's power query > clean it(if you want more cleaning)
> Load it to the sheet
> Save as "utf-8 CSV file"

DROP TABLE IF EXISTS MOVIES;
CREATE TABLE IF NOT EXISTS MOVIES
( NAME VARCHAR,
RATING VARCHAR,
GENRE VARCHAR,
YEAR INT,
RELEASED VARCHAR,
SCORE DECIMAL,
VOTES INT,
DIRECTOR VARCHAR,
WRITER VARCHAR,
STAR VARCHAR,
COUNTRY VARCHAR,
BUDGET INT,
GROSS BIGINT,
COMPANY VARCHAR,
RUNTIME INT
);

SELECT * FROM MOVIES;

Thank you Bhai ..so much for helping 🙂😍😍😍

if anyone have task solutions please share it 😍

kisi ka delete statement mein error aaya that's like 'Error Code: 1093. You can't specify target table 'users' for update in FROM clause'

Where are the other sessions?

Very well oriented lecture. Amongst the best lectures available on YT in particular to SQL subqueries.
Very nicely oriented pedagogy to deliver lecture of such high quality.
A lot of thanks Nitish sir, for this amazing video. Couldn't have found a better person to explain these concepts in such a easiest way.

While using delete statement its showing error code that you can't specify Target table users for update using from clause

where do i get zomato data set for row subquery example discussed here

Claps for those who have sincerely watched till end & understood all concepts clearly!! It was really challenging & bit difficult session but well explained

In first question can we write query in this way.

SELECT * FROM MOVIES WHERE SCORE=MAX(SCORE);

In question 4 can we write like this way


SELECT * FROM MOVIES WHERE RATTING=(SELECT MAX(RATTING) FROM MOVIES) AND VITE>(SELECT AVG(VOTE ) FROM MOVIE'S)

select name from (select name,year,(gross-budget) as profit ,row_number() over( partition by year order by profit desc ) as rank from Movies)as temp where temp.rank=1;.to get highest earning movie of each year.

Last question of DELETE in subquery is giving me an error. Why?