35 Live SQL Practice Session 18 Jan 2026

RAKESH KUMAR

Hi, this video will help you to SQL interview preparation.   SQL Script file : -  https://drive.google.com/file/d/1RiLq8vL-q9eLOsH1WGfm6EYFr70s-5E5/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:02so today we are going to create a database

00:09this database has been used

00:14this database has made a product

00:16this database has been created

00:19this database has been created

00:21this database has been created

00:26in the database

00:27this database has been created

00:37now we have two tables

00:41one library and one library

00:44one library

00:44this database has been created

00:56I will see it on the top of the laptop, phone, chair, table, bed, this category type is electronic, furniture,

01:14and second, which is the date of sale, order ID, product ID which is on the top, order date, quantity,

01:23and its quality.

01:26I will see it on the top of the laptop.

01:37The total revenue by product.

01:53The total revenue by product.

01:56The total revenue by product.

01:57The product can be on the top of the laptop.

02:02The total revenue by product.

02:22The total revenue by product.

02:25we will be joining

02:28but not going to join

02:30join

02:32products

02:35on

02:40s dot

02:43product ID

02:46equal to

02:49three dot

02:51product ID

02:52I will touch

02:56and I will give you

02:57a minute

02:58I will give you

03:01a condition

03:03product name

03:08P dot product name

03:10P dot

03:11P dot product name

03:17P dot product name

03:22sir some practice start or up car as dot revenue bus bracket moment or

03:37not only the as a total revenue

03:50the user or you have a last master conditioned on the gym group by

03:55Okay.

04:00Product.

04:02As.

04:04Product.

04:05Product.

04:06Edition.

04:12Yeah.

04:13Yeah.

04:14Yeah.

04:15Yeah.

04:17Yeah.

04:25P. Dot product name.

04:27P. Dot product name.

04:30Let's see.

04:31It's gone.

04:33Okay.

04:34I will verify.

04:36I will verify.

04:38I have 3.

04:4324,000.

04:458,000.

04:4732,000.

04:4932,000.

04:5132,000.

04:5248,000.

04:5330,000.

04:54So,

04:59this this is

05:00Just

05:00the

05:01service.

05:05That's

05:06it.

05:08It.

05:13This

05:14that

05:14I

05:21were

05:22Oh, okay.

05:2440,000.

05:26Category Y.

05:27Ravannu.

05:29So,

05:30So,

05:30Yes,

05:32Sir.

05:35P.

05:36Name.

05:37Category.

05:38P.

05:39Category.

05:44P.

05:45Category.

05:47Group.

05:48Category.

05:54Oh,

05:55Yeah,

05:56You do.

05:57No,

05:57Yeah,

05:59So,

06:00He said,

06:01And he said,

06:03Amazing.

06:03Otherwise,

06:04He said,

06:05The most common of them,

06:08in each section.

06:10This is a lot of content.

06:12So,

06:13the most common of them have taken.

06:13It's not.

06:14Ones restaurants,

06:16I've got to pass.

06:25total quantity sold per product

06:30quantity is this

06:40quantity is this

06:45a

06:50quantity

06:51a

06:52a

06:55a

06:57a

06:57it's not a or picket a group by it oh it is here from or another product name

07:05category was come a product number total quantity per product

07:10oh I was a product and cut it in category here

07:13a period of product in

07:17a purpose

07:26is

07:27the child take it devil catcher

07:29the phone can punch it

07:33the phone can punch it

07:36the phone can quantity of code

07:40the phone can't do so

07:43oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh

07:52oh oh oh oh oh oh okay

08:01daily cumulative revenue

08:03oh it took ever sales in clay

08:07I think...

08:09Is it right?

08:11It's still...

08:59Recording in progress.

09:18इसमें तो इस्सू हो गया संजीर। यह तो देखो लास्ट के नम्मा नाइन और टेन रिकॉर्ड में।

09:47अच्छा उसके बदले भी ओले रहा ना उसके वहां पर अलग अलग उसको वैल्यों मिली तो तो तब तो हमारा

09:56वो फष्ट वला में भी हो जाएगा

10:04अगया ना तो यह तो यह जो था हमारा जो फर्स्ट वाला हमने डिस्टिंग्स के दो बात कर रहे थे

10:12डिस्टिंग्स उसके डारना पड़ेगा और रिप्टिंग्स हो जाएगा देखो ना हो जाना चाहिए

10:23is

10:24okay no no no distinct

10:25yeah

10:28okay

10:29yeah

10:31yeah

10:32yeah

10:42rank product by revenue

10:46revenue

10:47revenue का ranking चाहिए तो हमने revenue कौन सा निकाला था कि यह

10:56कि क्या है कि प्रोड़क्ट वाइज रवन तो हमने के टेगरी वाइज है

11:09तो जॉइस लगाना जरूरी सर्फिया अगर जॉइन लगाएंगे तो फिर कैसे आएगा अभी यहां पर आगया अब इस्टी में लिजाना

11:24पड़ेगा फ्रेस को

11:26सीटी में लगना पड़ेगा बिच सीटी एज

11:44ठीक है अभी यहां पर असर इस्टार की जागा सर्फ प्रोडेक्ट सेम कॉमा अच्छट सी किसे स्टार इस्टार कॉमा ले

11:54लिजिए अब यहां पर सर्डाल दीजिए रजान दो डेंस रेंख ही कर देंस रेंख

12:01देंस रेंख बैकर इस्टार अफ्लोग ओर और बाय तर्टर रवन वासं लिजिए सर अगर लिकें तर्टाल इस वाले को मिल

12:23जागा

12:25एक सेकेंड अगर

12:35तो कोई बात नहीं है तो डिसेंडिंग कर देते हैं

12:49आज रेंख के लिग बीजिए सक्मेंगा

12:59हाँ हो गया नहीं एत तीन तीन हो गया तो नहीं तीन ठीक है

13:11आज अगर तीन तीन नीचे तो सर उसके लिए रैन एक्स करते हैं जरी नेक्स का अमरे पता ने यार

13:16अरे रैंक और डैंस रैंक दो है यह दिया हूँ है ठीक्ट इंस रैंक की जाएगा

13:28percentage contribution dya hua lakin kis ka dya hua hai ye toh nahi likha hai toh isi

13:34pernikal djee sir isi pernikal dhe product wise trading call it's a contribution isi

13:42per kar deh dance rank ko haa sir isi dance rank wala part hata djee pura or

13:49yehaan pere lik djee sir yehaan pere aapka sub hooghe aap yehaan pere aapka 500 chahiye

13:54toh percentage total revenue as a total revenue divide yehaan pere lik djee sum total revenue

14:15over bracket start bracket once

14:46s

14:47over

14:47no sir over

14:50like this

14:52yes

14:53yes

15:00over

15:01after

15:03round 2

15:05that is

15:07a part

15:07yes

15:08the function

15:11the function

15:13the

15:14the

15:15the

15:16the

15:17the

15:20the

15:22the

15:24the

15:26the

15:27the

15:28the

15:30the

15:53he

15:54I want to do something in which one is going to do it.

16:02It's gone.

16:09I don't know what to do with Xperia Zero.

16:13I don't know what to do.

16:25I am

16:28I am

16:29I

16:30I

16:31I

16:32I

16:33I

16:34I

16:37I

16:38I

16:39I

16:40I

16:41I

16:43I

16:45I

16:46I

16:48I

16:49I

16:50I

17:01I

17:02I

17:03I

17:04I

17:06I

17:08I

17:09I

17:10I

17:11I

17:12I

17:13I

17:14I

17:21I

17:22I

17:23I

17:24I

17:25I

17:26I

17:27I

17:31I

17:32I

17:33I

17:34I

17:35I

17:38I

17:43I

17:46I

17:48I

17:49I

18:03I

18:05I

18:06I

18:08I

18:09I

18:10I

18:14I

18:15I

18:20I

18:24I

18:25I

18:26I

18:46I

18:47I

18:50I

18:51I

18:52I

18:55I

19:04I

19:05I

19:06I

19:07I

19:08I

19:10I

19:11I

19:12I

19:13I

19:15I

19:16I

19:17I

19:42I

19:43I

19:45I

19:46I

19:47I

19:48I

19:50I

19:52I

19:53I

19:55I

19:56I

19:57I

19:58I

19:59I

20:00I

20:02I

20:03I

20:05I

20:06I

20:08I

20:09I

20:10I

20:11I

20:12I don't know how to take the isco hattadena and I don't know product

20:22I don't know how to buy what revenue by category I wish my

20:42So, this is our category one, right?

20:48Join, sir.

20:52It was lower or lower?

21:13How do you do this?

21:16No, I'm telling you sir,

21:18what we use in SQL,

21:22private function doesn't come.

21:25This is okay sir,

21:27the output is okay.

21:32How do we do this?

21:34Do we do it in private?

21:36Do we do it in private?

21:42Yes, we do it in private.

21:44What does the output mean?

21:44Yes, the output is in the header.

21:46The output is in the bottom of the UK.

21:49It's in the bottom of the UK.

21:51I don't know.

21:56I don't know.

21:57The output is in the inside.

21:59It's simple.

22:01Yes sir, the output is in the case.

22:08Yes sir, the output is in the case.

22:10do

22:12so

22:13how will it be?

22:18so

22:19so

22:20so

22:20it

22:22all

22:30will

22:39select some case when category is equal to elicit electronics electronics then

22:55if category is equal to have to revenue as zero as elct electronics electronics

23:22next comma this is sum category when

23:33furniture

23:34so revenue case when category is equal to zero

23:39this is only this one

23:47from sales

23:49sales

23:50sales

23:51is

23:51from Celsius

23:53up

23:54to

23:54did

23:55I

23:58I

24:02I

24:07have

24:08a

24:16in this case, if you want to use this case, you can use this case?

24:25If you want to use this case,

24:29if you want to use this case,

24:32then you want to use this case.

24:36If this case is not the case,

24:38if you want to use this case,

24:41if you want to use this case,

24:42you will use this case.

24:44If you want to use this case,

24:54then you will try to use this case.

25:03Okay, this is where he was, and this is where he was.

25:09Where is the error?

25:15Category and revenue.

25:16Okay, in case there is an interview.

25:19It happens to be done, brother.

25:26Yeah, it ends.

25:35On.

25:38From.

25:41Sales Edge.

25:43Join.

25:50join product P

25:54right now

25:57I need to call out revenue R

26:04so here we will give you

26:08PS dot revenue

26:11right now

26:14Yes sir, it is revenue and there is P.Electronics, it is P.Electronics, it is P.Electronics.

26:27Revenue is still there, REVE, revenue is still there, REVE, revenue is still there?

26:35It's wrong, REVE, REVE, REVE.

26:46Then it's possible to get it without it.

26:53It's gone and if I get it without it, it's possible to get it.

27:03It's gone, it's gone, it's gone.

27:05It's gone, it's gone.

27:08It's gone, it's gone.

27:08Sir, it's a different line.

27:12Where are the different lines?

27:16It's two cells down.

27:19So, this electronics?

27:21One and two.

27:23I'm saying that we are both in one.

27:25One first row.

27:28Okay, good.

27:31One, one.

27:35Yes, this is what I'm saying.

27:40What should I do for it?

27:44Else part, we are going to put it in total revenue.

27:48I don't know if I'm adding new.

27:50It's a different thing.

27:53So, it's different?

27:54Yes, it's different.

27:55So, what you said, what you said, we're doing here.

27:59Let's do this.

28:00Case when category is equal to electronics then some revenue.

28:06know from s dot revenue okay and here we can write in case when category is equal to furniture

28:24than sum s dot revenue else zero and okay okay okay so here we can write as ele

28:46l e and l s zero and what will happen if it happens if it happens if it happens if

29:06it happens if it happens

29:16I will leave it and leave it.

29:19Then it will not be simple.

29:23L0

29:27Edge

29:32C.A.T. category

29:37Let's see what is happening.

29:41Where is it going?

29:45This one is not working.

29:49This one is working.

29:53Where is it going?

29:56Where is it going?

29:58Where is it going?

29:59This one is working.

30:01This one is working.

30:15This one is working.

30:22It is and loss.

30:25This one is working.

30:32This one is working.

30:37This one is working.

30:39This one is working.

30:43ddd

30:52case case case case case case

30:58when

30:59there is a comma

31:02there is a comma

31:04there is a comma

31:09here is a comma

31:11else

31:12zero and

31:13and

31:16and

31:18and

31:20and

31:21and

31:23and

31:24and

31:26and

31:27I

31:28I

31:29I

31:30I

31:31I

31:32I

31:43I

31:45I

31:51I

31:53I

32:00I

32:01I

32:02I

32:05I

32:06I

32:09I

32:10I

32:12I

32:13I

32:15I

32:16I

32:18I

32:19I

32:20I

32:21I

32:22I

32:23I

32:24I

32:25I

32:26I

32:27I

32:30I

32:31I

32:32I

32:33I

32:35I

32:37I

32:38I

32:39I

32:41I

32:42I

32:43I

32:44I

32:45I

32:54I

32:55I

32:56I

32:57I

32:58I

32:59I

33:00I

33:01I

33:02I

33:06I

33:08I

33:09I

33:11I

33:12I

33:13I

33:14I

33:16I

33:17I

33:27I

33:34I

33:35I

33:36I

33:37I

33:38I

33:39I

33:40I

33:41I

33:49I

33:52I

33:53I

33:54I

33:55I

34:07I

34:08I

34:11I

34:15I

34:16I

34:17I

34:18I

34:20I

34:21I

34:27I

34:28I

34:30I

34:31I

34:33I

34:34I

34:39I

34:45I

34:46I

34:48I

34:49I

34:50I

34:51I

34:52I

34:53I

34:54I

34:55I

34:56I

34:57I

34:59I

35:00I

35:02I

35:03I

35:07I

35:08I

35:10I

35:12I

35:15I

35:16I

35:17I

35:18I

35:20I

35:22I

35:23I

35:25I

35:26I

35:27I

35:29I

35:31I

35:34I

35:35I

35:43I

35:44I

35:47I

35:48I

36:01I

36:05I

36:06I

36:15I

36:16I

36:17I

36:18I

36:19I

36:20I

36:24I

36:25I

36:29I

36:33I

36:34I

36:35I

36:39I

36:40I

36:41I

36:42I

36:44I

36:47I

36:50I

36:56I

37:00I

37:01I

37:12I

37:13I

37:14I

37:18I

37:19I

37:20I

37:29I

37:31I

37:43I

37:44I

37:46I

37:47I

37:49I

37:50I

37:52I

37:54I

37:55I

37:56I

37:57I

38:00I

38:02I

38:03I

38:08I

38:09I

38:12I

38:14I

38:15I

38:16I

38:18I

38:21I

38:22I

38:23I

38:27I

38:28I

38:30I

38:33I

38:34I

38:35I

38:36I

38:40I

38:41I

38:42I

38:43I

38:44I

38:45I

38:46I

38:47I

38:48I

38:49I

38:50I

38:51I

38:53I

38:54I

38:55I

38:56I

39:00I

39:06I

39:07I

39:08I

39:10I

39:11I

39:13I

39:15I

39:20I

39:21I

39:31I

39:35I

39:49I

39:50I

39:51I

39:54I

39:55I

39:56I

40:00I

40:01I

40:02I

40:03I

40:04I

40:05I

40:06I

40:07I

40:09I

40:10I

40:12I

40:13I

40:14I

40:17I

40:18I

40:31I

40:35I

40:36I

40:37I

40:38I

40:39I

40:40I

40:44I

40:47I

41:10I

41:11I

41:12I

41:13I

41:14I

41:15I

41:16I

41:19I

41:20I

41:22I

41:23I

41:25I

41:26I

41:28I

41:29I

41:30I

41:33I

41:34I

41:37I

41:38I

41:39I

41:41I

41:42I

41:44I

41:45I

41:55I

41:56I

42:11I

42:14I

42:19I

42:29I

42:36I

42:37I

42:39I

42:40I

42:46I

42:47I

42:53I

42:54I

42:55I

42:56I

43:17I

43:18I

43:20I

43:24I

43:25I

43:28I

43:30I

43:33I

43:34I

43:35I

43:36I

43:39I

43:40I

43:41I

43:42I

43:46I

43:47I

43:48I

43:50I

43:54I

43:55I

43:56I

43:59I

44:00I

44:01I

44:02I

44:06I

44:07I

44:08I

44:11I

44:12I

44:13I

44:14I

44:15I

44:16I

44:18I

44:19I

44:20I

44:21I

44:22I

44:23I

44:24I

44:26I

44:27I

44:37I

44:40I

44:42I

44:43I

44:44I

44:47I

44:48I

44:56I

45:00I

45:01I

45:16I

45:18I

45:19I

45:21I

45:24I

45:25I

45:26I

45:28I

45:29I

45:34I

45:35I

45:36I

45:38I

45:39I

45:40I

45:41I

45:42I

45:44I

46:05I

46:09I

46:10I

46:11I

46:14I

46:15I

46:16I

46:24I

46:25I

46:27I

46:30I

46:33I

46:35I

46:38I

46:39I

46:40I

46:47I

46:53I

46:57I

46:59I

47:02I

47:03I

47:07I

47:08I

47:09I

47:16I

47:17I

47:18I

47:29I

47:31I

47:33I

47:38I

47:40I

47:43I

47:44I

47:47I

47:49I

47:51I

47:52I

47:53I

47:55I

47:56I

47:57I

47:59I

48:00I

48:01I

48:02I

48:06I

48:14I

48:15I

48:16I

48:17I

48:18I

48:19I

48:20I

48:21I

48:22I

48:23I

48:24I

48:25I

48:27I

48:28I

48:29I

48:33I

48:43I

48:45I

48:56I

48:57I

48:58I

49:04I

49:14I

49:27I

49:28I

49:31I

49:32I

49:33I

49:35I

49:39I

49:40I

49:43I

49:47I

49:49I

49:50I

49:52I

50:02I

50:05I

50:34I don't know.

51:16What is the join?

51:18Why is the join?

51:23This is here.

51:26The skin is not happening.

51:29The skin will come.

51:31Now the joining was not happening.

51:32a tagging at

51:39again

51:45yes product mandate our tickets it did other subka pala pala data again yes

51:58select start from sales where product name

52:15product id is equal to one laptop

52:20गवंण है तो है पांच तारिक है है 5 जनवरी 25 है यूद अर हमारा रहा है

52:33क्वांच जनवरी 25 ठीक है ठीक है

52:39प्रोड़क्ट विद नौसएल ऐसा है क्या प्रोड़क्ट विद नौसएल है

52:50I am

52:53A bad bed

52:56It's come from one

53:03We will put the table of the table

53:05We will take the table

53:08We will put it in the table

53:08We will put the table

53:13What we put the table

53:20What do you want to do?

53:24Or do you want to do it?

53:27Do you want to do it?

53:33Select star from product where product ID in select product ID from sales

53:58And this product not in

54:06Not in

54:06And if you want to do it

54:21Do you want to do it?

54:23Do you want to do it?

54:27Yes

54:28Not exist

54:31And

54:34Select

54:36Select

54:37Select

54:39One from sale

54:42Just

54:44Okay

54:45Okay

54:52I

55:03I

55:04I

55:05I

55:06I

55:08I

55:15I

55:19I

55:20I

55:21I

55:22I

55:23I

55:25I

55:36I

55:38I

55:39I

55:40I

55:42I

55:43I

55:49I

55:50I

55:53I

55:57I

55:58I

56:03I

56:04I

56:05I

56:06I

56:07I

56:13I

56:14I

56:17I

56:18I

56:20I

56:21I

56:22I

56:23I

56:24I

56:25I

56:57I

56:58I

57:01I

57:04I

57:05I

57:06I

57:07I

57:09I

57:22I

57:25I

57:26I

57:29I

57:31I

57:32I

57:33I

57:35I

57:36I

57:37I

57:39I

57:40I

57:42I

57:43I

57:44I

57:46I

57:47I

57:48I

Category

Transcript

Comments

Recommended