- 4 months ago
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
Microsoft Excel Course: Advanced Excel Training
https://www.udemy.com/course/microsoft-excel-excel-from-beginner-to-advanced-m/?couponCode=FC0D30F148B3045E6E59
Whatsapp Group Link- https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
SQL Script file : -
https://drive.google.com/file/d/1_Xsdt83dPeo4ERy3syb1PhewywU-6SVL/view?usp=sharing
Microsoft Excel Course: Advanced Excel Training
https://www.udemy.com/course/microsoft-excel-excel-from-beginner-to-advanced-m/?couponCode=FC0D30F148B3045E6E59
Category
📚
LearningTranscript
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: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: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.
Comments