- 9 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/1tpYCGZmuQXTHeD7tC_km2bJI4Q2DFcqM/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/1tpYCGZmuQXTHeD7tC_km2bJI4Q2DFcqM/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:00So, it's coming to the screen.
00:00:04We need to create one table.
00:00:12Create database.
00:00:16Why is this showing?
00:00:20Create database.
00:00:24December 2018, 2025
00:00:28Use
00:00:34Use
00:00:36A gaya.
00:00:42It's the implied name of a table.
00:00:46Insert Jora
00:00:50Department
00:00:52We have two tables.
00:01:02Select this one.
00:01:06And this one.
00:01:08And this one is
00:01:10Department.
00:01:12Select a star from DEPT
00:01:16Okay.
00:01:18Two tables.
00:01:20Now,
00:01:22Why is this window
00:01:24Why are they showing this window?
00:01:26Let's go.
00:01:28This one.
00:01:30This is
00:01:32Display
00:01:36Implied name
00:01:38whose total earning
00:01:42salary
00:01:44commission is greater than
00:01:46average earning of the company
00:01:48of the company.
00:01:50Tell me.
00:01:52Tell me.
00:01:54Tell me.
00:01:56Tell me.
00:01:58Tell me.
00:02:00Sajja
00:02:01Sanjeev
00:02:03When you ask.
00:02:05Tell me.
00:02:06Sir,
00:02:07Question.
00:02:08You can pick it.
00:02:10It's a question.
00:02:12Confusion би
00:02:13a major question to simple
00:02:14display employee name
00:02:21total learning salary plus commission
00:02:24are greater than average earnings
00:02:26only take a sir
00:02:27is my
00:02:29link is a select
00:02:31star
00:02:37from
00:02:40EMP
00:02:41or
00:02:44where
00:02:47sell plus commission
00:02:54commission
00:02:58के लिए सरा में वो नल डाल को रिप्लेश का आगाना सर्स
00:03:00तो सब डाल दीजिए सर्वान
00:03:05अचल अचल प्लस इसनल करके आगा क्या है इसनल या कॉलेश कौन सा तर ठीक है
00:03:18No sir, it's wrong.
00:03:23What?
00:03:24We have to do that when you null is zero.
00:03:27Yes.
00:03:28Is null function doesn't exist.
00:03:31No, no.
00:03:33It's not.
00:03:34It's not.
00:03:35It's not.
00:03:36It's not.
00:03:37It's not.
00:03:38It's not.
00:03:39It's not.
00:03:40It's not.
00:03:41It's not.
00:03:43It's not.
00:03:45Okay, I think.
00:03:46Yes.
00:03:47It's verified.
00:03:48We've got aową.
00:03:49Now bring c80 what's got
00:03:52you?
00:03:54Right?
00:03:55You.
00:03:56Right?
00:03:57It was the correct
00:04:00rush for dinner.
00:04:01Right?
00:04:02You looked for dinner.
00:04:03You looked for dinner,
00:04:06you looked after dinner.
00:04:08Hey,
00:04:09Oh,
00:04:10and I'm going to copy it.
00:04:17I put it in English.
00:04:20I got two brackets.
00:04:23From EMP.
00:04:27But I'm asking the name.
00:04:34So, what was this average salary?
00:04:4024-7, 24-7.
00:04:4524-4-7, okay.
00:04:50Is it going to go?
00:04:5324-7, okay sir.
00:04:562850, 2450.
00:04:59Where is it?
00:05:0224-7, okay.
00:05:05Okay, okay.
00:05:06Okay, okay.
00:05:07So, here we need the name.
00:05:09E-name.
00:05:12Okay.
00:05:22Display the name of the employee who earned commission.
00:05:29Who earned commission.
00:05:34So, sir, see me now.
00:05:38Where is it?
00:05:40Commission is not null.
00:05:49Do you have two people?
00:05:51Do you have two people?
00:05:54Do you have two people?
00:05:56Yeah.
00:06:10On.
00:06:11were display the name of imply whose salary is same as the lowest salary in their department
00:06:24will call the group by the men who shall be seen as Louis selling in their department
00:06:45sorry smell pellet group it's a whole about you sir group by small salary
00:06:57nicole jim so dip department name yet it's an alarm before the end of our
00:07:04deep it's a select dpt and no dpt a chacha sorry in their department name
00:07:16department to either be henna department code heading up it
00:07:22also see click around dpt and dalinger select dpt and no start at a video dpt and
00:07:29no or sir comma
00:07:36profit dpt and then min the answer function mean
00:07:44instead of cell or last measure group by dpt and no group by dpt and no
00:07:57But yes, you know, I
00:08:07know, I have a
00:08:09car is kind of
00:08:10justice and I am
00:08:11not at all.
00:08:12We have in minimum
00:08:13cell and learned
00:08:15with a
00:08:16and then it turned out to be a good one.
00:08:30It's gone.
00:08:32It's gone.
00:08:37Take care.
00:08:46display the
00:08:48is
00:08:50this question complete new water
00:08:56ito no no no no no no no no no no no no no no no no no no no no no no no no no no no
00:09:03salaries same to fill e-m-p
00:09:05e-e-m-k-t-e
00:09:09is
00:09:11not
00:09:13no
00:09:15no
00:09:17no
00:09:19no
00:09:21no
00:09:23no
00:09:25no
00:09:27no
00:09:29no
00:09:31no
00:09:33no
00:09:35no
00:09:37no
00:09:39no
00:09:41no
00:09:43no
00:09:45no
00:09:47no
00:09:49no
00:09:51no
00:09:53no
00:10:01no
00:10:03no
00:10:05is
00:10:09is
00:10:11we
00:10:13need
00:10:15to
00:10:17to
00:10:19to
00:10:21to
00:10:23to
00:10:25to
00:10:27to
00:10:29to
00:10:31Do you need to make a joint in two ways?
00:10:39Then it will be done, sir?
00:10:42I'll put a joint in two ways.
00:10:44Then it will be done.
00:10:48I'm going to do the joint with the joint.
00:10:54We will give the joint condition that the department numbers match?
00:10:59I don't know that I was a sub subcuree say ho jayega
00:11:05oh my subcuree say b2o ho sakta halikin
00:11:10oh subcuree exist karke aap ne patahata exist karke yaadena ko bina exist wala
00:11:16bhi ho jayega tikka subcuree abhi kaisi laga raha ho subcuree tum batao
00:11:23i exist wala kata sir ma exist wala se huwa your ziya phir ham phir us
00:11:27mein jayenge aapka join join se bho da city se bho ga chahe agar mai aise liko select e name
00:11:40a sali nikaloi hapikin select e name chal kar dita sali is a sali
00:11:46a sali nikaloi hapikin
00:11:53dvta mpn
00:11:56e mpn where salary koo sir sali
00:12:03salary is equal to
00:12:05chile si
00:12:27you can select
00:12:30means early
00:12:31where dpt
00:12:34no sorry
00:12:35this go
00:12:37emp ke kuch
00:12:39or namp
00:12:40chai ya haan per
00:12:42lickhe dpt
00:12:43select
00:12:46means early
00:12:47from emp
00:12:48where dpt
00:12:51no
00:12:53is equal to
00:12:54e dot
00:12:57dpt
00:12:58no
00:13:00site
00:13:01e had
00:13:03desk 130
00:13:0420
00:13:05800
00:13:06and
00:13:0630
00:13:0712
00:13:0750
00:13:08a
00:13:09a
00:13:10a
00:13:10a
00:13:10a
00:13:10a
00:13:10a
00:13:14a
00:13:15a
00:13:17a
00:13:17a
00:13:18a
00:13:18a
00:13:19a
00:13:20a
00:13:21a
00:13:22a
00:13:23a
00:13:24a
00:13:25a
00:13:26a
00:13:27a
00:13:28a
00:13:29a
00:13:30a
00:13:31a
00:13:32a
00:13:33a
00:13:34a
00:13:35a
00:13:36a
00:13:37a
00:13:38a
00:13:39a
00:13:40a
00:13:41a
00:13:42a
00:13:43a
00:13:44a
00:13:45a
00:13:46a
00:13:47a
00:13:48a
00:13:49a
00:13:51a
00:13:52a
00:13:55foreign
00:14:10foreign
00:14:16foreign
00:14:20foreign
00:14:22foreign
00:14:24You have to give this, right?
00:14:27No.
00:14:28Let me tell you, sir.
00:14:30Select star from
00:14:37EMP
00:14:39and EDA
00:14:41Abbreviation
00:14:43Then go down, join as
00:14:47EMP
00:14:52EMP
00:14:55Yeah, then PP
00:14:57No, sir.
00:14:59This table
00:15:00PP
00:15:01This table
00:15:02PP
00:15:03As a PP
00:15:04Yeah, sir.
00:15:06EMP
00:15:08What?
00:15:09Join
00:15:10As a PP
00:15:14As a PP
00:15:17As a PP
00:15:18As a PP
00:15:19As a PP
00:15:20As a PP
00:15:21A
00:15:23A
00:15:24As a PP
00:15:25After
00:15:26DPP
00:15:27EMP
00:15:28And
00:15:29I will
00:15:30remove
00:15:31select
00:15:32It
00:15:33did
00:15:34select course start
00:15:35bracket or dptn
00:15:37now
00:15:37on
00:15:43e dot
00:15:45dptn
00:15:48equal to
00:15:53p
00:15:55dptn
00:15:56now
00:15:56sir
00:15:58and
00:15:59now
00:16:00you are being
00:16:05I say
00:16:05e dot
00:16:06ld
00:16:07e dot
00:16:07cell
00:16:09I think
00:16:10what is it
00:16:10equal to
00:16:18pp dot
00:16:20lowest
00:16:21lowest
00:16:22lowest
00:16:23lowest
00:16:24ld
00:16:30Is it a house or you're up or wallace or the other
00:16:35party
00:16:36I'm
00:16:38a
00:16:39I'm
00:16:41I'm
00:16:42a
00:16:43a
00:16:45a
00:16:46a
00:16:47a
00:16:48a
00:16:49a
00:16:50a
00:16:51a
00:16:52a
00:16:53a
00:16:55a
00:16:57a
00:16:58a
00:16:59and now application I will be RR
00:17:04I have a Miller Smith Ward
00:17:11a Miller Smith Ward other so here I have a sub-nate a name
00:17:16or sell
00:17:19dptn
00:17:22what's that e.dptn no cardo confused or words here
00:17:30a figure
00:17:35other
00:17:38a table
00:17:41and join
00:17:48join
00:17:49your
00:17:51manager
00:17:53to learn
00:17:54learn
00:17:56learn
00:17:57learn
00:17:58learn
00:17:59learn
00:18:02learn
00:18:04learn
00:18:06learn
00:18:07learn
00:18:09learn
00:18:10will go?
00:18:12Yes, sir, the concept is very dangerous.
00:18:16Mr. Rakesh has told us that we need to do something.
00:18:20I need to do something like this.
00:18:22I need to do something like this.
00:18:24I need to do something like this.
00:18:26When I learn it, it will go.
00:18:30Yes.
00:18:32Yes.
00:18:40Is this the question?
00:18:42Yes.
00:18:44Did the employees need to join on the 10th of any month?
00:18:51No problem.
00:18:53Is there anyone?
00:18:54No problem.
00:18:58No problem.
00:19:00No problem.
00:19:02No problem.
00:19:04No problem.
00:19:06No problem.
00:19:08No problem.
00:19:09I need to do 10th.
00:19:1010th.
00:19:1110th.
00:19:1210th.
00:19:13I will do 23rd.
00:19:16Did someone get a 17th?
00:19:2117th.
00:19:22I will do 17th.
00:19:25I will do 17th.
00:19:2817th.
00:19:30I will do 17th.
00:19:35this is simply this is from
00:19:41oh sorry we are selected function d a y day
00:19:49oh or lock it is equal to 17
00:19:57oh
00:20:05display the name of imply who have not joined in at t1
00:20:18we have not joined
00:20:48I am not sure if you have one, then you can do it, sir, you can do it, sir, you can do it,
00:21:00not, not equal to do it, yes, sir, it will be, yes, sir, it will be, yes, sir, it will be two,
00:21:18display the names of imply who are not color and whose salary is not more than three thousand,
00:21:35so, here, two things, sir, it will be, yes, sir, it will be, yes, sir, it will be, yes, sir,
00:21:44color, where, where, job,
00:21:54not equal to,
00:21:56color,
00:21:59apostrophe,
00:22:00clerk,
00:22:01and,
00:22:04SL,
00:22:07less than, not more than,
00:22:13less than equal to,
00:22:163,000,
00:22:18and,
00:22:20what,
00:22:20what,
00:22:21what,
00:22:22how,
00:22:22because,
00:22:22more than,
00:22:23and,
00:22:24well,
00:22:26and,
00:22:27yes,
00:22:29the,
00:22:31yes,
00:22:33and,
00:22:34yes,
00:22:36yes,
00:22:38please,
00:22:40the,
00:22:41apply who have not,
00:22:43I joined in the month of December but
00:22:54offer you a mercy little dinosaur month
00:22:58function month bracket is start hired it
00:23:05I'm not equal to 10 oh 12
00:23:17December 4th about this
00:23:27display the imply who do not have do not
00:23:32add any commission
00:23:42we are commission
00:23:51is not also citizen haha we say hello
00:23:55The mission is not passed.
00:23:59Okay.
00:24:01Okay.
00:24:03Ha.
00:24:05Hmm.
00:24:07Hmm.
00:24:09Hmm.
00:24:11Hmm.
00:24:13Hmm.
00:24:15Hmm.
00:24:19Let's play the name of the driver.
00:24:23Hmm.
00:24:25Hmm.
00:24:27Hmm.
00:24:29Yeah.
00:24:31Yeah.
00:24:33Hmm.
00:24:35Hmm.
00:24:37More than minimum salary.
00:24:39The department.
00:24:41So, the upper data equal to.
00:24:43Okay.
00:24:45Okay.
00:24:47Yeah.
00:24:49Yeah.
00:24:51is not equal to sell me who have not equal not equal to more than
00:25:01is not equal to.
00:25:03How will it not equal to?
00:25:05Because we have left the last name
00:25:07and if we have not equal to
00:25:09it will be more than you will
00:25:11take it.
00:25:13If it will be like this
00:25:15it will be like this.
00:25:17Then we will take it
00:25:19and then we will take it
00:25:21and then we will take it
00:25:23and then
00:25:25we will take it
00:25:27and then
00:25:29we will take it
00:25:31and then we will take it
00:25:33and then
00:25:35you will take it
00:25:37and then
00:25:39you will take it
00:25:41and then
00:25:45there are
00:25:47the same
00:25:49black
00:25:51the
00:25:53same
00:25:55the
00:25:57same to her
00:25:57the last city
00:26:14makes coming
00:26:16city is
00:26:23select star from EMP
00:26:28select star from DPT
00:26:34city
00:26:38city
00:26:40display the name of imply
00:26:48who work in department located in Chicago or Dallas
00:26:54Chicago or Dallas
00:26:57department number 20 or 30
00:27:00yes sir
00:27:03what do you want to show all the data?
00:27:15name of imply
00:27:17name of imply
00:27:19name of imply
00:27:21okay sir
00:27:23select e-name
00:27:27from EMP
00:27:31EMP
00:27:33EMP
00:27:35Why?
00:27:36you
00:27:37don't
00:27:38stop here
00:27:40we are
00:27:41okay
00:27:42so now
00:27:43we are thinking
00:27:44with join
00:27:46I said
00:27:47department name
00:27:48don't have to show
00:27:49location
00:27:50not
00:27:52then
00:27:53someone
00:27:54not
00:27:56but
00:27:58we have to put
00:27:59I will not be able to put it without the join.
00:28:02Okay, okay, you will not be able to put it without the join.
00:28:09Yes, it will happen.
00:28:11We are dptn.
00:28:14No number dptn.
00:28:17Yes.
00:28:20Yes, sir.
00:28:24a bracket medal user select uh dpt no
00:28:34from dpt
00:28:40where
00:28:40loc loc location loc
00:28:50in
00:28:55bracket message chicago and dallas dalya comma
00:29:01character
00:29:11a select a bracket banca tijia ga bus
00:29:20select
00:29:24a conno the beast or tisola hoja
00:29:26this is already done, if we can see this one
00:29:31okay
00:29:37hmm
00:29:42hmm
00:29:44hmm
00:29:46hmm
00:29:48hmm
00:29:50hmm
00:29:51hmm
00:29:52hmm
00:29:53hmm
00:29:55who your manager is working in the same department as King
00:30:07take a display the name of employee whose manager is working in the same
00:30:13department so we gotta display that was implied to mom but how just come
00:30:22manager this come manager in case him department menu in the department
00:30:31same to public in the car department in the car la pera yes sir sir
00:30:41ah ah ah ah ah where e name is equal to
00:30:50king
00:30:53This is king. President of the department.
00:30:58President of the department.
00:31:01This is 10.
00:31:03Yes sir, sir.
00:31:05Now the manager will take you.
00:31:07No, no.
00:31:09Whose manager is working in the same department as king.
00:31:19One second.
00:31:21The manager will take you.
00:31:27This is the king.
00:31:29The department of the department is 10.
00:31:33The manager will take you.
00:31:37There is no clerk in 10 departments.
00:31:43The department of the department is the same department.
00:31:47So you have it.
00:31:53So you have it.
00:31:55Chahiye naam.
00:31:57Ki manager.
00:31:59Chahiye.
00:32:01Display the name of employee.
00:32:03Jis. Jis ka manager.
00:32:05Now Miller.
00:32:07Yes, look at that clerk.
00:32:09Look at that clerk.
00:32:11Saito hai sir.
00:32:13Why is it working in the same department as king.
00:32:17That is about king.
00:32:18Now Samaras.
00:32:19King, king.
00:32:20The department is the same department as king.
00:32:22King, king.
00:32:23King, king.
00:32:24King, king.
00:32:25To meet its manager.
00:32:26inconveniently technically.
00:32:27Choose an employee name definitely.
00:32:28renching.
00:32:29So, should I put it or not keep it from me.
00:32:30Employee the name importantly of my coach.
00:32:31Each manager is working in the same department as king.
00:32:33Even this money is working in the same department as king.
00:32:35same department is king, so now the name of the employee, which manages to work in the 10th department in the 10th department.
00:32:47Yes sir, the department is 10th department is 10th department is 10th department.
00:32:55Yes sir, the department is 10th department, so we can do it.
00:33:09manager I didn't have coming see directly I'm selecting MGR Hannah selected in the air from
00:33:20from
00:33:23is it
00:33:24no
00:33:26no
00:33:28from
00:33:30emp
00:33:32where
00:33:34dptn
00:33:36equal to
00:33:38this
00:33:40okay
00:33:422
00:33:44number
00:33:46no
00:33:48no
00:33:50no
00:33:52no
00:33:54who
00:33:56is
00:33:58who
00:34:00is
00:34:02no
00:34:04no
00:34:06no
00:34:08no
00:34:10no
00:34:12no
00:34:14no
00:34:16okay
00:34:18okay
00:34:22and
00:34:24king
00:34:26oh
00:34:28yeah
00:34:30yeah
00:34:32okay
00:34:34okay
00:34:36and
00:34:38mgr
00:34:40oh
00:34:42mgr
00:34:44oh
00:34:46oh
00:34:48oh
00:34:50oh
00:34:52oh
00:34:54oh
00:34:56oh
00:34:58oh
00:35:00me
00:35:01oh
00:35:02oh
00:35:04oh
00:35:06it
00:35:08oh
00:35:10oh
00:35:12oh
00:35:14oh
00:35:16oh
00:35:18is not a clerk.
00:35:19This is a Miller manager .
00:35:22This is a King Group.
00:35:25The answer is Miller.
00:35:28Let me tell you what you are saying.
00:35:32The manager is a department 10.
00:35:35What will the department 10 ?
00:35:41Well, what is the manager's ID ?
00:35:44I don't think I have a question that I have a question that we can do
00:35:55first we have the king's ID and the manager and the president and the rest of the people
00:36:05I have a simple question, the question is that the name of the employer is the same as the king.
00:36:17The king has 10 departments.
00:36:22The manager of the 10 departments, I will take them to the 10 departments.
00:36:30There are 10 departments in the 10 departments.
00:36:37There are 7-8-3-9 and 7-7-8-2.
00:36:437-8-3-9 and 7-7-8-2.
00:36:497-8-3-9 and 7-7-8-2.
00:36:52This is the president.
00:36:55This is the president.
00:37:02This is the president.
00:37:04The president.
00:37:05The president.
00:37:06This is the president.
00:37:07You can tell me I have a little bit of data.
00:37:11You can tell me.
00:37:13Yes sir.
00:37:15What is our name?
00:37:19We have one here and select star, sir, select star EMP.
00:37:39From EMP.
00:37:43Okay sir, where?
00:37:44.
00:37:51.
00:37:53.
00:38:00.
00:38:01.
00:38:03.
00:38:04.
00:38:05.
00:38:07.
00:38:07.
00:38:08.
00:38:09.
00:38:11I don't know what to do.
00:38:41I'm going to go to the next one.
00:41:09not in her not in all these are not in my or are we happening these are select
00:41:24so we keep recording in progress select wiki sir mgr from emp
00:41:42we are dpt no equal to ke ba sir upar wala copy colleges select wala pura part
00:41:59yeah yes sir nini all right abhi joe likha tha hamna select department number wala yola is cool
00:42:06so it's not it's can be channel indian in a yeah hi this copy college
00:42:16oh i said hello oh my god
00:42:20the bracket is left character
00:42:26is wala sir we are dpt no equal to select tennis kaha yogi sir upka
00:42:31Yes sir, there will be a last record, there will not be anything.
00:42:38If I simply ask this table, which record will be recorded?
00:42:48I am going to display the name of employee who manager is working in the same name of King.
00:42:58King department number 10.
00:43:01Okay.
00:43:02Now, in 10 departments, the manager is working on the employee's name.
00:43:11Is that how it will happen?
00:43:15It is like this.
00:43:21First we have to keep the list of the client.
00:43:23We will put a number of the client to the client.
00:43:28If it is like this, what is the name of the client?
00:43:33It is the name of the client.
00:43:36Your client is the name of the client.
00:43:38yeah or Clark okay you don't know when you look at your happy does my hair
00:43:43it's too many years ago I say one eight three nine
00:43:47oh and or a manager of a seven seven eight two
00:43:52oh and a seven seven eight two
00:43:57oh I'm gonna do a seven seven eight two two
00:43:59house up the same seven eight two can have manager here
00:44:04so if I go here
00:44:09select dptno from EMP where
00:44:17what was that?
00:44:19e-name
00:44:22sir, first of all, there is something I can't remember
00:44:27tell me
00:44:30okay this is
00:44:33all mRNA
00:44:37and
00:44:39not in
00:44:41kindergarten
00:44:41no
00:44:43sorry
00:44:45oh
00:44:47oh
00:44:48ڑ�
00:44:49not equal to
00:44:50mgr
00:44:51copy
00:44:52its
00:44:53not in
00:44:55I said so how far I lost the Kura Tati you
00:45:01yes are it
00:45:05bracket bracket support
00:45:09not in not in
00:45:15oh
00:45:17oh
00:45:19oh
00:45:24oh
00:45:30not in MGR
00:45:31MGR
00:45:35not in MGR
00:45:37number I can't say
00:45:39select MGR for EMP I say
00:45:48hmm you can do something
00:45:50you can do something
00:45:54I'm gonna put a look at what simple way my name I do
00:46:00select star from emp where name is equal to king
00:46:14name is equal to king my name is car nika liya dpt no is cut department number of us thus
00:46:32display the name of employee whose manager is working in the same manager manager to abu
00:46:48sorry the is car department number of us are
00:46:53manager who's manager is the implied name or job it to take a chicken it to manage it
00:47:07to manage it select ename ename or emp name from emp where dpt no is equal to
00:47:33this and job is equal to manager
00:47:45color not manager not manager not manager not manager manager not manager manager
00:47:52Yes, why?
00:47:54Why?
00:47:56We have the name of the manager.
00:47:58Let me, let me,
00:48:00the manager's name is the name of the guy.
00:48:02What is the guy that is being released?
00:48:06The guy who is coming out,
00:48:08right?
00:48:10Okay.
00:48:12That's right.
00:48:14That's right.
00:48:16This is the manager.
00:48:18seven seven eight two and it's cool it's hard as a but I hope I have a link in
00:48:28a guy a Clark oh or EMP name is seven seven eight two two my half a Lillia it's not or of my other
00:48:41my car
00:48:42I
00:48:44I
00:48:46I
00:48:48I
00:48:50I
00:48:52I
00:48:54I
00:48:56I
00:48:58I
00:49:00I
00:49:01I
00:49:03I
00:49:05I
00:49:07I
00:49:09I
00:49:11Hey
00:49:11yes
00:49:12The
00:49:12store
00:49:13isn't
00:49:14oh
00:49:16Yeah
00:49:17Yes
00:49:18The
00:49:19solo
00:49:22to
00:49:23which
00:49:24The
00:49:26oh
00:49:26ود
00:49:27arise
00:49:39here
00:49:39here
00:49:39okay well it's a department and get a college you select DPT for a EMP where name is called to
00:49:55King
00:49:56in the name sir
00:50:01take here
00:50:06I am a dpt and no sir
00:50:09take it is equal to
00:50:13dpt
00:50:14and he paid on the journey is that we
00:50:17modalities are city
00:50:18and I believe it select
00:50:21star
00:50:25for EMP where DPT no
00:50:33yeah well do a sir
00:50:39Okay, let's go to the city.
00:50:42A has gone.
00:51:03So now it's gone.
00:51:05on some obligator select a name from city where
00:51:19job is called to mdr okay okay equal to a bracket me like the user select job here
00:51:40from city from city cell where
00:51:54job equal to manager
00:52:10oh my god is that a clark is coming from the first time
00:52:16yes it is not a clark but a miler is coming from the first time
00:52:23miler is coming from the first time
00:52:26so why is this a problem
00:52:32here is this
00:52:40No, we have named manager.
00:52:45It's okay.
00:52:45Where MGR ID is.
00:52:50Equal to it.
00:52:56Miller should have entered.
00:52:56Let's rename.
00:53:00Why is it?
00:53:00How is the name of manager?
00:53:04Select rename from cities.
00:53:06We have to take a name from city.
00:53:08Where MGR.
00:53:09I am here to have a card equal to
00:53:13Let's start, let's keep the first place
00:53:17Let's see it
00:53:21Let's see it
00:53:25Let's see it
00:53:29Display the name of the employee whose commission is less than 200
00:53:35There is no commission
00:53:39So what is this?
00:53:43There is no commission
00:53:45There is no commission
00:53:47There is no commission
00:53:49Select
00:53:51Start
00:53:53For
00:53:55For
00:53:57Commission
00:53:59For
00:54:01Commission
00:54:03200
00:54:05And
00:54:06Message
00:54:07Not Null
00:54:13Not Null
00:54:15Is it like this?
00:54:17Yes
00:54:18No
00:54:19No
00:54:20No
00:54:21No
00:54:22No
00:54:23No
00:54:24No
00:54:25No
00:54:26No
00:54:27No
00:54:28No
00:54:37More
00:54:38No
00:54:39No
00:54:40No
00:54:41That's right
00:54:42No
00:54:44No
00:54:45No
00:54:46No
00:54:48No
00:54:49Okay
00:54:51Okay
00:54:52Okay
00:54:53Alright
00:54:54Okay
00:54:56I am not sure how much time will be in this case.
00:55:12Display the name whose salary is less than or equal to their manager's salary.
00:55:18That is the employee's salary and his manager's salary.
00:55:25The employee's salary is less than or equal to their manager's salary.
00:55:47Select start for EMP-E.
00:55:58Join EMP-P.
00:56:05EMP-M.
00:56:09Right?
00:56:10On.
00:56:11EMP-M.EMP-NO is equal to E.M.G.R.
00:56:36That is the employee's salary.
00:56:37Where whose salary is less than or equal to their manager's salary.
00:56:43The EMP-E.
00:56:44The EMP-DOT.
00:56:46No.
00:56:48No.
00:56:49EMP-DOT.
00:56:50Salary.
00:56:51E.Cell.
00:56:52E.Cell.
00:56:53E.Cell.
00:56:54E.Cell.
00:56:55M.Cell.
00:56:56E.Cell.
00:56:57Aisian.
00:56:58E.Cell.
00:56:59E.Cell.
00:57:00M.Cell.
00:57:01Aisai?
00:57:02Oh
00:57:04I say
00:57:06I
00:57:08I
00:57:10I
00:57:12I
00:57:14I
00:57:16I
00:57:18I
00:57:20I
00:57:22I
00:57:24I
00:57:26I
00:57:28I
00:57:30I
00:57:32I
00:57:34I
00:57:36I
00:57:38I
00:57:40I
00:57:42I
00:57:44I
00:57:46I
00:57:48I
00:57:50I
00:57:52I
00:57:54I
00:57:56I
00:57:58I
00:58:00I
00:58:02I
00:58:04I
00:58:06I
00:58:08I
00:58:10I
00:58:12I
00:58:14I
00:58:16I
00:58:18I
00:58:20I
00:58:22I
00:58:24I
00:58:26I
00:58:28I
00:58:30I
00:58:32I
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:56I
00:58:58I
00:59:00I
00:59:02I
00:59:06I
00:59:08I
00:59:10I
00:59:12I
00:59:14I
00:59:16I
00:59:18I
00:59:20I
00:59:22I
00:59:24I
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: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:54I
01:00:56I
01:00:58I
01:01:00I
01:01:02I
01:01:04I
01:01:06I
01:01:08I
01:01:10I
01:01:12I
01:01:14I
01:01:16I
01:01:18I
01:01:20I
01:01:22I
01:01:24I
01:01:26I
01:01:28I
01:01:30I
01:01:32I
01:01:34I
01:01:36I
01:01:38I
01:01:40I
01:01:42I
01:01:44I
01:01:46I
01:01:48I
01:01:50I
01:01:52I
01:01:54I
01:01:56I
01:01:58I
01:02:00I
01:02:02I
01:02:04I
01:02:06I
01:02:08I
01:02:10I
01:02:16I
01:02:18I
01:02:20I
01:02:22I
01:02:24I
01:02:26I
01:02:28I
01:02:30I
01:02:32I
01:02:34I
01:02:36I
01:02:40I
01:02:42I
01:02:44I
01:02:46I
01:02:48I
01:02:50I
01:02:52I
01:02:54I
01:02:56I
01:02:58I
01:03:00I
01:03:02I
01:03:04I
01:03:06I
01:03:08I
01:03:10I
01:03:12I
01:03:14I
01:03:16I
01:03:18I
01:03:20I
01:03:22I
01:03:24I
01:03:26I
01:03:28I
01:03:30I
01:03:32I
01:03:34I
01:03:36I