23 Live SQL Practice Session 7 Sep 2025

RAKESH KUMAR

Hi, this video will help you to SQL interview preparation.   Whatsapp Group Link- https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt   SQL Script file : -  https://drive.google.com/file/d/14s0ZwRN8t65a08Sjn1wJ5VBz8YfVhr5P/view?usp=sharing

Transcript

00:00:00So, recording start

00:00:05Let's create database

00:00:08Create database

00:00:11September 7

00:00:17Use September 7

00:00:23Use

00:00:25To find out

00:00:28We are seen

00:00:29While we are throwing

00:00:30We make the database

00:00:32They are taking out

00:00:35There is a database

00:00:37This is also a database

00:00:40We had done a database

00:00:43The database

00:00:44We are making this database

00:00:46We have created it

00:00:47This database

00:00:49It was a database

00:00:51Live

00:00:52In the transaction control, you can select the transaction control.

00:01:06Select Start from Call You Sealed.

00:01:19Okay.

00:01:49I want to know how much the transaction is going to be done.

00:01:56Select.

00:01:57What do you think about it?

00:02:04Select.

00:02:05What do we do?

00:02:07First we want to value month-wise.

00:02:10Select.

00:02:15Select.

00:02:18What transaction do you want to make?

00:02:25Transaction.

00:02:30Date.

00:02:35What transaction do you want to make?

00:02:48Okay.

00:02:49And then we need to make it.

00:02:58Month.

00:02:59Okay.

00:03:00Month.

00:03:01Okay.

00:03:02Okay sir.

00:03:03Join.

00:03:04Join.

00:03:05Join.

00:03:06Join.

00:03:07Join.

00:03:08Join.

00:03:10Join.

00:03:11Join.

00:03:12Join.

00:03:13Join.

00:03:14Policy.

00:03:15Yeah.

00:03:16Sir.

00:03:17On.

00:03:18On.

00:03:19On.

00:03:20On.

00:03:21On.

00:03:22On.

00:03:23On.

00:03:24On.

00:03:25On.

00:03:26On.

00:03:27On.

00:03:28On.

00:03:29On.

00:03:30On.

00:03:31On.

00:03:32On.

00:03:33On.

00:03:34On.

00:03:35On.

00:03:36On.

00:03:37equal to policy ID

00:03:39after this amount of data

00:03:42amount

00:03:43sum

00:03:45sum

00:03:46sum

00:03:49sum

00:03:50sum

00:03:53sum

00:03:55sum

00:03:58sum

00:04:00sum

00:04:01sum

00:04:03sum

00:04:05sum

00:04:06There are many, there are many.

00:04:08Where are my mom?

00:04:09Where are my mom, check?

00:04:11There are many, here.

00:04:13Right?

00:04:14Right?

00:04:15Sir, once.

00:04:18Why are you here?

00:04:21One situation is less than me.

00:04:24OK.

00:04:27OK, sir.

00:04:29Order by.

00:04:30It's different a year.

00:04:31Yes, I will.

00:04:33These things have come to us.

00:04:35We will use the previous month, sir.

00:04:39We will use the city to use it.

00:04:42With the city as a reference number,

00:04:46we will have to put it in place.

00:04:50We will put it in place.

00:04:53We will put it in place.

00:04:56We will put it in place.

00:05:00We will put it in place.

00:05:04I will put it in place.

00:05:06Similarly, we will put it in place.

00:05:12And then there will be one to one.

00:05:19So, we have to put it in place.

00:05:31We have to check the order by month.

00:05:56we will check

00:06:01it's over

00:06:03Ashar

00:06:05I will

00:06:07I will make this CT

00:06:09or I will give it

00:06:11I will give it

00:06:13CT please

00:06:15CT

00:06:17I will make CT

00:06:19for this CT

00:06:21I will give it

00:06:23and here CT

00:06:25I will start from CTU

00:06:32I will start from CTU

00:06:40It will be a bit easy to write

00:06:45I will start from CTU

00:06:48Now I will start from CTU

00:06:53I don't know.

00:06:54Okay, that's okay.

00:06:55I'm going to go right here.

00:06:56Now, let's go ahead and put it in the middle.

00:06:58We were divided here.

00:07:00PRM amount.

00:07:03PRM amount.

00:07:06PRM amount.

00:07:07Minus.

00:07:08Minus.

00:07:10Last month amount.

00:07:13PRM amount.

00:07:18PRM amount.

00:07:20PRM amount.

00:07:21PRM amount.

00:07:24PRM amount.

00:07:26PRM amount.

00:07:29PRM amount.

00:07:31PRM amount.

00:07:34Oh, really?

00:07:35You can do that?

00:07:37Okay, that's the last month.

00:07:40PRM amount.

00:07:42PRM amount.

00:07:44PRM amount.

00:07:46PRM amount.

00:07:48PRM amount.

00:07:50Now I will do something else.

00:07:57I will write here.

00:08:00We are in.

00:08:03We are in.

00:08:06In two hundred.

00:08:08Your idea was last month.

00:08:13We are in.

00:08:16This morning we are.

00:08:19We are in.

00:08:21Not the idea of life.

00:08:26Last month.

00:08:31We are.

00:08:35We are.

00:08:41We are in.

00:08:48I will write here.

00:08:51I will write here.

00:08:52Okay.

00:08:54Okay.

00:08:56I will do something.

00:09:10I will write around.

00:09:15It's better.

00:09:20PRM to get to come, where is it?

00:09:23I say.

00:09:26Oh, yeah, what is it?

00:09:27I say, you know, pull it.

00:09:30Yes sir.

00:09:31Oh, yeah.

00:09:33I'm thinking.

00:09:36I've been doing it right now.

00:09:38Okay, sorry.

00:09:39This measure, one, multiply.

00:09:41Okay, one, and double zero, and then,

00:09:44We can get this one.

00:09:50No sir, we have to go there, we have to go there, we have to go there, we have to go there.

00:10:10But we have to go there, we have to go there, we have to go there, we have to go there.

00:10:17Last call has been a star, because we have to go there.

00:10:29This is the one you have to go there.

00:10:36Now, this is the one you have to go there.

00:10:41In 100.

00:10:43Or, this is the one you have to go there.

00:10:50You have to go there, you have to go there.

00:10:53Yes, you can do it.

00:10:56Yes, you have to go there.

00:11:01So, this value is increasing.

00:11:03How is it?

00:11:05We are showing so many 0s, so we have two values.

00:11:11Okay, you have to keep it here, you have to keep it here.

00:11:16Here is 200.

00:11:19Now, that is okay.

00:11:22I am showing additional 0s.

00:11:25Yes, I am showing additional 0s.

00:11:28So, if we have to try and cast it.

00:11:32Then, we will cast it.

00:11:36The cast was a convert.

00:11:38I will cast it.

00:11:42I will cast it.

00:11:44The cast is a convert.

00:11:51It is an old I.

00:11:53I have one.

00:11:58I can.

00:12:03I can.

00:12:04I can.

00:12:06High point.

00:12:13Ha ha, ho gaya.

00:12:16Ha na?

00:12:18Ho gaya.

00:12:20Ho gaya.

00:12:22Or null ko kardeta hoon.

00:12:24Zero?

00:12:26Hmm.

00:12:28It's null.

00:12:32Goma.

00:12:34Zero.

00:12:35Zero.

00:12:37Zero.

00:12:39Zero.

00:12:41Yes sir.

00:12:43What's it?

00:12:45Now minus or plus?

00:12:47It's not happening.

00:12:49Understanding?

00:12:53Yes sir.

00:12:57yes, yes sir, plus minus k ne da, plus minus k ne da.

00:13:02plus k ne da a k da a k a k k a k a k i n a k dh k a k a k a k a a a k a k a k .

00:13:10ar last wale me k k dh growth hoi hai lekin 6.14 t hara j e b wat ha r hai k hi negatitié

00:13:18Select DRM amount into 108 score.

00:13:31I say, divided by last month DRM FGD economics.

00:13:46I say, divided by last month DRM FGD economics.

00:14:14I say, divided by last month DRM FGD economics.

00:14:26I say, divided by last month DRM FGD economics.

00:15:02Minus one is about here of our hand, so zero, zero.

00:15:32Minus one is about here of our hand.

00:15:38Minus one is about here of our hand.

00:15:41And this one is about here of our hand.

00:15:45That's it.

00:16:02I'm not going to be able to do this.

00:16:09I'm not going to be able to do this.

00:16:14I'm not going to be able to do this.

00:16:21I'm not going to be able to do this.

00:16:36I'm not going to be able to do this.

00:16:41I'm not going to be able to do this.

00:16:47Now we'll put round.

00:16:50I'm ready to start.

00:17:02I'm not going to be able to do this.

00:17:08I'm not going to be able to do this.

00:17:13I'm not going to be able to do it.

00:17:23I'm not going to be able to do it.

00:17:26I'm not going to be able to do it.

00:17:32I can see this.

00:17:35I can see this.

00:17:38Did you put it on the left?

00:17:39Yes, it was.

00:17:41I put it on the left.

00:17:46I put it on the left.

00:17:49Yes, I put it on the left.

00:17:51But why did it go out of the left?

00:17:53It also went out of the right.

00:17:55I can see.

00:17:57It's gone.

00:17:59It's gone.

00:18:01This is cool here.

00:18:03This is how we turn around and we turn around.

00:18:07Nice.

00:18:11You've got one bracket extra?

00:18:13Yeah, extra.

00:18:15Okay.

00:18:17Okay.

00:18:19A.

00:18:21Okay.

00:18:23Okay.

00:18:25Okay.

00:18:27Okay.

00:18:29Take care.

00:18:31I am.

00:18:33Just a minute.

00:18:35Maybe I am.

00:18:37Thanks.

00:18:57I am.

00:18:59Yeah.

00:19:03Yeah.

00:19:05Yeah.

00:19:07Yeah.

00:19:11Yeah, it's a.

00:19:21So.

00:19:23We have started with brackets.

00:19:27Now, as-u1

00:19:53What's up, please?

00:20:23What do you want to do with this?

00:20:34We want to add a percentage of the percentage.

00:20:41Right?

00:20:43Yes sir.

00:20:45What do you want to do with this?

00:20:47We want to add a percentage of the percentage.

00:21:02Then, it will be a percentage of the percentage.

00:21:07Then it will then be a percentage of the percentage.

00:21:11No convert.

00:21:13Direct we don't have to put it in, then there will be an error.

00:21:19Format function.

00:21:25Format function.

00:21:29Format function.

00:21:33Okay.

00:21:35Format, I say,

00:21:47comma, 0.00%

00:21:55I say not.

00:21:59Yes, I will.

00:22:01Yes, it's gone.

00:22:07But it's gone.

00:22:09The percentage is more.

00:22:11We have to keep N200.

00:22:15It's gone.

00:22:25It's gone.

00:22:27It's finally gone.

00:22:29I think...

00:22:31So, that's my decimal value.

00:22:33I have to change it.

00:22:35I have a change.

00:22:37I have to change it.

00:22:39For example...

00:22:41We have a change.

00:22:43There is something there.

00:22:45All right.

00:22:47So, we have to change it.

00:22:49I have to change it.

00:22:51And I have to change it.

00:22:53I have to change it...

00:22:55No.

00:23:27The voice is not a good one.

00:23:55If the voice is less, I will change the voice.

00:24:07Now I will check the format.

00:34:03There is no one thing, sir, what we have done, sir, on the top of the city, join the city.

00:34:13Okay, let's go.

00:34:14The city is also in all, so do it.

00:34:20Order by month, t.ct1.

00:34:32No, no, sir, this is a column.

00:34:38We have taken the name, right?

00:34:41Name?

00:34:43This is a column.

00:34:46This is a column.

00:34:48If we have come to the city, then it will be a column.

00:34:53Select the star of our city.

00:34:57This is a column, right?

00:35:02It's good, it's good.

00:35:03The date will not come here.

00:35:05The date will not come, right?

00:35:06Yes, that's what we have done.

00:35:09The date will not come here.

00:35:11Then, what will you take here?

00:35:15It will come here.

00:35:18We will check this.

00:35:20The date will not come here.

00:35:21We have taken it here.

00:35:22We've taken it and have copied it.

00:35:25The date will come here.

00:35:27It will come here.

00:35:30Yes, the bracket will come.

00:35:33Let's go here.

00:35:35The date will also be set.

00:35:37Oh, okay. I'm gonna go to order by.

00:35:41Last one.

00:36:00Order by, sir.

00:36:02Take that, take that.

00:36:04Take that.

00:36:06Take that.

00:36:08Take that, take that.

00:36:38Take that.

00:37:08Take that.

00:37:10Take that.

00:37:14Take that.

00:37:20Take that.

00:37:22Take that.

00:37:26Take that.

00:37:30Take that.

00:37:32Take that.

00:37:40Take that.

00:37:42Take that.

00:37:44Take that.

00:37:48Take that.

00:37:54Take that.

00:37:56Take that.

00:37:58Take that.

00:38:08Take that.

00:38:10Take that.

00:38:12Take that.

00:38:14Take that.

00:38:18Take that.

00:38:20Take that.

00:38:22Take that.

00:38:24Take that.

00:38:26Take that.

00:38:28Take that.

00:38:30Take that.

00:38:32Take that.

00:38:34Take that.

00:38:36Take that.

00:38:38Take that.

00:38:40Take that.

00:38:42I can't say that.

00:38:44I don't know.

00:38:46I don't know.

00:38:48In order, brother, take a direct date.

00:38:50We've got an order.

00:38:52It's the right.

00:38:54Right, sir.

00:38:56Here, it's the right.

00:38:58You're not going to be here.

00:39:00You're not going to be here.

00:39:02Sir, give two orders.

00:39:06Sir, give two orders.

00:39:10Hmm?

00:39:12What do you think?

00:39:22Okay, now we have to go to school.

00:39:29School is right.

00:39:42Cut this Now

00:39:45Billy

00:39:49You guys already

00:39:53How's is it?

00:40:04Ah

00:40:12A, B, C, D, E, F, G, H

00:40:19This go be short

00:40:20Kar diya

00:40:21Anah

00:40:24This go be short

00:40:26Kar diya

00:40:28Likin

00:40:31Adar may karda hum

00:40:36Month

00:40:37Kar diya

00:40:47Niche matara charni

00:40:49Call of transaction

00:40:50Manish

00:40:51T dot

00:41:02T dot hat abijay

00:41:03Transaction date

00:41:05Anah

00:41:08Abney

00:41:09Malha

00:41:09K

00:41:12K

00:41:13K

00:41:14K

00:41:15K

00:41:20K

00:41:22K

00:41:23K

00:41:24K

00:41:27K

00:41:28K

00:41:30K

00:41:31K

00:41:32He is too ready to get a date.

00:41:37Do you understand?

00:41:40He is too ready.

00:41:44God!

00:41:50Do you have a date on two things?

00:41:54Yeah, please.

00:41:56He is too ready to get out of the virus.

00:42:00I'm not going to say this is the end person.

00:42:09Where are you?

00:42:12Where are you?

00:42:15Where are you?

00:42:20..

00:42:35..

00:42:48This is a group by the multi-politics, group by the product lab.

00:43:02put your hands out

00:43:05put them up

00:43:10put them up

00:43:19put them up

00:43:32Can you see the call on the other side?

00:43:39No, no.

00:43:40Call on the other side.

00:43:43Oh.

00:43:48It's coming?

00:43:49Hmm.

00:43:50It's coming.

00:43:52How do you implement it?

00:43:55It's coming.

00:44:00Just put it in City1.

00:44:02Just put it in the population.

00:44:20Order.

00:44:25May you come for theiertza?

00:44:33What is it?

00:44:35Oh.

00:44:36Yes.

00:44:38Now.

00:44:39Wow.

00:44:40I'll show you.

00:44:42I'm not going to get here.

00:44:45Now.

00:44:47Wow.

00:44:48Now.

00:44:49Alright.

00:44:50So.

00:44:51Yes.

00:44:52It's coming back to me.

00:44:53I have removed it.

00:45:04Is it okay here?

00:45:07Okay.

00:45:09Okay.

00:45:10I am doing something here.

00:45:14Salat, Estar and CTD.

00:45:23I am in the office.

00:45:26I can see what I can do.

00:45:28I cannot do that.

00:45:29Yes, I am in the office.

00:45:33Yes, okay.

00:45:35But I am doing it.

00:45:37Okay.

00:45:38I am doing that.

00:45:40Okay.

00:45:42Here we go.

00:45:45Okay.

00:45:46Let's see if we have the other questions.

00:45:48Let's see if we have a demo.

00:45:50It really is.

00:45:51No more time.

00:45:53I will do this.

00:45:58How do I do this?

00:46:05I will do this.

00:46:07Okay. I will do this.

00:46:10But I will see what happens.

00:46:15I will do this.

00:46:18We will do this.

00:46:22I will do it.

00:46:24Let me go.

01:01:25Okay.

01:01:55Okay.

01:02:25Okay.

01:02:55Okay.

01:12:25Okay.

01:13:54Okay.

01:14:54Thanks.

01:15:54Okay.

01:16:24Okay.

01:16:54Okay.

01:17:54Okay.

01:18:24Okay.

01:18:54Okay.

01:19:54Okay.

01:21:24Okay.

01:22:24Okay.

01:23:24Okay.

01:23:54Okay.

01:24:24Okay.

01:24:54Okay.

01:25:24Okay.

Category

Transcript

Be the first to comment

Recommended