34 Live SQL Practice Session 11 Jan 2026

RAKESH KUMAR

Hi, this video will help you to SQL interview preparation.   SQL Script file : -  https://drive.google.com/file/d/1tpYCGZmuQXTHeD7tC_km2bJI4Q2DFcqM/view?usp=sharing   Whatsapp Group Link- https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt   Microsoft Excel Course: Advanced Excel Training  https://www.udemy.com/course/microsoft-excel-excel-from-beginner-to-advanced-m/?couponCode=FC0D30F148B3045E6E59   whatsup channel-https://whatsapp.com/channel/0029VbCRcDn0wajydqPNbv0R

Transcript

00:00:01So, today we will create a stable

00:00:06Create database

00:00:10January 1126

00:00:28This is a sales table

00:00:33Sales ID, Sales Person

00:00:36Region, Sales Date, Amount

00:00:38It's a small table

00:00:43It's okay

00:00:44It's ranked all sales by date

00:00:52Rank all sales by date

00:00:56Rank all sales by date

00:00:58Ranking doesn't need to be added

00:01:00Ranking doesn't need to be added

00:01:31Ranked amount

00:01:32You have to rank in the sales amount of the base, rank

00:01:38Okay, let's write it

00:01:46Select amount

00:01:47If you have the amount, let's leave the rest of the field

00:01:53I will leave my name.

00:01:55I will leave my name.

00:01:57I will leave my name.

00:01:59If we take all of the stuff, we will take all of them.

00:02:01Select star.

00:02:02And sir, rank.

00:02:08Back it.

00:02:09Start.

00:02:10And then we will save it.

00:02:13Over.

00:02:14And then we will save it.

00:02:17And then we will save it.

00:02:18Amount.

00:02:21Order.

00:02:36From, from, no, no, as, as rank from sales.

00:02:45What is it?

00:02:48What?

00:02:52What is it?

00:02:54Incorrect.

00:03:07I see, I'm going to order by amount.

00:03:11Okay, I'm going to order by amount.

00:03:15Okay, so this is small and small.

00:03:19And if it's small, it's small.

00:03:23And if it's small, it's small.

00:03:25And if it's small, it's small.

00:03:26And if it's small, it's small.

00:03:35And if it's small and small, it's small.

00:03:43And then if it's small, it's small.

00:03:47just a simple cable to have a groupings of a group by select person sales yes I don't

00:04:07I don't think I have to say the ranking for the ranking.

00:04:10Tell me about how many sales can be.

00:04:16How many times?

00:04:19It means how many times it is.

00:04:22If I have to put it on the last part, I have to put it on the last part.

00:04:32partition, then partition, partition, partition, and then partition, you know, step, so if

00:04:39you ask number three, you can say four or five times, and if you ask amount, we will

00:04:46do solve a sum, and counting, then we will do both, select salesperson, and the salesperson.

00:05:01some amount as total amount from sales group by sales persons.

00:05:38We need to apply rank and dance rank based on sale amount.

00:05:46We need to apply rank.

00:05:57We need to apply rank.

00:05:58We need to apply rank.

00:06:19We need to apply rank.

00:06:43We need to apply rank.

00:07:14We need to apply rank.

00:07:43We need to apply rank.

00:07:45We need to apply rank.

00:07:47We need to apply rank.

00:07:59We need to apply rank.

00:08:07Let's use rank.

00:08:09over, order by date, back at once, change it as a last amount from sales.

00:08:40How is this ?

00:08:42How is this ?

00:08:43How is this ?

00:08:54I am the function to ask a computer

00:08:57I am using a lot of functioning for the city that I am

00:09:02going to

00:09:08I am

00:09:13I am

00:09:14I am

00:09:15I am

00:09:17I am

00:09:21I am

00:09:22I am

00:09:23a different

00:09:26difference

00:09:26is

00:09:28in

00:09:29ct

00:09:31ct

00:09:32ct

00:09:34ct

00:09:42ct

00:09:53a

00:09:54a

00:09:57a

00:09:58self-referent

00:09:59in

00:10:00ar

00:10:02ir

00:10:20go

00:10:21to

00:10:22Oh yeah, I'm sorry.

00:10:26Yeah, it was a amount of her month growth per sale.

00:10:34That is a month sale.

00:10:37It's a month.

00:10:41January, February.

00:10:43February date is more than a month.

00:10:47So..

00:10:57It's pretty long.

00:10:59The data is smaller.

00:11:01OK, we'll let this thing and skip it.

00:11:03We'll have some questions in another one.

00:11:06OK?

00:11:10It's quite a long time.

00:11:11Month over month.

00:11:12Month over month.

00:11:41growth the percentage

00:11:45to select sales person or month sale sale date

00:12:05month sale date month sale sale sale sale month

00:12:14ho gaya ab comma program some amount and a little TTL amount from sales group by dog

00:12:40ho jaga gumbaya sales person haa haa akshubya sales persons or a month month

00:12:50car sales date

00:13:11Yes, I have done this.

00:13:16But I am going to go to the city and I am going to the city.

00:13:22The rest of it is not?

00:13:27No, not.

00:13:30It is good in the salesperson.

00:13:32It's not good.

00:13:36It's good.

00:13:40It's good.

00:13:42If you don't have a blank, it will not be able to get blank.

00:13:46Then, you will need to know how to win.

00:13:49I am not sure if one stops.

00:13:59I am not sure if we get into the city, but I am not sure if the city stops.

00:14:18I'm going to copy this with CTE Edge.

00:14:33yes

00:14:39yeah

00:14:45take a city to other

00:14:49yeah I am a man number we are getting our month get based for a

00:14:55not legally like this yes sir

00:14:59so

00:15:00I am a man

00:15:06TTL

00:15:07I am on to one

00:15:11Oh her

00:15:14order why

00:15:18partition by partition by partition by sales person or order by month

00:15:38partition

00:15:51partition will be

00:15:53BRADIS

00:15:55DWhat?

00:16:04BRADIS

00:16:05SCOOK

00:16:10DATA

00:16:12OK

00:16:12So we will do more data clearing.

00:16:16We will do more data.

00:16:16We will filter more data.

00:16:18This is good when we are seeing it.

00:16:31Let's see it better.

00:16:36So let's see it.

00:16:383, 10.

00:17:08amount match

00:17:38I got it.

00:17:39I got it.

00:17:41No, sir, it's correct.

00:17:48So I got it.

00:17:53We will minus this.

00:17:59You can also add it.

00:18:03yes

00:18:03I am going to enter bar

00:18:05to the next one

00:18:06I will see

00:18:07I will see

00:18:09I will see

00:18:11TTL amount

00:18:14minus

00:18:17partition

00:18:18copy

00:18:19copy the widget.

00:18:21.

00:18:27.

00:18:28.

00:18:30.

00:18:30I'm going to go.

00:18:46I'm going to go.

00:18:58Um

00:19:00Yeah, what's the reason for the

00:19:03I'll have a

00:19:05I'm

00:19:11I'm

00:19:17I'm

00:19:18I'm

00:19:19I'm

00:19:20I

00:19:21This is a different one.

00:19:22You can put it in the next one.

00:19:27Here...

00:19:29You can leave it and you can't leave it.

00:19:34Yes, you can leave it.

00:19:36Next, enter marker.

00:19:40This is...

00:19:45divided by...

00:19:46A.

00:19:50okay

00:19:51okay

00:19:53as

00:19:55ratio

00:19:56I

00:19:57I

00:19:58I

00:19:59I

00:20:00I

00:20:02I

00:20:04I

00:20:05I

00:20:07I

00:20:10I

00:20:11I

00:20:12I

00:20:13I

00:20:17I

00:20:27I

00:20:29I

00:20:41I

00:20:48I

00:20:50I

00:20:51I

00:20:52I

00:20:53I

00:21:11I

00:21:12I

00:21:15I

00:21:17I

00:21:19I

00:21:21I

00:21:34I

00:21:40I

00:21:46I

00:21:52I

00:21:56I

00:21:57I

00:21:58I

00:22:08I

00:22:09I

00:22:10I

00:22:12I

00:22:13I

00:22:14I

00:22:16I

00:22:17I

00:22:23I

00:22:24I

00:22:25I

00:22:26I

00:22:27I

00:22:28I

00:22:30I

00:22:31I

00:22:42I

00:22:43I

00:22:44I

00:22:45I

00:22:46I

00:22:47I

00:22:48I

00:22:49I

00:22:50I

00:22:51I

00:22:53I

00:22:57I

00:22:59I

00:23:00I

00:23:01I

00:23:02I

00:23:03I

00:23:04I

00:23:07I

00:23:16I

00:23:18I

00:23:21I

00:23:22I

00:23:23the original

00:23:25yes

00:23:26yes

00:23:27yes

00:23:28yes

00:23:37yeah

00:23:39yeah

00:23:41yeah

00:23:45last month

00:23:47yeah

00:23:50yeah

00:23:53I am doing it.

00:23:55I am doing it.

00:23:58But why are you not doing it?

00:24:00You need to convert the data type.

00:24:07We need to change the percentage of this value.

00:24:24This value has come.

00:24:29Now we need this value into

00:24:38Divide is done

00:24:43Hmm

00:24:46Why do you have another one?

00:24:49It's wrong

00:24:50It's not

00:24:596,000

00:25:00I am saying that there is a difference there is no negative number, but it is positive.

00:25:11Now, I think that it was 800 sales and it was 3700 sales.

00:25:22My degrowth was made by 2800, so the percentage is still here, so I have to show you, and I

00:25:28have to show you.

00:25:33When it was coming,

00:25:39If you start round, then it will come?

00:25:43It doesn't come from round, sir. It's a different function.

00:26:01How to Convert Percentage Format in SQL Server

00:26:20How to Convert Percentage Format in SQL Server

00:26:46How to Convert Percentage Format in SQL Server

00:27:03Yes, he has given it from a hundred dollars.

00:27:06I have to do it

00:27:09I have to do it

00:27:27I have to do it

00:27:30I have to do it

00:27:32Where is it?

00:27:33I have to do it

00:27:38I have to do it

00:27:45I have to do it

00:27:47I have to do it

00:27:52Where is it?

00:27:54This is

00:27:55Total

00:27:57Divide

00:27:58I have to do it

00:28:11And

00:28:11Divide

00:28:12Divide

00:28:15Divide

00:28:16Divide

00:28:17Divide

00:28:20Divide

00:28:27Divide

00:28:34Divide

00:28:41Divide

00:28:42Divide

00:28:43Divide

00:28:44Divide

00:28:47Divide

00:28:54Divide

00:28:55Divide

00:28:57Divide

00:28:58Divide

00:28:59Oh

00:29:00Oh

00:29:01Is

00:29:02Is

00:29:03Is

00:29:04Is

00:29:05Is

00:29:14Is

00:29:15Is

00:29:17Is

00:29:18Is

00:29:19Is

00:29:38This is a partition, brother.

00:29:43This is a partition, sir.

00:29:49Hold on first.

00:29:54What amount will you do here?

00:29:59Minus, sir.

00:30:02Minus.

00:30:03Minus, sir.

00:30:06Total amount.

00:30:08What is this?

00:30:14Got it.

00:30:24Minus.

00:30:29Minus.

00:30:31Minus.

00:30:32Minus,

00:30:33I was here to be a copy of the video.

00:30:39This is the one.

00:30:41Okay.

00:30:43This is the one.

00:30:44Now, the total amount of the first one is to put a bracket.

00:30:47This is the one.

00:30:48This is the one.

00:30:50This is the one.

00:30:51This is the one.

00:30:52No, no, just wait.

00:30:53The difference is coming.

00:30:56Now, we divide the last one.

00:30:58You say it is the one.

00:31:01Yes, it is the one.

00:31:03different so we have to copy it into one hundred

00:31:16now we have to see it

00:31:20now we are saying that last minute

00:31:24last minute into one hundred

00:31:28Is code different in two hundred?

00:31:32Yes, hundred point zero.

00:31:35Hundred.

00:31:37Hundred point zero.

00:31:41Now divided by?

00:31:44Yes, divided by previous cell.

00:31:49Yes, that's the one that you have created.

00:31:52Selected star.

00:32:12Come here, man.

00:32:17I did why my error came, so I have to scroll.

00:32:25100% before the bracket.

00:32:27No, no, no.

00:32:29100% before the bracket close.

00:32:32This is?

00:32:33Yes, this is the last one.

00:32:36Yes, it's gone.

00:32:43It's gone.

00:32:44It's gone.

00:32:46It's gone.

00:32:49It's gone.

00:32:50This bracket is going on.

00:32:56It's gone.

00:33:03This is the point.

00:33:04Now it's gone.

00:33:05It's gone.

00:33:07It's gone.

00:33:20It's gone.

00:33:21It's a bad thing.

00:33:24It's a bad thing.

00:33:25This is a different thing.

00:33:29It's not going to get.

00:33:32It's going to get.

00:33:34It's going to get.

00:33:37It's done.

00:33:40If we have 100, then it's going to get.

00:33:55is now divided by divided by divided by divided by a

00:34:15Let's see, divide by zero error and counter.

00:34:25One second, without a call.

00:34:27There will be an error where it has zero value and divide it, but there will be an error.

00:34:32One second, Sandeer.

00:34:34There will be a message for the error.

00:34:36Good morning.

00:35:22What will you do to save this error?

00:35:27If an error comes, it will be zero value.

00:35:30What is good?

00:35:31He has put a call.

00:35:35Or else.

00:35:37Is there an error in SQL?

00:35:43Let me see.

00:35:44It will be an error.

00:35:58Numerator.

00:36:00Okay.

00:36:01Null if.

00:36:06Null if.

00:36:10Zero is zero.

00:36:12How does it happen?

00:36:18If you divide it from zero, then if you divide it from zero, then there will be an error.

00:36:26So, if you divide it from zero, then it will be zero.

00:36:37Where will we go?

00:36:40Where will we go?

00:36:40In this?

00:36:48Yes, sir.

00:36:50Or comment?

00:36:52I think.

00:36:56No.

00:36:59Something wrong.

00:37:09Something wrong.

00:37:11No.

00:37:16No.

00:37:18The null has had replaced it.

00:37:19Zero is zero.

00:37:21But he is not doing this.

00:37:23Let's do this.

00:37:28With some work.

00:37:29No.

00:37:31Not.

00:37:33No.

00:37:34No.

00:37:35Look the...

00:37:45it's a store procedure

00:37:47I

00:37:52Null

00:37:531

00:37:572

00:38:02store procedure

00:38:03we have been building past

00:38:05we have been building past

00:38:06but we haven't done anything

00:38:08was a good job.

00:38:13Where is this?

00:38:16One second, wait.

00:38:225Y to 0.

00:38:26This is the idea.

00:38:29umm

00:38:30ka

00:38:30A

00:38:32A

00:38:33A

00:38:34A

00:38:59Do I do I do I do I do I

00:39:08I wear up Kimah I I I

00:39:14I've Kimah yeah

00:39:20Okay, yeah, I'm a rat concert sale. Oh, I had zero

00:39:29oh

00:39:30oh this side is not last month

00:39:34not last month

00:39:37or total amount

00:39:39divide

00:39:40it will be last month

00:39:46listen

00:39:56listen

00:39:57zero by zero

00:40:04current sale

00:40:06previous sale

00:40:08divided by previous sale

00:40:10previous sale

00:40:11row data

00:40:13we have to replace

00:40:15in the last month

00:40:17last month

00:40:19last month

00:40:22last month

00:40:22previous

00:40:24yes

00:40:26yes

00:40:27yes

00:40:35select

00:41:06five

00:41:06one

00:41:06yes

00:41:07yes

00:41:08yes

00:41:09yes

00:41:10yes

00:41:11yes

00:41:13yes

00:41:14no

00:41:14yes

00:41:15no

00:41:17no

00:41:19no

00:41:21yes

00:41:24no

00:41:25yes

00:41:26It looks like it's not a leaf, but it looks like it's not a leaf.

00:41:45how do we have done what we have given

00:41:55no, this is not good

00:41:59this is not good

00:42:02this is not good

00:42:03this is not good

00:42:04this is not good

00:42:05There will also be another function to replace it.

00:42:12Coles is not in SQL Server.

00:42:18No.

00:42:21It is not in SQL Server.

00:42:30Coles has come.

00:42:31What is it?

00:42:33Coal.

00:42:35Coal.

00:42:38Coal.

00:42:39E-S-C-E.

00:42:50No.

00:42:52Case.

00:43:07What do you have it?

00:43:10Let me see if there is no function.

00:43:14It is not in function.

00:43:18Oh, hey, what?

00:43:20Yeah, you can't come from the house.

00:43:26Oh, didn't.

00:43:32By the night.

00:43:37I'm going to check on my phone.

00:43:57I can't wait.

00:43:59I can't wait.

00:44:00I can't wait.

00:44:08I can't wait.

00:44:25I will do the same thing.

00:44:30Different.

00:44:32Different.

00:44:34I am coming from the city.

00:44:38I will put it in the city and then I will do it easily.

00:44:45I will not be able to put it in the city.

00:44:50It will not be able to put it in the city.

00:44:54It will be here, right?

00:44:57Yes, sir.

00:45:00I will not be able to put it in the city.

00:45:09I will not be able to put it in the city.

00:45:22The city is doing it, okay.

00:45:41Bajit, I'm going to play a scooter.

00:45:45A scooter?

00:45:47Where is it?

00:45:48Bajit, I'm going to charge.

00:45:50Bajit.

00:45:52Bajit.

00:45:54Bajit.

00:46:03Bajit.

00:46:04Near one.

00:46:08Where is it?

00:46:09Where is it?

00:46:14Oh, let's go.

00:46:16So, I say,

00:46:18I'm going to go.

00:46:20Now, let's select a star

00:46:24or

00:46:27or

00:46:29case

00:46:32when

00:46:34different

00:46:38is equal to

00:46:40different

00:46:44is equal to 0

00:46:47then

00:46:470

00:46:51else

00:46:57else

00:46:58else

00:46:58different

00:46:59is equal to 0

00:47:00is equal to 0

00:47:03is equal to 0

00:47:03not 0

00:47:04is equal to 0

00:47:05what was it?

00:47:06last month

00:47:08last month

00:47:12last month

00:47:15sale

00:47:17divided

00:47:18or

00:47:19sorry

00:47:20after

00:47:21is equal to 0

00:47:25is equal to 0

00:47:28is equal to 0

00:47:29can we

00:47:35say

00:47:36here

00:47:37last month

00:47:390

00:47:39is equal to 0

00:47:50From

00:47:52from

00:47:53typing

00:47:55okay

00:47:58end

00:47:59edge

00:48:01ratio

00:48:03end

00:48:06then

00:48:06came

00:48:12but

00:48:15now

00:48:20different

00:48:21into

00:48:23and

00:48:24I

00:48:27I

00:48:28I

00:48:29I

00:48:30I

00:48:31I

00:48:32I

00:48:33I

00:48:35I

00:48:37I

00:48:38I

00:48:44I

00:48:45I

00:48:47I

00:48:49I

00:49:17I

00:49:19I

00:49:20I

00:49:23I

00:49:24I

00:49:28I

00:49:38I

00:49:54I

00:49:56I

00:49:57I

00:50:01I

00:50:03I

00:50:04I

00:50:05I

00:50:06I

00:50:08I

00:50:17I

00:50:19I

00:50:21I

00:50:23I

00:50:28I

00:50:29I

00:50:35I

00:50:36I

00:50:46I

00:50:48I

00:50:58I

00:50:59I

00:51:02I

00:51:04I

00:51:06I

00:51:08I

00:51:10I

00:51:20I

00:51:22I

00:51:24I

00:51:26I

00:51:28I

00:51:29I

00:51:30I

00:51:32I

00:51:38I

00:51:39I

00:51:47I

00:52:02I

00:52:04I

00:52:05I

00:52:06I

00:52:07I

00:52:09I

00:52:10I

00:52:12I

00:52:13I

00:52:14I

00:52:15I

00:52:16I

00:52:18I

00:52:19I

00:52:20I

00:52:21I

00:52:22I

00:52:23I

00:52:24I

00:52:25I

00:52:26I

00:52:27I

00:52:28I

00:52:29I

00:52:30I

00:52:32I

00:52:34I

00:52:36I

00:52:37I

00:52:38I

00:52:39I

00:52:41I

00:52:42I

00:52:53I

00:52:55I

00:52:57I

00:52:59I

00:53:00I

00:53:01I

00:53:02I

00:53:03I

00:53:07I

00:53:08I

00:53:09I

00:53:32I

00:53:33I

00:53:34I

00:53:35I

00:53:36I

00:53:37I

00:53:38I

00:53:41I

00:53:42I

00:53:43I

00:53:45I

00:53:46I

00:53:49I

00:53:55I

00:53:56I

00:54:07I

00:54:12I

00:54:14I

00:54:15I

00:54:17I

00:54:18I

00:54:19I

00:54:20I

00:54:21I

00:54:22I

00:54:24I

00:54:28I

00:54:31I

00:54:32I

00:54:54I

00:54:55I

00:54:58I

00:54:59I

00:55:00I

00:55:01I

00:55:02I

00:55:03I

00:55:05I

00:55:06I

00:55:07I

00:55:08I

00:55:09I

00:55:10I

00:55:11I

00:55:12I

00:55:13I

00:55:25I

00:55:26I

00:55:29I

00:55:31I

00:55:32I

00:55:34I

00:55:35I

00:55:36I

00:55:37I

00:55:38I

00:55:40I

00:55:41I

00:55:51I

00:56:04I

00:56:05I

00:56:06I

00:56:08I

00:56:11I

00:56:13I

00:56:15I

00:56:16I

00:56:17I

00:56:19I

00:56:20I

00:56:22I

00:56:23I

00:56:27I

00:56:28I

00:56:33I

00:56:39I

00:56:48I

00:56:51I

00:56:52I

00:56:54I

00:56:57I

00:56:58I

00:57:01I

00:57:02I

00:57:03I

00:57:04I

00:57:05I

00:57:06I

00:57:07I

00:57:08I

00:57:09I

00:57:11I

00:57:12I

00:57:14I

00:57:15I

00:57:16I

00:57:17I

00:57:30I

00:57:32I

00:57:34I

00:57:45I

00:57:46I

00:57:47I

00:57:49I

00:57:50I

00:58:17I

00:58:19I

00:58:20I

00:58:21I

00:58:23I

00:58:28I

00:58:29I

00:58:38I

00:58:43I

00:58:45I

00:58:46I

00:58:47I

00:58:48I

00:58:50I

00:58:52I

00:59:03I

00:59:05I

00:59:06I

00:59:07I

00:59:18I

00:59:20I

00:59:21I

00:59:22I

00:59:23I

00:59:24I

00:59:26I

00:59:34I

00:59:35I

00:59:37I

00:59:38I

00:59:39I

00:59:42I

00:59:43I

00:59:44I

00:59:45I

00:59:48I

00:59:49I

00:59:51I

00:59:52I

00:59:53I

00:59:54I

00:59:55I

00:59:56I

00:59:59I

01:00:00I

01:00:01I

01:00:02I

01:00:03I

01:00:04I

01:00:06I

01:00:07I

01:00:08I

01:00:11I

01:00:12I

01:00:13I

01:00:14I

01:00:17I

01:00:19I

01:00:20I

01:00:22I

01:00:24I

01:00:25I

01:00:26I

01:00:37I

01:00:38I

01:00:40I

01:00:41I

01:00:43I

01:00:45I

01:00:50I

01:00:51I

01:00:52I

01:00:53I

01:00:55I

01:00:56I

01:01:11I

01:01:14I

01:01:15I

01:01:16I

01:01:17I

01:01:18I

01:01:19I

01:01:21I

01:01:30I

01:01:31I

01:01:33I

01:01:35I

01:01:36I

01:01:38I

01:01:41I

01:01:42I

01:01:44I

01:01:46I

01:01:48I

01:01:50I

01:01:51I

01:01:52I

01:01:54I

01:02:00I

01:02:01I

01:02:02I

01:02:06I

01:02:07I

01:02:08I

01:02:09I

01:02:10I

01:02:26I

01:02:27I

01:02:38I

01:02:39I

01:02:40I

01:02:41I

01:02:42I

01:02:43I

01:02:45I

01:02:57I

01:02:58I

01:02:59I

01:03:01I

01:03:02I

01:03:03I

01:03:12I

01:03:13I

01:03:14I

01:03:16I

01:03:35I

01:03:36I

01:03:37I

01:03:37Iolved

01:03:38Me

01:03:38I

01:03:40I

01:03:41I

01:03:42I

01:03:49What

01:04:12No, the stream is picked up and picked up

01:04:181-3

01:04:20But our fix is not enough

01:04:30How much will it come?

01:04:33If there are 2, then it will be fine.

01:04:35But this is not for me.

01:04:40What would it have been put in the sub-stremers?

01:04:44Character index

01:04:49Character index

01:04:50In this case, we will select the dot

01:04:59If we do this, we will select the dot

01:05:02Then we will select the dot

01:05:03We will select the dot

01:05:06Here we will select the dot

01:05:17Character index

01:05:19In this case, we will select the dot

01:05:28The dot

01:05:30The dot

01:05:32The dot

01:05:33The dot

01:05:43The dot

01:05:45Why are you working on this project?

01:05:54Why are you working on this project?

01:06:03Why are you working on this project?

01:06:05Why are you working on this project?

01:06:16Why is you working on that project?

01:06:17Hi!

01:06:21How are you working on this project?

01:06:24No mate, this is essentially a portfolio iyaw.

01:06:29Why are you working on this project?

01:06:35Where did it happen?

01:06:42Let's do it here.

01:06:45It's gone.

01:06:48Now, the ratio is gone.

01:06:53There is no ratio here.

01:06:57It's not for anyone.

01:07:00Let's not know.

01:07:06In the city one, the ratio is gone.

01:07:10What?

01:07:11There is no ratio.

01:07:12The ratio is gone.

01:07:14The ratio is gone.

01:07:16Let's put another city.

01:07:19Yes.

01:07:20It's down.

01:07:21The ratio is gone.

01:07:26The ratio is gone.

01:07:36I said

01:07:38Coma CTE

01:07:42One

01:07:43Edge

01:07:48In your

01:07:54Aday

01:08:01Select

01:08:03Star

01:08:04City

01:08:06One

01:08:09Aday

01:08:10Aday

01:08:12Aday

01:08:12Character

01:08:14Index

01:08:16Bracket

01:08:17Find

01:08:19Go

01:08:39Select

01:08:42Select

01:08:43Select

01:08:473 has a dot

01:08:49okay

01:08:51so 3 has a dot

01:08:53so now let's do

01:08:57sub string

01:09:01sub string

01:09:03ratio

01:09:051

01:09:09start

01:09:111

01:09:11and

01:09:143 plus

01:09:152

01:09:16take it

01:09:19yeah

01:09:20I have

01:09:31done

01:09:32what I am doing

01:09:38do you understand

01:09:39Sanjeev

01:09:41yes sir

01:09:42you are

01:09:42understanding

01:09:44this is

01:09:45we are taking number

01:09:472

01:09:48we have

01:09:522

01:09:53now

01:09:55we can use left

01:09:57we can use

01:09:58yes

01:10:02left

01:10:03ratio

01:10:03and

01:10:045

01:10:09we can use

01:10:12okay

01:10:13okay

01:10:14okay

01:10:16okay

01:10:18okay

01:10:20okay

01:10:30okay

01:10:35okay

01:10:36okay

01:10:50percentage

01:10:52here

01:10:59who

01:11:02yeah

01:11:03okay

01:11:03yeah

01:11:07yeah

01:11:08yeah

01:11:11yeah

01:11:13yeah

01:11:17ah ah ah ah ah ah ah ah ah ah ah ah ah this is to lear never

01:11:40argument here

01:11:42argument argument two to take care

01:11:47sorry what happened

01:11:56you have to take care

01:12:01and I have to take care

01:12:09oh

01:12:11yeah

01:12:13oh

01:12:15oh

01:12:23oh

01:12:24what

01:12:28oh

01:12:29oh

01:12:43oh

01:12:45oh

01:12:45I closed the two times, the one is connected.

01:12:53Then the left is in the bracket, the left is in the bracket.

01:12:54If you want the plus 2, you have to write the percentage down here.

01:12:59Now the bracket is in the bracket.

01:13:02This is the left.

01:13:08Two arguments.

01:13:09The left is in the left.

01:13:18Wow

01:13:20Oh

01:13:22Let's close today

01:13:25No questions

01:13:29Okay

01:13:31Bye-bye

Category

Transcript

Comments

Recommended