36 Live SQL Practice Session 25 Jan 2026

RAKESH KUMAR

Hi, this video will help you to SQL interview preparation.   SQL Script file : -  https://drive.google.com/file/d/1tSk9Tpm2QlIAGloqSmbxlclh1WrBjEDq/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:00Computer software has also done automation, right?

00:00:05Yes, automation.

00:00:06People who work with blurry data.

00:00:10Yes, that's right.

00:00:12So, in the last class, three questions were asked.

00:00:17I used this database.

00:00:22I used this database.

00:00:24I used this table for two tables.

00:00:43I used this table for two tables.

00:00:44Now, the question has been answered.

00:00:47Highest revenue day?

00:00:49It means that this is from sales.

00:00:53How will it become?

00:00:54Yes.

00:00:55It will be simple.

00:01:00Highest revenue day.

00:01:02So, sir,

00:01:05the month is the same,

00:01:06then we will do it.

00:01:08Highest revenue day?

00:01:09Yes, it will be 15th January and 15th February.

00:01:12If you are asking,

00:01:15Highest revenue day?

00:01:17It will be one.

00:01:17This is like a month.

00:01:21It will be one.

00:01:22If you ask a month wise,

00:01:23you can ask a month wise.

00:01:25So, you have two questions.

00:01:28One is the whole question,

00:01:30one is the highest revenue,

00:01:34and one is the highest revenue.

00:01:35Oh, what do you say?

00:01:39No, sorry.

00:01:41I mean, it's a month wise.

00:01:47Let me tell you one thing.

00:01:50Select the month name.

00:01:57How do we use the date name?

00:01:58How do we use the date?

00:02:01First, make the highest one day.

00:02:03One day, single day.

00:02:06A single day?

00:02:08So, write the date name and name the date.

00:02:12Use the date of function.

00:02:15The highest one day is the highest one day.

00:02:18So, the date will be 15 January, 16 January, 18 January, 20 March.

00:02:24The highest one is the highest one.

00:02:26Order date.

00:02:28Order date.

00:02:39Comma.

00:02:40Sum.

00:02:44Revenue.

00:02:48As a total revenue.

00:02:55From sales.

00:02:58Group.

00:03:04Order date.

00:03:08Or the date.

00:03:09This is the city is the name of the name.

00:03:10Yeah, city is the name of the name.

00:03:13Is it the name of the name?

00:03:17Sure.

00:03:22The next is the name of the name of the name.

00:03:23revenue and top 1.

00:03:26Order by some revenue descending.

00:03:40DSE is done.

00:03:42Top 1.

00:03:44I am going to leave it.

00:03:49.

00:03:50.

00:03:51.

00:03:52.

00:03:53.

00:03:54.

00:03:55.

00:04:14..

00:04:14.

00:04:16.

00:04:18.

00:04:19.

00:04:20.

00:04:21.

00:04:22.

00:04:23Oh my gosh, this picture is here, month name, date name, date name, date name, date

00:04:36part, date part, order date, month, month, month, month, month, month, month, month,

00:04:52date, month, month, month, month, month, month, month, month, month, month, month, month, month,

00:05:21I am

00:05:35I am

00:05:38I am

00:05:39I am

00:05:40dead parts

00:05:43I

00:05:48I

00:05:49I

00:05:50I

00:05:52I

00:05:56I

00:06:05I

00:06:16I

00:06:17I

00:06:20I

00:06:21I

00:06:22I

00:06:23I

00:06:24I

00:06:25I

00:06:30I

00:06:31I

00:06:33I

00:06:34I

00:06:37I

00:06:40I

00:06:41I

00:06:56I

00:06:57I

00:06:58I

00:07:00I

00:07:01I

00:07:02I

00:07:03I

00:07:04I

00:07:17I

00:07:18I

00:07:19I

00:07:30I

00:07:32I

00:07:33I

00:07:35I

00:07:40I

00:07:42I

00:07:43I

00:07:54I

00:07:56I

00:07:57I

00:07:58I

00:07:59I

00:08:00I

00:08:01I

00:08:02I

00:08:05I

00:08:06I

00:08:09I

00:08:10I

00:08:11I

00:08:12I

00:08:13I

00:08:14I

00:08:16I

00:08:17I

00:08:19I

00:08:49I

00:08:50I

00:08:51I

00:08:52I

00:08:53I

00:08:54I

00:08:56I

00:08:57I

00:08:58I

00:08:59I

00:09:10I

00:09:11I

00:09:13I

00:09:14I

00:09:15I

00:09:18I

00:09:22I

00:09:24I

00:09:31I

00:09:32I

00:09:36I

00:09:37I

00:09:39I

00:09:40I

00:09:41I

00:09:42I

00:09:43I

00:09:44I

00:09:46I

00:09:47I

00:09:49I

00:09:50I

00:09:51I

00:09:52I

00:09:53I

00:09:54I

00:09:55I

00:09:57I

00:10:09I

00:10:10I

00:10:14I

00:10:16I

00:10:28I

00:10:31I

00:10:32I

00:10:33I

00:10:34I

00:10:35I

00:10:36I

00:10:37I

00:10:38I

00:10:39I

00:10:42I

00:10:46I

00:10:48I

00:10:50I

00:10:51I

00:10:52I

00:10:53I

00:10:54I

00:10:56I

00:10:58I

00:10:59I

00:11:11I

00:11:12I

00:11:13I

00:11:14I

00:11:15I

00:11:16I

00:11:18I

00:11:19I

00:11:20I

00:11:21I

00:11:22I

00:11:23I

00:11:35I

00:11:37I

00:11:38I

00:11:39I

00:11:40I

00:11:41I

00:11:42I

00:11:53I

00:11:55I

00:11:56I

00:11:58I

00:11:59I

00:12:00I

00:12:01I

00:12:02I

00:12:04I

00:12:07I

00:12:18I

00:12:19I

00:12:21I

00:12:23I

00:12:29I

00:12:30I

00:12:31I

00:12:40I

00:12:42I

00:12:43I

00:12:44I

00:12:45I

00:12:46I

00:12:47I

00:12:48I

00:12:49I

00:12:51I

00:12:55I

00:12:56I

00:12:57I

00:12:58I

00:13:00I

00:13:01I

00:13:02I

00:13:04I

00:13:14I

00:13:15I

00:13:18I

00:13:19I

00:13:31I

00:13:32I

00:13:33I

00:13:34I

00:13:35I

00:13:36I

00:13:39I

00:13:40I

00:13:41I

00:13:42I

00:14:11I

00:14:12I

00:14:17I

00:14:23I

00:14:24I

00:14:27I

00:14:40I

00:14:41I

00:14:43I

00:14:44I

00:14:45I

00:14:46I

00:14:57I

00:14:59I

00:15:03I

00:15:05I

00:15:06I

00:15:07I

00:15:30I

00:15:34I

00:15:35I

00:15:36I

00:15:38I

00:15:39I

00:16:04I

00:16:07I

00:16:09I

00:16:12I

00:16:14I

00:16:20I

00:16:23I

00:16:24I

00:16:25I

00:16:26I

00:16:28I

00:16:29I

00:16:32I

00:16:33I

00:16:36I

00:16:39I

00:16:40I

00:16:42I

00:16:43I

00:16:44I

00:16:46I

00:16:47I

00:16:48I

00:16:51I

00:16:52I

00:16:57I

00:17:01I

00:17:03I

00:17:04I

00:17:14I

00:17:16I

00:17:17I

00:17:19I

00:17:29I

00:17:32I

00:17:34I

00:17:36I

00:17:37I

00:17:42I

00:17:44I

00:17:46I

00:17:51I

00:17:53I

00:17:54I

00:17:57I

00:17:58I

00:17:59I

00:18:00I

00:18:01I

00:18:02I

00:18:03I

00:18:05I

00:18:06I

00:18:07I

00:18:11I

00:18:12I

00:18:13I

00:18:14I

00:18:15I

00:18:16I

00:18:17I

00:18:19I

00:18:21I

00:18:22I

00:18:23I

00:18:35I

00:18:36I

00:18:37I

00:18:38I

00:18:39I

00:18:41I

00:18:42I

00:18:43I

00:18:44I

00:18:45I

00:18:46I

00:18:48I

00:18:49I

00:18:50I

00:18:51I

00:18:52I

00:18:54I

00:18:55I

00:18:57I

00:19:01I

00:19:02I

00:19:03I

00:19:06I

00:19:17I

00:19:18I

00:19:19I

00:19:20I

00:19:21I

00:19:23I

00:19:24I

00:19:35I

00:19:36I

00:19:37I

00:19:39I

00:19:40I

00:19:48I

00:19:50I

00:19:52I

00:19:55I

00:19:58I

00:20:00I

00:20:03I

00:20:04I

00:20:05I

00:20:06I

00:20:12I

00:20:13I

00:20:14I

00:20:16I

00:20:17I

00:20:27I

00:20:28I

00:20:29I

00:20:30I

00:20:31I

00:20:32I

00:20:33I

00:20:34I

00:20:38I

00:20:39I

00:20:40I

00:20:41I

00:20:42I

00:20:43I

00:20:45I

00:20:46I

00:20:49I

00:20:50I

00:20:51I

00:20:53I

00:20:54I

00:20:55I

00:20:57I

00:20:58I

00:20:59I

00:21:01I

00:21:02I

00:21:31I

00:21:33I

00:21:35I

00:21:39I

00:21:44I

00:21:46I

00:21:47I

00:21:49I

00:21:51I

00:22:01I

00:22:03I

00:22:05I

00:22:06I

00:22:07I

00:22:08I

00:22:10I

00:22:13I

00:22:14I

00:22:17I

00:22:19I

00:22:20I

00:22:28I

00:22:38I

00:22:40I

00:22:41I

00:22:44I

00:22:45I

00:22:46I

00:22:48I

00:22:49I

00:23:12I

00:23:13I

00:23:14I

00:23:16I

00:23:17I

00:23:18I

00:23:19I

00:23:23I

00:23:24I

00:23:25I

00:23:26I

00:23:27I

00:23:28I

00:23:29I

00:23:31I

00:23:33I

00:23:36I

00:23:37I

00:23:38I

00:23:42I

00:23:43I

00:23:44I

00:23:50I

00:23:58I

00:23:59I

00:24:01I

00:24:02I

00:24:04I

00:24:05I

00:24:06I

00:24:09I

00:24:13I

00:24:14I

00:24:17I

00:24:19I

00:24:20I

00:24:21I

00:24:22I

00:24:23I

00:24:24I

00:24:25I

00:24:27I

00:24:28I

00:24:29I

00:24:30I

00:24:32I

00:24:34I

00:24:37I

00:24:38I

00:24:40I

00:24:42I

00:24:54I

00:24:56I

00:24:57I

00:24:58I

00:24:59I

00:25:00I

00:25:02I

00:25:11I

00:25:12I

00:25:13I

00:25:16I

00:25:17I

00:25:28I

00:25:29I

00:25:30I

00:25:31I

00:25:34I

00:25:35I

00:25:37I

00:25:38I

00:25:39I

00:25:40I

00:25:41I

00:25:42I

00:25:43I

00:25:55I

00:25:56I

00:25:57I

00:25:58I

00:25:59I

00:26:01I

00:26:02I

00:26:03I

00:26:04I

00:26:12I

00:26:13I

00:26:34I

00:26:35I

00:26:36I

00:26:37I

00:26:39I

00:26:40I

00:26:42I

00:26:43I

00:26:44I

00:26:46I

00:26:52I

00:26:53I

00:26:54I

00:26:55I

00:27:05I

00:27:07I

00:27:08I

00:27:09I

00:27:12I

00:27:14I

00:27:21I

00:27:22I

00:27:26I

00:27:37I

00:27:38I

00:27:40I

00:27:41I

00:27:42I

00:27:43I

00:27:47I

00:27:48I

00:27:49I

00:27:50I

00:27:51I

00:27:52I

00:27:53I

00:27:54I

00:27:55I

00:27:56I

00:27:57I

00:27:58I

00:27:58Also

00:27:59I

00:28:00I

00:28:22and

00:28:26and

00:28:27and

00:28:28and

00:28:28and if we don't put this in CT, then we can add a code to select.

00:28:40Then it will be done.

00:28:45Select a star from

00:28:48this is as new table where rnk is equal to one

00:29:14select seo pae ga sari isko poore go leja karke hai hai hai banayenge isko abhi rukko na

00:29:23No sir, you have done this for 1 second, sir.

00:29:28Just go back to that, what you have done.

00:29:30Select star.

00:29:34Yes, you have put it in the entire place.

00:29:38Now, we are going to...

00:29:40This is coming, this is not coming.

00:29:43Now, what is it?

00:29:47SDD

00:29:47bukan so much, it's what it is.

00:30:04Yes, we are going.

00:30:05Do we want to load the list?

00:30:05No.

00:30:06Yes.

00:30:08So, do you do this?

00:30:09Correct.

00:30:15Do you do this?

00:30:17select it says it's a kiss of kiss now then I'm gonna go to the end of the day

00:30:27I am a

00:30:29DDD

00:30:30This is

00:30:37This

00:30:39This

00:30:40This

00:30:42Is

00:30:44The

00:30:44Column name

00:30:46We have to

00:30:46Go

00:30:46Column name

00:30:47This

00:30:49Is

00:30:50The

00:30:50Column name

00:30:52The

00:30:55I would like to do a video on my phone.

00:30:59It's the video and I just think

00:31:08that, by the way.

00:31:10I assisted that, but I haven't been doing so much again.

00:31:12It doesn't seem to be real, it's essentially it's not a real problem.

00:31:21Now, we'll talk about the whole thing.

00:31:22Your name was her face.

00:31:23Okay, it's a bad girl.

00:31:25What's that?

00:31:28What's that?

00:31:29Come on.

00:31:31Come on.

00:31:32Come on.

00:31:33Come on.

00:31:34Come on.

00:31:35Come on.

00:31:36She's gone.

00:31:40She's gone.

00:31:44She's gone.

00:31:45We had a little long city.

00:31:49She's gone.

00:31:52She's gone.

00:31:57She's gone.

00:31:59Oh.

00:32:00Yes.

00:32:01B2.

00:32:02Cumulative revenue per category.

00:32:07Select a star.

00:32:12From sales.

00:32:15Cumulative revenue per category.

00:32:19There is a category category name.

00:32:20There's a category name.

00:32:22We have to do.

00:32:25Fables.

00:32:26Clicked by category.

00:32:31Yeah.

00:32:34Yes.

00:32:34This is.

00:32:36This is a category name.

00:32:44A category name.

00:32:46It's something.

00:32:51per category.

00:32:54The two will be cumulative.

00:32:58Revenue.

00:33:01Select star from products.

00:33:06products

00:33:06what is the

00:33:10x

00:33:16sales

00:33:19as

00:33:20on

00:33:24a

00:33:24product

00:33:25id

00:33:27equal to

00:33:31order ID

00:33:34order ID

00:33:35order ID

00:33:36order

00:33:38sorry

00:33:38product ID

00:33:39yeah

00:33:40yeah

00:33:42and here

00:33:44we need

00:33:46p.category

00:33:48p.category

00:33:50sum

00:33:55s.revenue

00:33:58s.revenue

00:34:00s.revenue

00:34:04groupbikes

00:34:05or groupbikes

00:34:07groupbikes

00:34:07p.category

00:34:08p.category

00:34:17here

00:34:22p.t.l.revenue

00:34:24t.t.l.revenue

00:34:28you know I want to have a total normal array ito photo guy over yes sir I wish

00:34:37this is cumulative and this is cumulatively

00:34:41so it will be over

00:34:48yes sir

00:34:50yes sir

00:34:51yes sir

00:34:53some some of revenue

00:34:58some

00:34:59some

00:35:05some some some bracket my first some as dot revenue

00:35:10a

00:35:11a

00:35:14a

00:35:15a

00:35:22order

00:35:23a

00:35:24No sir, he will have partition by.

00:35:26Order by, sir?

00:35:28Partition by.

00:35:29No, sorry.

00:35:30Order by, you will.

00:35:32Order by revenue,

00:35:34we will give you the money,

00:35:35but we will give you the money.

00:35:38It's wrong.

00:35:41Order by some revenue,

00:35:45some other person.

00:35:57Yes sir, I need to write this.

00:36:12It's closed.

00:36:20Top Selling Product

00:36:24so if I will copy this one,

00:36:32and I will

00:36:36remove this one.

00:36:45I will remove this one.

00:36:52Yes, yes, sir, Yes, Sir, P dot product.

00:36:58By changing here, sir.

00:36:59Where?

00:37:01Select, sir.

00:37:02P dot product name.

00:37:05Yes, sir, yes, sir.

00:37:10So, A is here.

00:37:11Now I have to put the order wire

Category

Transcript

Comments

Recommended