28 Live SQL Practice Session 16 Nov 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/1_Xsdt83dPeo4ERy3syb1PhewywU-6SVL/view?usp=sharing

Transcript

00:00:00ABI and MP4BL, this is the format of the file, let's do this, let's do this,

00:00:08we are going to create a database, we are going to create database number 16,

00:00:24we are going to do that, Sanjeev, what do we do, we will go back to the photos,

00:00:31we will get the photos, we will get the photos, we will get the photos and then take them away from the 4th anniversary

00:00:45You get the photos and the photos, then the photos will be done,

00:00:50okay November 6th and we have done our office in the office 4 days

00:00:594 days

00:01:034 days before 4 days

00:01:064 days now we will go to Somangal Budhwarispat

00:01:09Okay, first we will go to 4 days

00:01:14No, it was 2 or 3 days

00:01:17I will go to the table

00:01:21I will go to the table

00:01:23I will go to the table

00:01:25T-swaps

00:01:27I will go to the table

00:01:29Record, insert

00:01:314 records

00:01:331 is the menu item

00:01:35Menu item

00:01:37Record

00:01:39People ask

00:01:43I will tell you

00:01:45I will go to the table

00:01:47Create, set menu item

00:01:49Sales

00:01:51Sales

00:01:53Sales

00:01:55Sales

00:01:57Sales

00:01:59Sales

00:02:01Sales

00:02:03Sales

00:02:05Sales

00:02:07Sales

00:02:09Sales

00:02:10Sales

00:02:11Sales

00:02:12Sales

00:02:13Sales

00:02:14Sales

00:02:15Sales

00:02:16Sales

00:02:17Sales

00:02:18Sales

00:02:19Sales

00:02:20Sales

00:02:21Sales

00:02:22Sales

00:02:23Sales

00:02:25Sales

00:02:26Sales

00:02:27Sales

00:02:28Sales

00:02:29Sales

00:02:30Sales

00:02:31Sales

00:02:32Sales

00:02:33Sales

00:02:34Sales

00:02:35Sales

00:02:36Sales

00:02:37Sales

00:02:38Sales

00:02:39Sales

00:02:40Sales

00:02:41I am

00:02:43I

00:02:45I

00:02:47I

00:02:49I

00:02:51I

00:02:53I

00:02:55I

00:02:57I

00:02:59I

00:03:01I

00:03:03I

00:03:05I

00:03:07I

00:03:09I

00:03:11I

00:03:13I

00:03:15I

00:03:17I

00:03:19I

00:03:21I

00:03:23I

00:03:25I

00:03:27I

00:03:29I

00:03:31I

00:03:33I

00:03:35I

00:03:37I

00:03:39I

00:03:41I

00:03:43I

00:03:45I

00:03:47I

00:03:49I

00:03:51I

00:03:53I

00:03:55I

00:03:57I

00:03:59I

00:04:01I

00:04:03I

00:04:05I

00:04:07I

00:04:09I

00:04:11I

00:04:13I

00:04:15I

00:04:17I

00:04:19I

00:04:21I

00:04:23I

00:04:25I

00:04:27I

00:04:29I

00:04:31I

00:04:33I

00:04:35I

00:04:37I

00:04:39I

00:04:41I

00:04:43I

00:04:45I

00:04:47I

00:04:49I

00:04:51I

00:04:53I

00:04:55I

00:04:57I

00:04:59I

00:05:01I

00:05:03I

00:05:05I

00:05:07I

00:05:09I

00:05:11I

00:05:13I

00:05:15I

00:05:17I

00:05:19I

00:05:21I

00:05:23I

00:05:25I

00:05:27I

00:05:29I

00:05:31I

00:05:33I

00:05:35I

00:05:37I

00:05:39I

00:05:41I

00:05:43I

00:05:45I

00:05:47I

00:05:49I

00:05:51I

00:05:53I

00:05:55I

00:05:57I

00:05:59I

00:06:01I

00:06:03I

00:06:05I

00:06:07I

00:06:09I

00:06:11I

00:06:13I

00:06:15I

00:06:17I

00:06:19I

00:06:21I

00:06:23I

00:06:25I

00:06:29I

00:06:31I

00:06:33I

00:06:43I

00:06:45I

00:06:47I

00:06:49I

00:06:51I

00:06:53I

00:06:57I

00:06:59I

00:07:01I

00:07:02swap id swap here I have to get this swap id here I have to get this swap id here I have to get this swap id

00:07:19here I have to get this swap id here I have to get this swap id here I have to get this swap id

00:07:40papi कुछ नहीं हो रहा है किलियर है तो रहा है और थो जोपार आज़न के लियर शौटेश सेवर्फ गैया है ढाउध दिन फूर्फ देन जोड़ में तीं टेबल होगा देको पहले हम लोग चलते हैं सेल सूब इस पर इस पर तिन है कुछ एटीक है यहां से हम आइटम आईडी

00:08:10oh so but I need to say sir I don't know so I didn't sell a review or sales rating or sales

00:08:20see him item ID nikaal Tina kiss kiss item K again next sorry so pretty nikaal there's a

00:08:27pretty nikaal there's a pretty nikaal there's a pretty to have a item item ID nikaal can

00:08:33see this thePL Roma and it's a good name all I was able to do with price mascara

00:08:43yes yes yes yes yes I do not I hey Jed over the past made

00:08:57Yes sir, you will have a swap ID? Yes sir.

00:09:06In this swap ID, you will have a swap ID? Yes sir.

00:09:16In this swap ID, you will have a swap ID.

00:09:22Yes sir, the swap is a swap.

00:09:27If you have a swap, then the swap will be difficult.

00:09:32Yes sir, the swap is a swap.

00:09:37The swap is a swap.

00:09:41The swap is a swap.

00:09:43The swap is a swap.

00:09:47Then we swap and embed the swap ID.

00:09:53The swap will be elements of the swap ID.

00:09:56So, the swap ID will be multiple.

00:09:59The swap ID will be multiple.

00:10:02Because the swap ID will be multiple.

00:10:05Okay, then the question is wrong.

00:10:09If I go to swap ID, swap ID, swap name.

00:10:17I go to menu, item ID.

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

00:10:28That's right.

00:10:30That's right.

00:10:32Then you have a question.

00:10:34No question.

00:10:36No question.

00:10:38No question.

00:10:40No question.

00:10:42This is another part.

00:10:46This is the question.

00:10:50Find review where customer used by

00:10:54amazing for self-shop in Bangalore.

00:10:58Yeah.

00:11:00Find out review.

00:11:02Where is the rating?

00:11:08Okay.

00:11:10It's rating.

00:11:12Excellent.

00:11:14No.

00:11:16Amazing.

00:11:18No.

00:11:20I am.

00:11:22Have you noticed?

00:11:26That's true.

00:11:28One.

00:11:30Yes.

00:11:31Okay, the area.

00:11:32The area is in Bangalore.

00:11:34It is not as in Bangalore.

00:11:36Yeah.

00:11:37For the shop ID, you have to have to do that.

00:11:39We have to do that for three store, shop ID, Bangalore.

00:11:42It's going to be okay.

00:11:44sorry find out where customer is the bird amazing for swap in Bangalore

00:11:51so we got swap it from here

00:11:55yes sir

00:11:57so here I will take swap it from here

00:12:02swap it from here

00:12:06I will take swap it from here

00:12:10okay now I will swap it from here

00:12:15tea soap

00:12:20and Ravi Bhai bolo boyar

00:12:24Mr Ravi

00:12:27on a sound case like you

00:12:44I don't know how busy is it okay, now T-swaps are gone, Bangalore is gone, right?

00:12:54Yes, seriously.

00:12:56It is gone.

00:12:58Swap name.

00:12:59What are you saying?

00:13:00What are you saying?

00:13:01Where customer is the bird amazing?

00:13:03Swap in Bangalore.

00:13:05Swap's name is...

00:13:07Swap's name is...

00:13:08Swap's name is...

00:13:09Swap's name is...

00:13:10Swap's name is...

00:13:11Swap's name is...

00:13:12Swap's name is...

00:13:13Swap's name is...

00:13:14Swap's name is...

00:13:15Swap's name is...

00:13:16Swap's name is...

00:13:17Swap's name is...

00:13:18Swap's name is...

00:13:19Swap's name is...

00:13:20Swap's name is...

00:13:21Swap's name is...

00:13:22Swap's name is...

00:13:23Swap's name is...

00:13:24Swap's name is...

00:13:25Swap's name is...

00:13:26Swap's name is...

00:13:27Swap's name is...

00:13:28Swap's name is...

00:13:29Swap's name is...

00:13:30Swap's name is...

00:13:31Swap's name is...

00:13:32Swap's name is...

00:13:33Swap's name is...

00:13:34Swap's name is...

00:13:35Swap's name is...

00:13:36Swap's name is...

00:13:37Swap's name is...

00:13:38Swap's name is...

00:13:41It's not coming to you, sir.

00:13:44Sir, Bangalore City, Bangalore City.

00:13:48Now, I have written it.

00:13:59So, Bangalore City, so it's state finder.

00:14:06Sir, simple, it's not coming to you, sir, select star.

00:14:09Here, select soap id.

00:14:15No, no, no, no, no.

00:14:16One second.

00:14:18What are we going to release?

00:14:22Okay, we have to release the review.

00:14:39Okay, we have to release the review.

00:14:41Okay, we have to release the review.

00:14:45Okay, we have to release the review.

00:14:46Okay, we have to release the review.

00:14:49Okay, we have to release the review.

00:14:53Okay, we have to release the review.

00:14:55I'm saying that…

00:14:58Yes, sir.

00:14:59the question in my car

00:15:02harris is the remark

00:15:05so I just want to add remark

00:15:08that the bank loan is

00:15:09correct.

00:15:11Yes sir.

00:15:12So here we have swap number

00:15:15three.

00:15:16Three in the rating

00:15:18and the bank loan is

00:15:20three.

00:15:21So let's begin

00:15:24to join

00:15:26No sir, let's do all the queries without joining.

00:15:32How will it be? Okay, tell me, how do I write?

00:15:36Sir, where you have written a select star, write a shop ID.

00:15:48And put the where condition in last.

00:15:51Where city is equal to Bangalore.

00:15:58Yes, sir.

00:16:03Okay, sir.

00:16:06Now, if you have written a review like,

00:16:12you can use the shop ID.

00:16:19You can use the shop ID.

00:16:21You can use the shop ID.

00:16:23ॐर्णी दो नीची बस पता यहां अब क्या कर ψ इसको पूरे न को पी कर ले लिए जा यह त्यु पूर

00:16:32ओर ठीक है और जो सर्वर हमने लिखा ना परसेंटेज है अमेजिंग वाले में यहाँ पर लिखी सम्ट

00:16:44ऊपर ऊपर सब

00:16:46No sir, it's on the top of the page.

00:16:51Oh brother, it's on the top of the page.

00:16:56Now write the shop ID.

00:16:59Shop ID is written first.

00:17:07Equal to and put it in the bracket.

00:17:11It's not the same.

00:17:16It's not the same.

00:17:18It's not the same.

00:17:21No, but my question is the same.

00:17:24Okay, but my question is the same.

00:17:27It's the same.

00:17:30But the store is written.

00:17:34No, it's not the same.

00:17:36Where you put the shop ID,

00:17:37there's a store.

00:17:38You can't see.

00:17:39I've got it here,

00:17:41I've got it here.

00:17:42So, I'm going to buy it here.

00:17:43Then I will buy it here.

00:17:48So, it'll be there.

00:17:49In the same place,

00:17:51I'm going to buy it here.

00:17:56I'll buy it.

00:17:58I don't know.

00:18:00Oh

00:18:02Oh

00:18:04Oh

00:18:06Oh

00:18:08Three great

00:18:10I

00:18:12I

00:18:14I

00:18:16I

00:18:18I

00:18:20I

00:18:22I

00:18:24I

00:18:26I

00:18:28I

00:18:30I

00:18:32I

00:18:34I

00:18:36I

00:18:38I

00:18:40I

00:18:42I

00:18:44I

00:18:46I

00:18:48I

00:18:50I

00:18:52I

00:18:54I

00:18:56I

00:18:58I

00:19:00I

00:19:02I

00:19:04I

00:19:06I

00:19:08I

00:19:10I

00:19:12I

00:19:14I

00:19:16I

00:19:18I

00:19:20I

00:19:22I

00:19:24I

00:19:26I

00:19:28I

00:19:30I

00:19:32I

00:19:34I

00:19:36I

00:19:38I

00:19:40I

00:19:42I

00:19:44I

00:19:46I

00:19:54I

00:19:56I

00:19:58I

00:20:00I

00:20:02I

00:20:04I

00:20:06I

00:20:08I

00:20:10I

00:20:12I

00:20:14I

00:20:16I

00:20:18I

00:20:20I

00:20:22I

00:20:24I

00:20:26I

00:20:28I

00:20:30I

00:20:32I

00:20:34I

00:20:40I

00:20:42I

00:20:44I

00:20:46I

00:20:48I

00:20:50I

00:20:52I

00:20:54I

00:20:56I

00:20:58I

00:21:00I

00:21:02I

00:21:04I

00:21:06I

00:21:08I

00:21:10I

00:21:12I

00:21:14I

00:21:16I

00:21:18I

00:21:20I

00:21:22I

00:21:24I

00:21:26I

00:21:28I

00:21:30I

00:21:32I

00:21:34I

00:21:36I

00:21:38I

00:21:40I

00:21:42I

00:21:44I

00:21:46I

00:21:48I

00:21:50I

00:21:52I

00:21:54I

00:21:56I

00:21:58I

00:22:18I

00:22:22customer name is a rating

00:22:37customer name

00:22:38so now it will be

00:22:43how is it how is it

00:22:48I am in a

00:22:55masala chal item nika layer one ticket

00:23:01sir I will have kaha jau rating my job

00:23:05I am a rare rating man so by the way it's a question in Galata Raka

00:23:13so it's a question when the link are in the room to you say yeah baby

00:23:19yeah rating the upper item ID by any changes it is again here

00:23:25customer name, customer ID, shop ID, item ID, and here on item ID.

00:23:40So, I sell ID, item ID, item ID, something that ever looks like, one table is missing, is it?

00:24:01If swap ID, swap ID, then swap ID.

00:24:07But, with the rating we have not already given that item ID, we can give it to the store.

00:24:18It is, the shop, it has been given it, it has given, so, best, best, best of the best of the best,

00:24:28I can also have access to the store.

00:24:30Reviews, look at the shop.

00:24:32I'd like to use the review, please make sure to like this.

00:24:38If you have an additional review of the review,

00:24:47it's a great review of the review of the review.

00:24:51It's a great review of the review of the review.

00:24:56nice

00:24:58masala chai

00:25:00chai

00:25:02chai

00:25:04amazing

00:25:06so

00:25:08if I go to menu

00:25:10masala chai

00:25:12chai

00:25:14let's go

00:25:16now

00:25:18question

00:25:20something

00:25:22wrong

00:25:24one

00:25:26one

00:25:28one

00:25:38tea shop

00:25:40item

00:25:42sales rating

00:25:44no

00:25:46one

00:25:48one

00:25:50one

00:25:52one

00:25:54one

00:25:56one

00:25:58one

00:26:00one

00:26:02one

00:26:04one

00:26:06one

00:26:08one

00:26:10one

00:26:12one

00:26:14one

00:26:16one

00:26:18one

00:26:20one

00:26:22one

00:26:24one

00:26:26one

00:26:28one

00:26:30two

00:26:32one

00:26:34two

00:26:36three

00:26:38two

00:26:40two

00:26:42three

00:26:44two

00:26:46three

00:26:48two

00:26:50two

00:26:52two

00:26:54two

00:26:56two

00:26:58two

00:27:00two

00:27:02two

00:27:04two

00:27:06two

00:27:08two

00:27:10two

00:27:12two

00:27:14two

00:27:16two

00:27:18two

00:27:20two

00:27:22two

00:27:24three

00:27:26two

00:27:28two

00:27:30two

00:27:32three

00:27:34two

00:27:36two

00:27:38two

00:27:40two

00:27:42two

00:27:44two

00:27:46three

00:27:48two

00:27:50two

00:27:52three

00:27:54two

00:27:56two

00:27:58two

00:28:00three

00:28:02two

00:28:04three

00:28:06two

00:28:08three

00:28:10three

00:28:12three

00:28:14three

00:28:16three

00:28:18three

00:28:20three

00:28:22two

00:28:24three

00:28:30three

00:28:32three

00:28:34four

00:28:36three

00:28:38I will add menu item to the menu item.

00:28:43Now I will add join menu item item.

00:28:50It is in sales item ID.

00:28:55What is the rating?

00:28:58The rating is swap ID.

00:29:01No, it is swap ID.

00:29:04It is swap ID.

00:29:07Now I have said to join the item.

00:29:12What are we still staying?

00:29:15Sales ID.

00:29:21In menu item item,

00:29:24Here is swap ID.

00:29:29Here is swap ID.

00:29:32Okay, here I put it here, join, which is simple, join, sales, join, sales, s, no, no,

00:29:53Okay

00:30:01Okay

00:30:02Okay

00:30:04Okay

00:30:05Okay

00:30:06Okay

00:30:07Okay

00:30:08Join

00:30:09Sales

00:30:10S

00:30:11On

00:30:13S.

00:30:14Item

00:30:16ID is equal to

00:30:18Who is this?

00:30:20Masala Chael Kiska R

00:30:22No

00:30:26No

00:30:27Item

00:30:28M

00:30:29Dot

00:30:31Item

00:30:33Item

00:30:38Item

00:30:39Item

00:30:40Item

00:30:41Item

00:30:42Item

00:30:43Item

00:30:44Item

00:30:45Item

00:30:46Item

00:30:49Sales

00:30:55To

00:30:56Reference

00:30:57Item

00:30:58Item

00:30:59Question

00:31:00To

00:31:01Chaos

00:31:01Item

00:31:02Item

00:31:03Item

00:31:04we need

00:31:05store

00:31:07Item

00:31:08Item

00:31:09item

00:31:10Map

00:31:11Amb

00:31:12We need

00:31:13Swap

00:31:14intérieur

00:31:15oka

00:31:16Aid

00:31:16Hey, shop ID.

00:31:17Our services are left for the item ID.

00:31:22It is like shop ID.

00:31:24We don't have shop ID.

00:31:27We don't have shop ID.

00:31:30We don't have shop ID.

00:31:32We don't have shop ID.

00:31:37so by the hundred the soap I didn't know we are one one a bun of a rating a rating

00:31:54we have soap ID one so if I do want to be happy I got to my school for a

00:32:05record to remove the sign of the sign of the sign of the sign of the sign of the sign

00:32:21why you think it is that the case of it is a teacher class teacher and

00:32:29tomorrow to believe it's a join join

00:32:31yeah

00:32:33yes

00:32:35rating

00:32:37R

00:32:39R

00:32:41rating R

00:32:43R

00:32:45on

00:32:47on

00:32:49on

00:32:51R

00:32:53I don't know who is, I don't know who is, who is, sir?

00:32:58s.shopid

00:33:00who is, s.shopid

00:33:05equal to r.shopid

00:33:13That is right, now

00:33:16if we are here

00:33:19customer name

00:33:25customer name

00:33:27so this is so much

00:33:31and if we have one thing here

00:33:35what is review

00:33:39if we put review

00:33:41then we will all go

00:33:43but we need

00:33:45masala chai

00:33:47here I am

00:33:49review

00:33:51like

00:33:53masala chai

00:33:59good

00:34:01sorry

00:34:07now

00:34:09I

00:34:11I

00:34:13I

00:34:15I

00:34:17I

00:34:19I

00:34:21I

00:34:23I

00:34:25I

00:34:27I

00:34:29I

00:34:31I

00:34:33I

00:34:35I

00:34:37I

00:34:39I

00:34:41I

00:34:43I

00:34:45I

00:34:47I

00:34:49I

00:34:51I

00:34:53I

00:34:55I

00:34:57I

00:34:59I

00:35:01I

00:35:03I

00:35:05I

00:35:07I

00:35:09I

00:35:11I

00:35:13I

00:35:15I

00:35:17I

00:35:19I

00:35:21I

00:35:23I

00:35:25I

00:35:27I

00:35:29I

00:35:31I

00:35:33I

00:35:35I

00:35:37I

00:35:39I

00:35:41I

00:35:43I

00:35:45I

00:35:47I

00:35:49I

00:35:51I

00:35:53I

00:35:55I

00:35:57I

00:35:59I

00:36:01I

00:36:03I

00:36:05I

00:36:07I

00:36:09I

00:36:11I

00:36:13I

00:36:15I

00:36:17I

00:36:19I

00:36:21I

00:36:23I

00:36:25I

00:36:27I

00:36:29I

00:36:31I

00:36:33I

00:36:35I

00:36:37I

00:36:39I

00:36:41I

00:36:43I

00:36:45I

00:36:47I

00:36:49I

00:36:51I

00:36:53I

00:36:55I

00:36:57I

00:36:59I

00:37:01I

00:37:03I

00:37:05I

00:37:07I

00:37:09I

00:37:11I

00:37:13I

00:37:15I

00:37:17I

00:37:19I

00:37:21I

00:37:23I

00:37:25I

00:37:27I

00:37:29I

00:37:31I

00:37:33I

00:37:35I

00:37:37I

00:37:39I

00:37:41I

00:37:43I

00:37:45I

00:37:47I

00:37:49I

00:37:51I

00:37:53I

00:37:55I

00:37:57I

00:37:59I

00:38:01I

00:38:03I

00:38:05I

00:38:07I

00:38:09I

00:38:11I

00:38:13I

00:38:15I

00:38:17I

00:38:19I

00:38:21I

00:38:23I

00:38:25I

00:38:27I

00:38:29I

00:38:31I

00:38:33I

00:38:35I

00:38:37I

00:38:39I

00:38:41I

00:38:43I

00:38:45I

00:38:47I

00:38:49I

00:38:51I

00:38:53I

00:38:55I

00:38:57I

00:38:59I

00:39:01I

00:39:03I

00:39:05I

00:39:07I

00:39:09I

00:39:11I

00:39:13I

00:39:15I

00:39:17I

00:39:19I

00:39:21I

00:39:23I

00:39:25I

00:39:27I

00:39:29I

00:39:31I

00:39:33I

00:39:35I

00:39:37I

00:39:39I

00:39:41I

00:39:43I

00:39:45I

00:39:47I

00:39:49I

00:39:51I

00:39:53I

00:39:55I

00:39:57I

00:39:59I

00:40:01I

00:40:03I

00:40:05I

00:40:07I

00:40:09I

00:40:11I

00:40:13I

00:40:15I

00:40:17I

00:40:19I

00:40:21I

00:40:23I

00:40:25I

00:40:27I

00:40:29I

00:40:31I

00:40:33I

00:40:35I

00:40:37I

00:40:39I

00:40:41I

00:40:43I

00:40:45I

00:40:47I

00:40:49I

00:40:51I

00:40:53I

00:40:55I

00:40:57I

00:40:59I

00:41:01I

00:41:03I

00:41:05I

00:41:07I

00:41:09I

00:41:11I

00:41:13I

00:41:15I

00:41:17I

00:41:19I

00:41:21I

00:41:23I

00:41:25I

00:41:27I

00:41:29I

00:41:31I

00:41:33I

00:41:35I

00:41:37I

00:41:39I

00:41:41I

00:41:43I

00:41:45I

00:41:47I

00:41:49I

00:41:51I

00:41:53I

00:41:55I

00:41:57I

00:41:59I

00:42:01I

00:42:03I

00:42:05I

00:42:07I

00:42:09I

00:42:11I

00:42:13I

00:42:15I

00:42:17I

00:42:19I

00:42:21I

00:42:23I

00:42:25I

00:42:27I

00:42:29I

00:42:31I

00:42:33I

00:42:35I

00:42:37I

00:42:39I

00:42:41I

00:42:43I

00:42:45I

00:42:47I

00:42:49I

00:42:55I

00:42:56I

00:42:58I

00:43:00I

00:43:02I

00:43:04I

00:43:06I

00:43:08I

00:43:10I

00:43:12I

00:43:14I

00:43:16I

00:43:18I

00:43:20I

00:43:22I

00:43:24I

00:43:26I

00:43:30I

00:43:32I

00:43:34I

00:43:36I

00:43:38I

00:43:40I

00:43:42I

00:43:44I

00:43:46I

00:43:48I

00:43:50I

00:43:52I

00:43:54I

00:43:56I

00:43:58I

00:44:00I

00:44:02I

00:44:04I

00:44:06I

00:44:08I

00:44:10I

00:44:12I

00:44:14I

00:44:16I

00:44:18I

00:44:20I

00:44:22I

00:44:24I

00:44:26I

00:44:28I

00:44:30I

00:44:32I

00:44:34I

00:44:36I

00:44:38I

00:44:40I

00:44:42I

00:44:44I

00:44:46I

00:44:48I

00:44:50I

00:44:52I

00:44:54I

00:44:56I

00:44:58I

00:45:00I

00:45:02I

00:45:04I

00:45:06I

00:45:08I

00:45:10I

00:45:12I

00:45:14I

00:45:16I

00:45:18I

00:45:20I

00:45:22I

00:45:24I

00:45:26I

00:45:28I

00:45:30I

00:45:32I

00:45:34I

00:45:36I

00:45:38I

00:45:40I

00:45:42I

00:45:44I

00:45:46I

00:45:48I

00:45:50I

00:45:52I

00:45:54I

00:45:56I

00:45:58I

00:46:00I

00:46:02I

00:46:04I

00:46:06I

00:46:08I

00:46:10I

00:46:12I

00:46:14I

00:46:16I

00:46:18I

00:46:20I

00:46:22I

00:46:24I

00:46:26I

00:46:28I

00:46:30I

00:46:32I

00:46:34I

00:46:36I

00:46:38I

00:46:40I

00:46:42I

00:46:44I

00:46:46I

00:46:48I

00:46:50I

00:46:52I

00:46:54I

00:46:56I

00:46:58I

00:47:00I

00:47:02I

00:47:04I

00:47:06I

00:47:08I

00:47:10I

00:47:12I

00:47:14I

00:47:16I

00:47:18I

00:47:20I

00:47:22I

00:47:24I

00:47:26I

00:47:28I

00:47:30I

00:47:32I

00:47:34I

00:47:36I

00:47:38I

00:47:40I

00:47:42I

00:47:44I

00:47:46I

00:47:48I

00:47:50I

00:47:52I

00:47:54I

00:47:56I

00:47:58I

00:48:00I

00:48:02I

00:48:04I

00:48:06I

00:48:08I

00:48:10I

00:48:12I

00:48:14I

00:48:16I

00:48:18I

00:48:23I

00:48:242

00:48:263

00:48:30I

00:48:32I

00:48:46I can see this salary is less than $11,000 and the $103,000 is less than $9,000.

00:49:02Where did you see it? I have to add this to it.

00:49:09write a query to display the name first name last time sell the department ID job ID for

00:49:18those imply who working in same day designation as imply work in 169 like what she's a milt

00:49:27a joltar and a me a question the bus was once a shi lanky designation a call to on a chance last name

00:49:39salary is a bit are a department ID have department department department ID job ID

00:49:46a job ID from implies or salary

00:49:54kya kya sardin nation of the g the designation

00:49:58kaha a donation to any service man

00:50:04okay

00:50:05yeah

00:50:06yeah

00:50:07yeah

00:50:17a boy you got a job I really like the department ID Department name

00:50:25job ID here in the corner

00:50:28yeah

00:50:30job

00:50:31job

00:50:32where

00:50:40job id equal to

00:50:46job id equal to

00:50:52salary

00:50:56job id

00:50:58employee id

00:51:00job id 169

00:51:10ah ah ah ah something got wrong

00:51:18an ad

00:51:22i'm a logonic huma cover work here

00:51:24I am

00:51:27yeah

00:51:30I select job ID

00:51:34I am trying to apply ID 169

00:51:39I am 169

00:51:43It is a good

00:51:45It is a good

00:51:46It is a good

00:51:48It is a good

00:51:50I'm gonna go 139.

00:51:53I will do it.

00:51:54Yes, sir.

00:51:55It's gone.

00:51:57It's a color.

00:51:57Okay.

00:52:04Let's see this.

00:52:11Write a query to display name, first name, last name, salary department for those

00:52:17imply who earn such amount of salary which is a smallest salary of any of the

00:52:24Department it was a real way

00:52:35case of a guy

00:52:38it's not supposed to be not here is master salary any of the department

00:52:45ha ha ha write a query to display the first name last name salary department for

00:52:54doge imply unsari imply care Joe on the car has such amount of salary which is a

00:53:00smallest salary of any of department receive the department to me

00:53:04beth potash customer 4--karat-m scholarship

00:53:09which earn no

00:53:11order to apply to earn such amount of salary

00:53:13which is a smallest salary

00:53:14Joe कि Wow

00:53:17department में सबसे छोटा salary है

00:53:20अपशी के आस्पास होना चाहिए

00:53:24तो यह तो सब सबसे स्मॉल्स से लीसे ग्रेटर देन होगे सारा और

00:53:28शॉर्स दीटा आया फुर को

00:53:29क्या कर रहे

00:53:33if it's not gonna be any of the department KCB department say you come sell you say

00:53:40your mother after job on a chase was good on us on an end

00:53:44is that a colleague Raha KCB department says dip KCB car I are not such amount salary which is

00:53:54a smallest salary of any department KCB department committed come salary

00:53:59have us KB rava justice discuss salary hair was gone but such some are yes the

00:54:11was it right a curie to display the first and last time for I apply who are not such

00:54:17amount of salary which is the smallest salary of any

00:54:29I'm

00:54:36I'm

00:54:38I'm

00:54:40I'm

00:54:42I'm

00:54:44I'm

00:54:51I'm

00:54:53I'm

00:54:57I'm

00:54:59I'm

00:55:01Jee

00:55:06Jee

00:55:11Is

00:55:13a

00:55:15a

00:55:16a

00:55:17a

00:55:26a

00:55:27a

00:55:29Department was compared to between which the salary is equal.

00:55:36So,

00:55:40the department smallest salary is

00:55:49selected.

00:55:51salary foreign imply group by department i.e.s a group by department i.e.s a group by department i.e.s a salary

00:56:09when i.e.s a female this is a minimum salary

00:56:23it is sub sub department of department i.e.s a group of department i.e.s a group of department id

00:56:35So it is a kind of a

00:56:36So it is like this

00:56:38It is like this

00:56:39Yes sir

00:56:40Yes sir

00:56:45You can compare all data

00:56:47We can do this

00:56:48We will not do this

00:56:50We will go to department

00:56:53This is the minimum salary

00:56:56As

00:57:01Minimum salary

00:57:04I will write this here.

00:57:08Select the first name.

00:57:14Select the first name.

00:57:22First name.

00:57:26Leave it and leave it.

00:57:30First name.

00:57:32first name

00:57:34first name last name

00:57:36salary

00:57:38this is our

00:57:40comparison

00:57:42then

00:57:44then

00:57:46we

00:57:48select

00:57:50that

00:57:52select

00:57:56star

00:57:58change

00:58:00from

00:58:02employees

00:58:04where

00:58:06salary

00:58:08in

00:58:10in

00:58:12in

00:58:14in

00:58:16in

00:58:18department

00:58:20id

00:58:22where

00:58:24department

00:58:26id

00:58:28okay

00:58:30i

00:58:32i

00:58:34i

00:58:36i

00:58:38i

00:58:40i

00:58:42i

00:58:44i

00:58:46i

00:58:48i

00:58:50i

00:58:52i

00:58:54i

00:58:56i

00:58:58i

00:59:00i

00:59:02i

00:59:04i

00:59:06i

00:59:08i

00:59:10i

00:59:12i

00:59:14i

00:59:16i

00:59:18write a query to display the imply id imply name first name last name for all imply who earn more than average salary

00:59:26i

00:59:28i

00:59:30i

00:59:32i

00:59:34i

00:59:36i

00:59:38i

00:59:40i

00:59:42i

00:59:44i

00:59:46i

00:59:48i

00:59:50i

00:59:52i

00:59:54i

00:59:56i

00:59:58i

01:00:00i

01:00:02i

01:00:04i

01:00:06i

01:00:08i

01:00:10i

01:00:12i

01:00:14i

01:00:16i

01:00:18i

01:00:20i

01:00:22i

01:00:24i

01:00:26i

01:00:28i

01:00:30i

01:00:32i

01:00:34i

01:00:36i

01:00:38i

01:00:40i

01:00:42i

01:00:44i

01:00:46i

01:00:48i

01:00:50i

01:00:52i

01:00:54i

01:00:56i

01:00:58i

01:01:00i

01:01:02i

01:01:04i

01:01:06i

01:01:28i

01:01:30i

01:01:31I am

01:01:37Yeah, I am is by I'm come boss conher manager I didn't

01:01:43Nikola for a gun it's over. Yeah, and I'm ex over lab and they can now Monika la prega

01:01:49Yes, sir, I say no go

01:01:54To

01:01:56I'm sorry I need a question I take a question but I'm asking him but I'm

01:02:04yeah

01:02:12apply first name last name imply ID and resale of imply who report to PM.

01:02:18Okay.

01:02:19So I have here PM's employee ID is removed.

01:02:25Sir.

01:02:26Is it 120?

01:02:27Yes.

01:02:28Yes.

01:02:29Yes sir.

01:02:30And here, select star from imply.

01:02:34And here, manager ID is 1202.

01:02:37Yes sir.

01:02:40Yes sir.

01:02:41Manager ID is called true.

01:02:47Yes.

01:02:49Yes sir.

01:02:51Where did you put?

01:02:52Where did you put it?

01:02:53Employees.

01:02:59Yes sir.

01:03:00Yes sir.

01:03:03Yes sir.

01:03:04Yes sir.

01:03:05Yes sir.

01:03:06If manager name is called,

01:03:07So, we need to make this first name, last name, imply ID, and salary.

01:03:33So, we need to make this first name.

01:03:39So, we need to make this first name.

01:03:48So, we need to make this first name.

01:03:53So, we need to make this first name.

01:04:00So, we need to make this first name.

01:04:05So, we need to make this first name.

01:04:09So, we need to make this first name.

01:04:19So, we need to make this first name.

01:04:24So, we need to make this first name.

01:04:40So, we need to make this first name.

Category

Transcript

Be the first to comment

Recommended