9 SQL Practice Session 11 May 2025
source file :--
https://drive.google.com/file/d/13VLV0iWvn_7QlKCvGY9hmz1QPfc2MybY/view?usp=sharing
Link for whatsapp - https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
source file :--
https://drive.google.com/file/d/13VLV0iWvn_7QlKCvGY9hmz1QPfc2MybY/view?usp=sharing
Link for whatsapp - https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
Category
📚
LearningTranscript
00:00:00so we always take some easy questions
00:00:08new query
00:00:14Okay, so let's do this, let's do it, let's do it, let's do it, let's do it, let's do it,
00:00:43Let's do it, let's do it, I can't do it, Let's do it, let's do it, let's do it,
00:01:13insert
00:01:17select start
00:01:19okay
00:01:21now
00:01:23recording
00:01:25now
00:01:27question
00:01:29display the implied name and annual salary for all implied
00:01:37it will be easy to make it
00:01:41this
00:01:43so
00:01:45select
00:01:49e-name
00:01:51and
00:01:53send
00:01:55into
00:01:5712
00:01:59as a
00:02:01annual
00:02:03cell
00:02:05and
00:02:07and
00:02:09and
00:02:11and
00:02:13and
00:02:15and
00:02:17display the name of employee who are working in department number 20
00:02:29how
00:02:31how
00:02:35how
00:02:37display the name of employee who are working in department number 20
00:02:41and
00:02:43and
00:02:47and
00:02:49and
00:02:51and
00:02:53and
00:02:55and
00:02:57and
00:02:59and
00:03:01and
00:03:03and
00:03:05and
00:03:07and
00:03:09and
00:03:11and
00:03:13and
00:03:15and
00:03:17and
00:03:19and
00:03:21and
00:03:23and
00:03:25and
00:03:27and
00:03:29and
00:03:31and
00:03:33and
00:03:35and
00:03:37and
00:03:41and
00:03:43and
00:03:45and
00:03:47and
00:03:49and
00:03:51and
00:03:53So really, there is a select e-name from EMT where job equal to clerk clerk or service
00:04:14and the cell is greater than 1,000.
00:04:26What is this? No, it's not.
00:04:30It's not.
00:04:32So let's check someone else.
00:04:36There are 5,000 presidents here.
00:04:40Equal. Equal.
00:04:43We can do 2,000.
00:04:461,000?
00:04:47Yes, we can do 2,000.
00:04:49Then we can do 2,000.
00:04:51Oh, man.
00:04:53There is no 1,000.
00:04:57Do you have to do 1,000?
00:05:01It's 1,000.
00:05:04Do you have to do 2,000?
00:05:06Oh, okay.
00:05:08The spelling of the color is wrong.
00:05:14Yes, it's not.
00:05:16It's not.
00:05:18It's not.
00:05:20Yes, Adam and Mellor.
00:05:26Okay.
00:05:28Display the implied number.
00:05:32Name.
00:05:33Who are earning commission.
00:05:38Which is the commission.
00:05:41Select.
00:05:42EMP number.
00:05:43Yes.
00:05:44Name.
00:05:45Name.
00:05:46From.
00:05:47EMP.
00:05:48Name.
00:05:49From.
00:05:50EMP.
00:05:51Where.
00:05:52Commission.
00:05:53It's not.
00:05:54Nug.
00:05:55Here's not.
00:06:10This will be a turner, so if there is a turner, it will be a wrong turner, so it will be a wrong turner.
00:06:29It's not one at the river.
00:06:32No, it's simple.
00:06:35This is the best thing.
00:06:38This is the best thing.
00:06:40These are the best things.
00:06:43Display the number and name
00:06:47who do not earn commission.
00:06:50They don't earn commission.
00:06:54We do this,
00:06:56who doesn't earn commission.
00:06:59This will be the best thing.
00:07:02I can see they can see it?
00:07:06It's null!
00:07:08Then commissioning this world will be comparing
00:07:12this.
00:07:14But if it's null.
00:07:19It's null!
00:07:22So it's null it will save.
00:07:27Oh yes.
00:07:29Yes.
00:07:31There are so many people here, what?
00:07:35Yes.
00:07:36There are many people here.
00:07:44OK, the last three is Turner, Alan Ward and Martin.
00:07:57Is it correct?
00:08:02Yes sir.
00:08:06Yes sir.
00:08:11This is the question.
00:08:14The last one was raised in the last one, but it was very long.
00:08:19It was small.
00:08:22We have created a table.
00:08:25and this was created and our question was that we have to remove that imply
00:08:43which was the same number in physics and chemistry. Is that right?
00:08:50Yes sir.
00:08:52So, we can make it easily by group by.
00:09:01How do we make it?
00:09:04I have pasted it here.
00:09:07I have put it as a pivot.
00:09:13Why did it go here?
00:09:17I have put it as a pivot.
00:09:26I have put it as a pivot.
00:09:31I have put it as a pivot.
00:09:35I have put it as a pivot.
00:09:44I have put it as a pivot.
00:09:45I have put it as a pivot.
00:09:49I have put it as a pivot.
00:09:53I have put it as a pivot.
00:10:02I have put it as a pivot.
00:10:11I have put it as a pivot.
00:10:12I have put it as a pivot.
00:10:16I have put it as a pivot.
00:10:17I have put it as a pivot.
00:10:19I have put it as parenthood.
00:10:21I have totaled income can do it.
00:10:24Look.
00:10:25When we grouping different items, we would
00:10:39create two groups buy each other.
00:10:45I do want to have an incentive for student IDs and Mark where I do a
00:10:50step-para, on their services then if
00:10:52So, when I group it, I will count the two, and the rest will be 1-1, and if I change the
00:11:03subject to the filter, then it will be this step.
00:11:06There will be 2 groups here, but there will be 2 groups.
00:11:10One is the student and the marks.
00:11:15So, when you merge, it will count the two groups.
00:11:30So, when you merge, it will count the two groups.
00:11:33So, this will become easily.
00:11:37We have made a very long class in the last class.
00:11:40Sir, it will be a private group.
00:11:43Who is it?
00:11:45Yes, it will be.
00:11:50Tell me.
00:11:55Now, sir, keep the student ideas in the roles, and keep the subjects in the columns.
00:12:07You can also put the columns here, and put the columns here.
00:12:14In the bell?
00:12:16Yes, sir.
00:12:17Filter the columns here, and I will cut the columns.
00:12:20I will cut the columns here.
00:12:26Hmm.
00:12:30सबस्क्राइब QAана
00:12:36तो भी है
00:12:42ने नहींहें सब्जेक्ट नहीं दिखेगा सब् deal को घृट्ट हो जाएगा
00:12:44सबंद्ट में तो नहीं सब्सक्राइब इन
00:12:57all the subject will be wrong.
00:13:00This is a total.
00:13:03This is a total.
00:13:09This is a total.
00:13:11This is a total.
00:13:16This is a total.
00:13:19I can see the header.
00:13:26Yes, I can do it but the mark is not.
00:13:32Okay, I can do it.
00:13:34Then, let's see and do it.
00:13:36First, let's do it.
00:13:39Select, what do we do?
00:13:42Student, ID, Marks.
00:13:48We will choose the groups.
00:13:53Let's choose the exams, where subject is.
00:13:59Subject is called C-H-E-M-I-S-T-R-Y.
00:14:05The number of the exam is called PHYSICS.
00:14:11Okay, this is all.
00:14:14So now we will write group by student ID and Marks, so this will come, so this will come,
00:14:33but now we will check this count.
00:14:40So here I will write count, if I will count here, count star,
00:14:57count star greater than one.
00:15:04Again, count star, count star greater than one.
00:15:11We will keep here, here we will write count star greater than one.
00:15:18We will write count star greater than one.
00:15:25Group is good.
00:15:27Where?
00:15:30Having, not yes sir, having.
00:15:37Yes, sorry.
00:15:39Having, having, having.
00:15:42This is a student, which is the same mark in physics and chemistry.
00:15:52The same mark, right?
00:15:53Yes, sir.
00:15:54Now tell us, how did you tell us?
00:15:59Yes, sir.
00:16:01We were running long ago, this is a short court.
00:16:09You tell us.
00:16:11You tell us.
00:16:12Just leave this in that.
00:16:18Student ID.
00:16:21And,
00:16:34we are subject to form exams.
00:16:45We are subject in chemistry and physics.
00:16:59OK.
00:17:00All right.
00:17:02No doubt
00:17:03any questions,
00:17:05no doubt
00:17:06any questions?
00:17:11You will have to write us,
00:17:12if you will write us?
00:17:13You will write that in that?
00:17:14OK
00:17:15Yes, sir.
00:17:17You don't have to write us.
00:17:19This is the subject.
00:17:20Is it going to be transformed?
00:17:21No doubt
00:17:22any questions?
00:17:23No doubt
00:17:24no doubt
00:17:25no doubt
00:17:26no doubt
00:17:27If I have a group by, then it will be transferred.
00:17:34Group by.
00:17:37Group by.
00:17:42Group by, subject and student.
00:17:47Student ID or subject.
00:18:02It's not happening.
00:18:04If you have to put the case, then it will happen.
00:18:09We have multiple dotables.
00:18:13We will leave the case.
00:18:20We will leave the case.
00:18:22We will leave the case.
00:18:24This is the case.
00:18:26We have a table.
00:18:27We have a table.
00:18:32We will make a test name.
00:18:34We will make a table.
00:18:36I said table.
00:18:37We will make a test name.
00:18:43We will enter 4 records.
00:18:47We will insert.
00:18:49Select start from table.
00:18:51We will leave the case.
00:18:53To get the test name.
00:18:542, 2, 3, 4.
00:18:56Okay?
00:18:57Okay.
00:18:58What I need to need this one?
00:19:02I need to think that it is 1.
00:19:06If it is 1, then it will be 1 record.
00:19:08If it is 2, it will be 2 times.
00:19:11If it is 3 times, then it will be 4 times.
00:19:14This is our question, can we do this as a
00:19:33This is a step, eraser, color, okay, this is a step, and this is a output.
00:19:52How will this happen?
00:19:54no
00:20:00to ask me
00:20:09Do you have a loop? No, I can't even go without a loop.
00:20:15If you go to the loop, you'll get bigger.
00:20:24In the loop, it will be dead, right?
00:20:29Are you talking like this?
00:20:31Yes, I have to repeat it so much.
00:20:40Put your mind on the joint.
00:20:54Do you feel like this?
00:21:15No, sir, it won't happen.
00:21:18If I feel like this joint, it will be duplicated.
00:21:21If I talk about the joint,
00:21:24then we will have left joint.
00:21:28Self joint, inner joint,
00:21:33and outer joint, left, right, full,
00:21:47and cross joint.
00:21:49What do you do?
00:21:53What do you do?
00:21:55What do you do?
00:21:57What do you do?
00:21:58How many times do you do?
00:22:00How many times do you do?
00:22:01How many times do you do?
00:22:02I will multiply it.
00:22:03I will do it.
00:22:04I will do it.
00:22:05I will do it.
00:22:06I will do it.
00:22:08Select, star from, test one T.
00:22:14Okay?
00:22:15T1.
00:22:16Cross joint, test T2.
00:22:20This is a test T2.
00:22:23Does it come?
00:22:25It has come?
00:22:26It has come.
00:22:27It has come.
00:22:28It has come.
00:22:29It has come.
00:22:30It has come.
00:22:31Can you see it?
00:22:34Yes, sir, we have 4 times to do this, 4 times to do this, 4 times to do this, so how do we control it?
00:22:42How do we control it?
00:22:46How do we control it?
00:22:50How do we control it?
00:22:56How do we control it?
00:23:041 will be able to control it and make everyone record with each other.
00:23:112 will be able to control it and make everyone record with each other.
00:23:16How do we control it?
00:23:201 will be able to control it and 2 will be able to control it.
00:23:26That means, if we start 2, then do 2 times.
00:23:30And if we control 3, then stop.
00:23:33So, what do we think about this?
00:23:371 will be able to control it and then we will get to the 4th place.
00:23:452 will be able to control it and make everyone record with each other.
00:23:47Look at that!
00:23:49Exactly.
00:23:50What do we think about this?
00:23:521 will be able to control it.
00:23:542 will be able to control it.
00:23:562 will be able to control it.
00:23:581 will be able to control it.
00:24:00Come here, the best of your level is aware of the level of the level of the level of the level.
00:24:02See, the pace of the level is more advanced.
00:24:04t1.id
00:24:07this is greater than
00:24:12t2.id
00:24:16now the two
00:24:20will do it
00:24:23with this
00:24:25but with this
00:24:28it will become one record
00:24:29right
00:24:30xl
00:24:331,2,3,4
00:24:39if I think this is greater than this
00:24:44how much record will be made
00:24:47with this one
00:24:48one the one will be made
00:24:51one the one will be made
00:24:53why
00:24:55this one will not be made
00:24:57one the one will not be made
00:24:59it will not be made
00:25:00before
00:25:01it will not be made
00:25:02it will not be made
00:25:03two
00:25:04compared
00:25:05two
00:25:06compared
00:25:07two
00:25:08compared
00:25:09two
00:25:10here
00:25:11and
00:25:12This is a good one, but I will add two, then I will add two, then I will compare three,
00:25:29then I will add four, then I will add four, then I will add one,
00:25:37oh yeah
00:25:39oh
00:25:41oh
00:25:43yeah
00:25:45oh
00:25:47oh
00:25:49oh
00:25:51oh
00:25:53oh
00:25:55oh
00:25:57oh
00:25:59oh
00:26:01oh
00:26:05कि इसी को यहां रखते हैं और यहां पर कर देते हैं
00:26:09t2.id या फिर t1.id और देखते हैं
00:26:23हो तो गया सैथ और यहां पर order by t1.id देखो एक एक वार दो दो वार तीन तीन वार चार चार वार
00:26:37अब इसमें क्या करते हैं हम एक record और जोड़ देते हैं पांच
00:26:42है ना
00:26:45अब इसको दे दिया वन टू थेरी फोर फाइब
00:26:55अब यहां पर गए
00:26:57देखिए एक एक वार दो दो वार
00:27:01तीन तीन वार चार चार वार और पांच पांच वार हो गया
00:27:07तो यह भी है एक छोटा सक्षट एक और एक और इसा ही टेवल है एक वही थोड़ा सा इसको उसी में कूपी करते हैं अलग से क्यों बनाना है
00:27:35उसी में कूपी कर देता है या फिर अलग से बना ले अलग से बनाएंगे तो लंबा पर जाएगा क्यों क्यों करना है उसी में कर देते हैं
00:27:49इसी में लास्ट में मैं जोड़ देता हूं और इसका काम खतम
00:27:59कि सेट वन को इसी में देता हूं यहां पर टेवल के नाम थोड़ा अलग कर रखा है कोई नहीं
00:28:10क्यों सेट टू वला है टेवल वैसे ही है तोरा इसमें डिस्क्रिप्शन दिया हूँ है
00:28:19अहां और डी इंपलाई तो नहीं बना रहा हूं अच्छा इंपलाई ही बन रहा है यार ममला खराब हो जागा क्या
00:28:31खराब हो जागा तो कर देते हैं ड्रॉप टेवल इंपल हटा दिया फिर से मैंने गया इसको बनाया इंपल फिर इसमें रेकॉर्ड इंसर्ट किया
00:28:53एक डिपार्टमेंट का टेवल बनाया डिपार्टमेंट में इंसर्ट किया दो ही टेवल है
00:29:03अगर दो ही है नहीं एक दो ही है अब लिखते हैं सेलेक्ट एस्टार फरम इंप और सेलेक्ट एस्टार फरम डी पीटी वही हमारा पहले वाला ही टेवल है ड्लास वाला ठीक है अब बताओ
00:29:29So display all in ply with their department now
00:29:34So we can go select
00:29:48Sir, e dot, e name is digit, comma, d dot, d name, d name, d name, huh,
00:30:17from, EMP, EMP, EMP, D, e dot, join, d, d, p, t, d, p, t, d, on,
00:30:44e dot department number e dot dptno equal to d dot dptno
00:30:59यह सारे बंदे हैं इस इस डिपार्टमेंट में काम करें ठीक है
00:31:07डिस्पले इंपलाई एलोंग बित देर मेनेजर नेम
00:31:29मतलब इसमें नहीं रेकोर्ड है क्या एक दो तीन चार पांच छे साथ आठ नहीं है
00:31:44हाँ डिस्पले इंपलाई एलोंग बित देर मेनेजर नहां मनें इंपलाई का नाम और उसके मेनेजर के ना है
00:31:55Mohan
00:31:56उस्पलाई करें नहीं हो इसे हो दो मैं आसम दीन दीन दीन में नहीं है
00:32:09मैं एंपना कर दोल्र प्रियां आप मैं घे इस और अ कंधि इसल्फ जानीया नहीं जाए नहीं टूम
00:32:23I am sorry I am
00:32:26I am
00:32:31A
00:32:32A
00:32:34A
00:32:35A
00:32:37A
00:32:39A
00:32:41A
00:32:42A
00:32:43A
00:32:44A
00:32:45A
00:32:46A
00:32:47A
00:32:48A
00:32:49A
00:32:50A
00:32:51A
00:32:521
00:32:539
00:32:530
00:32:542
00:32:543
00:32:555
00:32:575
00:32:576
00:32:587
00:33:009
00:33:000
00:33:014
00:33:025
00:33:034
00:33:045
00:33:054
00:33:065
00:33:075
00:33:085
00:33:096
00:33:105
00:33:116
00:33:126
00:33:136
00:33:146
00:33:157
00:33:167
00:33:1710
00:33:1810
00:33:197
00:33:207
00:33:217
00:33:22E1, sir, I'll give you E1.mgr number.
00:33:27No, E.mgr number.
00:33:30E.mgr, I'll give you E.mgr.
00:33:33Mgr, yes.
00:33:37And then, comma, E1.
00:33:43E1?
00:33:46E1.ename.
00:33:50What?
00:33:52From E.mpr.
00:33:54From E.mpr.
00:33:57E.mpr.
00:33:59Yeah, what?
00:34:00E.mpr, I can't do that.
00:34:03E.mpr, I'll give you E.mpr.
00:34:06Join.
00:34:12Sir, E.mpr, E1, per unit, sir.
00:34:19and
00:34:21I
00:34:23I
00:34:25I
00:34:27I
00:34:29I
00:34:31I
00:34:33I
00:34:37We
00:34:41we
00:34:43We are putting on the air.
00:34:45Yeah, we are putting on the air.
00:34:47Yeah, we are putting on the air.
00:34:49Do you want to put it on?
00:35:43It's okay, it's okay.
00:36:13It's okay, it's okay.
00:36:43It's okay.
00:36:45It's okay.
00:36:47It's okay.
00:36:49It's okay.
00:36:51It's okay.
00:36:53It's okay.
00:36:55It's okay.
00:36:57It's okay.
00:36:59It's okay.
00:37:01It's okay.
00:37:03It's okay.
00:37:05It's okay.
00:37:07It's okay.
00:37:09It's okay.
00:37:11It's okay.
00:37:13It's okay.
00:37:15It's okay.
00:37:17It's okay.
00:37:19It's okay.
00:37:21It's okay.
00:37:23It's okay.
00:37:25It's okay.
00:37:27It's okay.
00:37:29It's okay.
00:37:31It's okay.
00:37:33It's okay.
00:37:35It's okay.
00:37:37It's okay.
00:37:39It's okay.
00:37:41It's okay.
00:37:43It's okay.
00:37:45It's okay.
00:37:47It's okay.
00:37:49It's gone.
00:37:51It's gone.
00:37:52It's gone.
00:37:53Look, it's a manager for Esmeet.
00:37:57I have to write here,
00:38:02as manager name.
00:38:08It's like this.
00:38:13And here,
00:38:15e.managerid
00:38:20Let's see.
00:38:22It's gone.
00:38:25It's gone.
00:38:26Yeah, it's gone.
00:38:34How is it?
00:38:35Sir, let's do this in the last one.
00:38:38The last one has written E.EMP number in our house.
00:38:42E.M.J.R.
00:38:44E.M.J.R.
00:38:45Do this.
00:38:46Ayaan.
00:38:48The EMP and a-lock to MGR.
00:38:52On this line?
00:38:54On this line.
00:38:56On this line.
00:38:58Last line.
00:39:00E.
00:39:02Here.
00:39:04Ayaan.
00:39:06Ayaan.
00:39:08E1. EMP number.
00:39:12I am giving her
00:39:17Smith's Ford, Allen's Black, Ward's Black, Jones's Keep, Black's King, Clark's King
00:39:29Ford's Jones and Miller's Colour
00:39:36The colour is now
00:39:38this is how you remember
00:39:42display, implied name, salary and total salary for each department
00:40:01this is strange, will it come from one side?
00:40:11yes sir, one side, three side
00:40:14this department will come from one side
00:40:19what he is saying, he is saying
00:40:24imply name, E-Name, salary and total salary for each department
00:40:39this department will come from one side
00:40:44first, we will go to one side
00:40:50select
00:40:53select, name, cell, EMP
00:41:02this is what it is
00:41:04you are saying
00:41:05you are saying
00:41:06that the department of this department
00:41:11this department
00:41:14this department
00:41:20this department
00:41:22can show you the total salary for each department
00:41:32Yes.
00:41:33So, this is a table, which is a department, which is a total cell, which is a total cell.
00:41:44Dpt.
00:41:45No.
00:41:46Yeah.
00:41:47And then, the cell, the same thing.
00:41:53I will put it.
00:41:59I will write it.
00:42:01I will put the name of the column.
00:42:06Yes.
00:42:08Department.
00:42:10Total sales.
00:42:13Group by DPTN.
00:42:16This is the group.
00:42:18This is our total sales.
00:42:20It is our total sales.
00:42:22Sir, it is what you have put in it.
00:42:24Yes.
00:42:25Now, we will put it together.
00:42:27How do we put it together?
00:42:29Yes, sir.
00:42:31It is written here.
00:42:35It is written here.
00:42:37It is written here.
00:42:39It is written here.
00:42:41No, it will be done with the joint.
00:42:44Have you copied it?
00:42:48Yes, sir.
00:42:50Now, it will be written here.
00:42:51And here it will put it in the mnie.
00:42:53Step the name of this.
00:42:54It will put this URL.
00:42:55Yes.
00:42:56Yes.
00:42:57Step the name of E.
00:42:58Now it will put a little link between this.
00:42:59Step the name of thealign.
00:43:01Yes.
00:43:03Step the name of the datamines.
00:43:04Step the name of the Dasanye.
00:43:05Step the name of the Datamines.
00:43:06We will put it together.
00:43:07Step the join.
00:43:09Step the join.
00:43:10You will put it all right?
00:43:11He can put it together.
00:43:13You can put it together?
00:43:14Step the deployment.
00:43:15No, sir.
00:43:16I can't do the power things here.
00:43:17No, sir.
00:43:18I am looking at the department.
00:43:25We have no join from the department.
00:43:32We will not join from the department.
00:43:37We will join from the department.
00:43:41So, we will join the department of sales.
00:43:48So, here we will do this.
00:43:56As DPT sales on
00:44:08and uh
00:44:11dpt cell
00:44:12now, sir, let me write
00:44:14e dot dpt no
00:44:16e dot
00:44:18e dot dpt no
00:44:20e dot dpt no
00:44:26equal to d dot dpt no
00:44:28sir, sir, we have one thing
00:44:30we are not working
00:44:32we are not working
00:44:34sir, sir, we will do
00:44:36.
00:44:38.
00:44:40.
00:44:42.
00:44:44.
00:44:45.
00:44:46,
00:44:48.
00:44:49.
00:44:50.
00:44:51.
00:44:52.
00:44:53.
00:44:54.
00:44:55.
00:44:56.
00:44:57.
00:44:59.
00:45:01.
00:45:03.
00:45:04Yes sir, the DPTSL is just D color.
00:45:09The second line is just D color.
00:45:11Yes, it's just D color.
00:45:14Yes, it's just D color.
00:45:16Now it's okay.
00:45:17Now it's okay.
00:45:18Oh, oh.
00:45:19It's fun.
00:45:21It's color.
00:45:23We have two tables.
00:45:27It was removed.
00:45:32Oh, yeah.
00:45:35Oh, yeah.
00:45:37So, it's closed.
00:45:38What is it?
00:45:40Select all.
00:45:44Copy with headers.
00:45:47I said they did.
00:45:49This person is color.
00:45:53Which group is in color?
00:45:56Yeah.
00:45:57Lookup.
00:45:58I could use these tag.
00:46:00In the same place,
00:46:02let's put it on the list.
00:46:05Lookup.
00:46:06Lookup.
00:46:07I said let's put it on the list.
00:46:09I apologize.
00:46:10All right.
00:46:11Let's put it on the list.
00:46:12Lookup.
00:46:13Lookup.
00:46:14Okay.
00:46:15Let's put it on the list.
00:46:16Lookup.
00:46:17We can just put it on the list.
00:46:18Lookup.
00:46:19Lookup.
00:46:20It's right.
00:46:22I say this color.
00:46:23is color
00:46:25color
00:46:27color
00:46:29check
00:46:31color
00:46:335,000
00:46:3587
00:46:37department
00:46:3910
00:46:41killer
00:46:43and
00:46:476,755
00:46:49and
00:46:516,755
00:46:53and
00:46:55and
00:46:57and
00:46:59and
00:47:01and
00:47:03and
00:47:05and
00:47:07and
00:47:09and
00:47:11and
00:47:13and
00:47:15and
00:47:17and
00:47:19and
00:47:21and
00:47:23and
00:47:25and
00:47:27and
00:47:29and
00:47:31and
00:47:33and
00:47:35and
00:47:37and
00:47:39and
00:47:41and
00:47:43and
00:47:45and
00:47:47and
00:47:49and
00:47:51and
00:47:53and
00:47:55and
00:47:57and
00:47:59and
00:48:01and
00:48:03and
00:48:05and
00:48:07and
00:48:09and
00:48:11and
00:48:13and
00:48:15and
00:48:17and
00:48:19and
00:48:21and
00:48:23and
00:48:25and
00:48:27and
00:48:29and
00:48:31and
00:48:33and
00:48:35and
00:48:37and
00:48:39and
00:48:41and
00:48:43and
00:48:45and
00:48:47and
00:48:49and
00:48:51and
00:48:53and
00:48:55and
00:48:57and
00:48:59and
00:49:01and
00:49:03and
00:49:05and
00:49:07and
00:49:09and
00:49:11and
00:49:13and
00:49:15and
00:49:17and
00:49:19and
00:49:21and
00:49:23and
00:49:25and
00:49:27and
00:49:29and
00:49:31and
00:49:33and
00:49:35and
00:49:37and
00:49:39and
00:49:45and
00:49:47questions
00:49:53and
00:50:03and
00:50:05and
00:50:07and
00:50:09and
00:50:11Ename.Cell into Borrow as AnnualCell from EMP
00:50:25Display total salary for each department
00:50:30This is also easy. Select DPT and select D.S.
00:50:41Okay. Can you copy this? No.
00:50:46Will it happen?
00:50:48Yes sir.
00:50:50No.
00:50:51How will it happen?
00:50:55It will happen.
00:50:57Group people?
00:50:58Okay.
00:50:59Okay.
00:51:00Group people?
00:51:01Yes sir.
00:51:02Sorry.
00:51:05Okay.
00:51:06If the name of the department will be asked.
00:51:09Let's go.
00:51:11Find out highest salary in each department.
00:51:22Select each department.
00:51:25You can say two things.
00:51:27Either the department's code or the name of the department.
00:51:32What do you want?
00:51:34What do you want?
00:51:35Code from DPT.
00:51:36No.
00:51:37Max.
00:51:38Max.
00:51:39Cell.
00:51:40Edge.
00:51:41From EMP.
00:51:42Okay.
00:51:43As a high cell.
00:51:44Pressed edge.
00:51:55From EMP.
00:51:56Yes sir.
00:51:58It is a high cell.
00:51:59Group by?
00:52:01I say?
00:52:03Deep tune.
00:52:05Its department come here.
00:52:07display department wise, department wise employee count, how do we count the employees of each employee?
00:52:26count
00:52:28same way, just count
00:52:32Oh
00:52:34I
00:52:36I
00:52:38I
00:52:40I
00:52:42I
00:52:44I
00:52:46I
00:52:48I
00:52:50I
00:52:52I
00:52:54I
00:52:56I
00:52:58I
00:53:00I
00:53:02I
00:53:04I
00:53:06I
00:53:08I
00:53:10I
00:53:12I
00:53:14I
00:53:16I
00:53:18I
00:53:20I
00:53:22I
00:53:24I
00:53:26I
00:53:28I
00:53:30I
00:53:32I
00:53:34I
00:53:36I
00:53:38I
00:53:40I
00:53:42I
00:53:44I
00:53:46I
00:53:48I
00:53:50I
00:53:52I
00:53:54I
00:53:56I
00:53:58I
00:54:00I
00:54:02I
00:54:04I
00:54:06I
00:54:08I
00:54:10I
00:54:12I
00:54:14I
00:54:16I
00:54:18I
00:54:20I
00:54:22I
00:54:24I
00:54:26I
00:54:28I
00:54:30I
00:54:32I
00:54:34I
00:54:36I
00:54:38I
00:54:40I
00:54:42I
00:54:44I
00:54:46I
00:54:48I
00:54:50I
00:54:52I
00:54:54I
00:54:56I
00:54:58I
00:55:00I
00:55:02I
00:55:04I
00:55:06I
00:55:08I
00:55:10I
00:55:12I
00:55:14I
00:55:20I
00:55:22I
00:55:24I
00:55:26I
00:55:28I
00:55:30I
00:55:32I
00:55:34I
00:55:36I
00:55:38I
00:55:40I
00:55:42I
00:55:44I
00:55:46I
00:55:48I
00:55:50I
00:55:52I
00:55:54I
00:55:56I
00:55:58I
00:56:00I
00:56:02I
00:56:04I
00:56:06I
00:56:08I
00:56:10I
00:56:12I
00:56:14I
00:56:16I
00:56:18I
00:56:20I
00:56:22I
00:56:24I
00:56:26I
00:56:28I
00:56:30I
00:56:32I
00:56:34I
00:56:36I
00:56:38I
00:56:40I
00:56:42I
00:56:44I
00:56:46I
00:56:48I
00:56:50I
00:56:52I
00:56:54I
00:56:56I
00:56:58I
00:57:00I
00:57:02I
00:57:04I
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: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: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: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: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: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:12I
01:02:14I
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:38I
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:32I
01:03:34I
01:03:36I
01:03:38I
01:03:40I
01:03:42I
01:03:44I
01:03:46I
01:03:48I
01:03:50I
01:03:52I
01:03:54I
01:03:56I
01:03:58I
01:04:00I
01:04:02I
01:04:04I
01:04:06I
01:04:08I
01:04:10I
01:04:12I
01:04:14I
01:04:16I
01:04:18I
01:04:20I
01:04:22I
01:04:24I
01:04:26I
01:04:28I
01:04:30I
01:04:32I
01:04:34I
01:04:36I
01:04:38I
01:04:40I
01:04:42I
01:04:44I
01:04:46I
01:04:48I
01:04:50I
01:04:52I
01:04:54I
01:04:56I
01:04:58I
01:05:00I
01:05:02I
01:05:04I
01:05:06I
01:05:08I
01:05:10I
01:05:12I
01:05:14I
01:05:16I
01:05:18I
01:05:20I
01:05:22I
01:05:24I
01:05:26I
01:05:28I
01:05:30I
01:05:32I
01:05:34I
01:05:36I
01:05:38I
01:05:40I
01:05:42I
01:05:44I
01:05:46I
01:05:48I
01:05:50I
01:05:52I
01:05:54I
01:05:56I
01:05:58I
01:06:00I
01:06:02I
01:06:04I
01:06:06I
01:06:08I
01:06:10I
01:06:12I
01:06:14I
01:06:16I
01:06:18I
01:06:20I
01:06:22I
01:06:24I
01:06:26I
01:06:28I
01:06:30I
01:06:32I
01:06:34I
01:06:36I
01:06:38I
01:06:40I
01:06:42I
01:06:44I
01:06:46I
01:06:48I
01:06:50I
01:06:52I
01:06:54I
01:06:56I
01:06:58I
01:07:00I
01:07:02I
01:07:04I
01:07:06I
01:07:08I
01:07:10I
01:07:12I
01:07:14I
01:07:16I
01:07:18I
01:07:20I
01:07:22I
01:07:24I
01:07:26I
01:07:28I
01:07:30I
01:07:32I
01:07:34I
01:07:36I
01:07:38I
01:07:40I
01:07:42I
01:07:44I
01:07:46I
01:07:48I
01:07:50I
01:07:52I
01:07:54I
01:07:56I
01:07:58I
01:08:00I
01:08:02I
01:08:04I
01:08:06I
01:08:08I
01:08:12I
01:08:14I
01:08:16I
01:08:18I
01:08:20I
01:08:22I
01:08:24I
01:08:26I
01:08:28I
01:08:30I
01:08:32I
01:08:34I
01:08:36I
01:08:38I