- 2 days 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/1HOJQc7CeTDvJFZKSaiQlsXeaOaNehap9/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/1HOJQc7CeTDvJFZKSaiQlsXeaOaNehap9/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 my last word power query came to practice
00:00:03a good time from office
00:00:05I didn't have to do it for them
00:00:08I had to verify the data for my own
00:00:11so I had to do it good practice
00:00:14so I created
00:00:17create database
00:00:187 December
00:00:21use
00:00:24this table
00:00:27I had to break two tables
00:00:31one table is called
00:00:33employee
00:00:35and I put this data
00:00:39employee ID
00:00:41name
00:00:43department name
00:00:45manager ID
00:00:47and salary
00:00:49one table is sales
00:00:51sales
00:00:53in sales
00:00:55insert
00:00:59employee ID
00:01:01sales amount
00:01:02sales date
00:01:03sale date
00:01:05now we have to do it
00:01:07for each employee
00:01:09calculate total sales
00:01:11and average monthly sales
00:01:13s
00:01:14and
00:01:15we have to do it
00:01:17we have to do it
00:01:19one table
00:01:21sales
00:01:23and one
00:01:24employee
00:01:25and the one
00:01:27employee
00:01:29this is the two tables
00:01:31oh yeah it Oh no People
00:01:35oh yeah people after a year Mikey
00:01:37oh yeah so many years ago
00:01:39yeah older video manager home look up
00:01:41possible power power power
00:01:45com with me tomorrow song to
00:01:48are huh how are some way around
00:01:51oh I think a don't want to
00:01:53I think itkiya
00:01:56Oh no, no, no.
00:01:57We got two here, sir.
00:01:58Here, here.
00:01:59You got sales.
00:02:00You got sales.
00:02:01You got employee.
00:02:02No, no, no, no, no.
00:02:03It's a table.
00:02:04Okay.
00:02:05Right.
00:02:06Yeah, so, now, let me tell you how it will become.
00:02:11It's simple, sir.
00:02:14It's a simple, sir.
00:02:16It's a join.
00:02:17It'll be, it'll be.
00:02:18It'll be, it'll be.
00:02:19Because this is the table I have.
00:02:21I have.
00:02:22Yeah.
00:02:23Uh-huh.
00:02:24Uh-huh.
00:02:26It's an average month sale, month-wise total sale,
00:02:30so, you know, total sale and average monthly sales.
00:02:36Yeah, that was.
00:02:38So, total sales.
00:02:39Your goal, you go 2 month for success, sir.
00:02:41So, the goal is going to fix you.
00:02:43So, you, you, you.
00:02:47Oh, you, you, you, you.
00:02:48How much?
00:02:49Yeah.
00:02:50About the conversation.
00:02:51for each implied sari barker ka just just in a total sale
00:03:00kia usko nika do or jojo just my monthly sale kia average monthly or nika lo
00:03:04go let's take a sentry galat kaas boli ho nai thik as it so if you select oh employee ID
00:03:20done DJ of your employee in the saving color from employees in flight you have
00:03:30sir
00:03:33you
00:03:35are
00:03:36in
00:03:37in
00:03:38in
00:03:39in
00:03:40in
00:03:41in
00:03:42in
00:03:44in
00:03:45here
00:03:46sir
00:03:47join
00:03:48then
00:03:49total
00:03:50in
00:03:51in
00:03:52sales
00:03:54yes
00:03:55yes
00:03:56yes
00:03:57yes
00:03:58yes
00:03:59yes
00:04:00yes
00:04:01yes
00:04:02on
00:04:03a
00:04:04dot
00:04:05employee
00:04:06id
00:04:07equal to
00:04:10s dot
00:04:11employee
00:04:12id
00:04:13a
00:04:14a
00:04:15a
00:04:16a
00:04:17a
00:04:18a
00:04:19a
00:04:20a
00:04:21name
00:04:22s
00:04:23yes
00:04:24s
00:04:25a
00:04:28d
00:04:30yet
00:04:31s
00:04:32us
00:04:34a
00:04:35g
00:04:37a
00:04:38a
00:04:40a
00:04:41b
00:04:45l
00:04:47h
00:04:48Yeah, it's going to be done.
00:04:50Yes, I understand.
00:04:56It's okay.
00:05:00But if it's going to be a cross-join, it's going to be wrong.
00:05:03No, it's okay. It's not going to happen. I'm telling you.
00:05:06Yes.
00:05:09Now go to total cell, comma, as.
00:05:13As total sales amount.
00:05:25Yeah.
00:05:26As a total sale.
00:05:41Yeah.
00:05:43Oh, yeah.
00:05:45Yeah.
00:05:46Yeah.
00:05:47Yeah.
00:05:48I'm a chair group baby talk Anna Anna pull out colleges and group by
00:06:10I have a copy of the video and play I'm free I don't eat in
00:06:15Oh
00:06:18Oh
00:06:19Okay
00:06:21Yes
00:06:22Actually
00:06:24Well
00:06:25It's
00:06:26I want it
00:06:27I want it
00:06:28That would be a total sales
00:06:28But I don't want it
00:06:29It would be a month-waves
00:06:30It would be a month-waves
00:06:31I write it
00:06:32I don't want it
00:06:33The month-waves
00:06:36Monthly sales
00:06:37I want it
00:06:38Then, you will
00:06:39to make the date of month to make sure that has a bill could be
00:06:43concerned about it
00:06:45is a month to call him he will have to do it
00:06:48I am a month to school next time
00:06:52religious from one of the park home the line or enter
00:06:55of the justice public
00:06:58I have a link to
00:07:00the service of the answer it has a nice comment
00:07:04first month. So, what do you want to do for the month?
00:07:12For the month?
00:07:14For the month name?
00:07:19For the month date?
00:07:25For the month date name?
00:07:29Okay, and here we need
00:07:40SalesDate
00:07:50The month date name?
00:08:00The month date name?
00:08:03The month date name?
00:08:07The month date date name?
00:08:18The month name?
00:08:20Okay, the month date name?
00:08:28travel dinner nai sir
00:08:34yeah
00:08:36as a month
00:08:38month name to
00:08:40school here
00:08:42group by me jaga
00:08:44yes sir
00:08:46looking
00:08:48to go over
00:08:50yes
00:08:52why you measure question
00:08:54oh
00:08:56is
00:09:02I
00:09:04I
00:09:08I
00:09:10I
00:09:12I
00:09:14I
00:09:16I
00:09:18I
00:09:20I
00:09:22I
00:09:24I
00:09:26Where is the devil?
00:09:28He's coming back and forth.
00:09:30Where is he coming back and forth?
00:09:32Okay, okay. I understand, sir.
00:09:34It's true.
00:09:36He's coming back to one or two.
00:09:38He's working here.
00:09:40Okay.
00:09:42Now...
00:09:44Month name is coming.
00:09:46Month name is coming.
00:09:48Then give him a sales name.
00:09:52I can't do anything.
00:09:54When he sees it,
00:09:56he looks good.
00:10:02Now...
00:10:04Now...
00:10:08It's been broken.
00:10:10And he averaged it.
00:10:12There is a result.
00:10:16Yes.
00:10:18and s dot
00:10:21what is the sale amount
00:10:25that is given
00:10:26is given
00:10:27and
00:10:28I don't know how to do it.
00:10:58I will see it in one second.
00:11:02What is the ID 1?
00:11:06Select star from sales where
00:11:12implied ID is equal to 1.
00:11:17So, the ID is charged.
00:11:21So, January and February is different.
00:11:27Yes, sir.
00:11:32Okay, this is January.
00:11:38January is equal to 1.
00:11:41So, the ID is equal to 1.
00:11:44And the ID is equal to 4.
00:11:48So, the ID is equal to 4.
00:11:51So, the ID is equal to 1.
00:11:55Yes, sir.
00:11:57So, this is the total sale.
00:12:00And the ID is equal to 1.
00:12:02So, the ID is equal to 1.
00:12:04So, the ID is equal to 1.
00:12:06So, the ID is equal to 1.
00:12:12This is the total sale.
00:12:15So, the ID is equal to 2.
00:12:19So, it is equal to 2.
00:12:21Department के base पर rank within rank imply within department based on total total
00:12:28sale के base पर इसमें ranking निकालना है और department रेंक इंपलाई हां इस
00:12:36department जो जिस department में है कि उस department के base पर है मतलब अगर
00:12:45किसी department में दो बंदे है तो उस दोनों का आपस में होगा तो पहले तो मैंने इसी का
00:12:52copy कर लिया ठीक है तो इंपलाई ID रहने दो रहने देता हूं और इंपलाई नाम केवल नाम रहने दो
00:13:06और यह सेल्स नाम मन्त के हटा दिया क्योंकि यह क्या कह रहा है
00:13:22कि एक कह रहा है कि अबरेज की सर्जिक रिक्वार्मेंट नी आवरेज वाले प्याटा दिजिए
00:13:29कि अबरेज का है टोटल सेल तो होगा है कि एवरेज हट गया है
00:13:42कि यह हो गया यह है कि रैंक इंपलाई बिद्धिन है डिपार्टमेंट रैंक का फॉर्मला लगा दिजिए बस संके बाद और कुछ निदिक्वार्मेंट नीए
00:13:53इस नीचे वाले में हमने जो गुरुब बाय में डिपार्टमेंट निम वाला अटाती जी ओडिट निम स्वरी थीक है यह तक से अरे कैसे ठीक है भए
00:14:06अब इसमें रेंक तो यूज़ करना बसाब लिपार्ट ठीक हमें मान गया अच्छा अच्छा रुकिया अ
00:14:16अ रुकिया अ
00:14:19इसमें डिपार्टमेंट कहा या है अधु वही तो से डिपार्टमेंट का एक कॉलम ने लिजिए ना
00:14:26अर रेंक लगा दिजिए बस अधिपार्ट यह डॉट अधु अधु यूज़ साथ अधु अधू फूट किसे नाम से है
00:14:40समसे पहले से कॉमा लगा लीजिए उस लाड़े यह तो
00:14:42E. Department Department
00:14:53Employee name is again
00:14:55E. Department
00:15:09is
00:15:13okay
00:15:14now three departments
00:15:17are
00:15:17ranked
00:15:19implied
00:15:20within each department
00:15:22is
00:15:23sales
00:15:25sales
00:15:26to
00:15:26kuch
00:15:26is
00:15:26not
00:15:26yet
00:15:27now
00:15:28comma
00:15:33now
00:15:34what
00:15:34is
00:15:35here
00:15:35is
00:15:37sir
00:15:39and rank
00:15:41rank
00:15:43over
00:15:45over
00:15:47over
00:15:49total
00:15:51department
00:15:53sorry
00:15:55department
00:15:57break
00:15:59total
00:16:03sales
00:16:05imply id
00:16:07ii
00:16:09ii
00:16:11ii
00:16:13ii
00:16:15ii
00:16:17ii
00:16:19ii
00:16:21ii
00:16:23ii
00:16:25ii
00:16:27ii
00:16:29ii
00:16:31ii
00:16:33ii
00:16:35ii
00:16:37ii
00:16:39ii
00:16:41ii
00:16:43ii
00:16:45ii
00:16:47ii
00:16:49ii
00:16:51ii
00:16:53ii
00:16:55ii
00:16:57ii
00:16:59ii
00:17:01ii
00:17:03ii
00:17:05ii
00:17:07ii
00:17:09ii
00:17:11ii
00:17:13ii
00:17:15ii
00:17:17ii
00:17:19ii
00:17:21ii
00:17:23ii
00:17:24ii
00:17:25ii
00:17:43TTS
00:17:50silly
00:17:52a
00:17:53a
00:17:54a
00:17:57a
00:18:00a
00:18:01a
00:18:02a
00:18:04a
00:18:05a
00:18:06a
00:18:08a
00:18:09a
00:18:10a
00:18:15Oh
00:18:16sorry
00:18:19Oh
00:18:21okay
00:18:22a
00:18:23a
00:18:30I
00:18:32I can see here I can take a look at me off the key condition of the image was ending
00:18:41You need to have to fix it.
00:18:46He's here.
00:18:48Is this right?
00:18:50Yes, he's in the cell.
00:18:52Bob's in the cell.
00:19:11I don't know.
00:19:41Compute a running total of sales per department order by total sales.
00:20:00Compute a running total.
00:20:04Compute a running total sales.
00:20:11Order by total sales.
00:20:18Is this going to be going to run?
00:20:23I don't know how much to go with this.
00:20:38Compute a running total of sales per department order wise total sales.
00:21:02Okay Sanjeev?
00:21:09Yes sir.
00:21:12What are you saying?
00:21:14The name of the department is running total sales and running total sales.
00:21:23Running total or total sales.
00:21:27We have two columns.
00:21:29The department wise is coming in.
00:21:34I can be put in the employee ID directly.
00:21:38This name is supposed to be put in the employee ID.
00:21:43To the department.
00:21:47do this level of my department oh my name is a department she met her first
00:21:53waller has to select your be select e.
00:22:00is this cool checker then the department of the alert table
00:22:03banana data neto or for us oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh oh
00:22:13e.department and here is the name of the department and after that is the name of the department.
00:22:22Okay?
00:22:25And I will remove this.
00:22:31And I will remove the name of the department.
00:22:42And there is three departments.
00:22:49And there is three departments.
00:22:53If we will give the name, we will see it later.
00:22:56Now this is the name of the department.
00:23:00Now this is the total of the department.
00:23:03So, sum.
00:23:07And here is the name of the department.
00:23:14And here is the name of the department.
00:23:21And here is the name of the department.
00:23:25And here is the name of the department.
00:23:32And here is the name of the department.
00:23:34And here is the name of the department.
00:23:37And this is the name of the department.
00:23:41I think some of sales amount of partition.
00:23:43Partition is going to happen.
00:23:46Is it that one will happen?
00:23:50Partition is going to happen.
00:23:53We don't do partition.
00:23:54We will run a little bit.
00:23:56So running tatter.
00:23:58Over and over order by the sum of sales amount.
00:24:02That's right.
00:24:03I think that it will succeed.
00:24:08I don't want the sum of the sum, but I don't want the sum of the sum of the sales amount.
00:24:25I don't want the sum of the sum.
00:24:29I am going to put the department in the partition.
00:24:35That is what I am talking about.
00:24:36Partition will go.
00:24:37It will not go.
00:24:39Sales dollars, sales amount.
00:24:47Sales amount.
00:24:50It will not go.
00:24:57Partition will go.
00:24:59Partition will go.
00:25:00Partition will go.
00:25:03Partition will go.
00:25:05Department will go.
00:25:10Order will go.
00:25:12Group buy ?
00:25:22Group buy ?
00:25:24Group buy ?
00:25:25Partition buy ?
00:25:29Group buy ?
00:25:31icamente...
00:25:32Thanks for...
00:25:33Group buy ?
00:25:37Group buy ?
00:25:40we are taking it, same department, some tell total sales, some sales amount of her
00:25:50partition by e.department, order by
00:25:57.
00:26:14.
00:26:23no, but where did you get the running total?
00:26:28Yes sir, you can get the partition by department.
00:26:34If I do this, I will sum it here.
00:26:40This is the order for me, sir.
00:26:45That's right.
00:26:51is
00:26:56the partition by data
00:26:57the order of running total
00:27:00part of the mission
00:27:00I'm going to go
00:27:07I'm going to go
00:27:09I'm going to go
00:27:11I'm going to go
00:27:13running total group by hat
00:27:14I'm going to go
00:27:15and if I'm going to
00:27:17apply
00:27:19name
00:27:19I will put it in the description.
00:27:23I will put it in the description.
00:27:26What is that?
00:27:29A.Employees.
00:27:31I will put it in the description.
00:27:33It is a name.
00:27:35It is a name.
00:27:37It is a name.
00:27:39It is a name.
00:27:41One second.
00:27:43One second.
00:27:45A, first of the time.
00:27:47Time.
00:27:51I will try my history in the first place.
00:27:53I will put it in the back.
00:27:56But.
00:27:58That is a name for me.
00:28:00Got it.
00:28:03I will not do it again.
00:28:06It will come.
00:28:09Here I am.
00:28:12It is not done for me.
00:28:14This is the running total and this is the running total.
00:28:20Let's go.
00:28:26Perform month over month completion, previous month sale, difference from current month.
00:28:38This is the running total.
00:28:44Let's go.
00:28:48Let's go.
00:28:54Let's go.
00:28:58Let's go.
00:29:02Let's go.
00:29:06Let's go.
00:29:16How is it going?
00:29:20Here.
00:29:24I don't like you don't know why are you but for me month over month completion previous month
00:29:33sales a difference from current month month to do he had January February he had so I'll be
00:29:39to join to go to month-wide sales sales sales sales sales sales sales sales sales sales sales
00:30:01if employee name is not required, then employee ID is not required.
00:30:06So, the total will go.
00:30:08After that, we will do the insert.
00:30:10So, select employee ID is here.
00:30:15Okay, we are ignoring it.
00:30:18So, date, name, month.
00:30:25No, no.
00:30:26Employee name is not required.
00:30:30Employee ID is not required.
00:30:32Employee ID is not required.
00:30:34Perform month, over month, completion, previous sales, or different sales.
00:30:39Okay, let's go.
00:30:40There is no requirement.
00:30:42But, if there are two, then we will do it.
00:30:45We will do it.
00:30:47Employee ID
00:30:50or
00:30:52S dot
00:30:57Sales dot
00:30:59Sales dot
00:31:00Sales.
00:31:01Sales
00:31:02Date
00:31:03or
00:31:04Sales
00:31:05Date
00:31:06Sum
00:31:07S dot
00:31:08Sales
00:31:11Amount
00:31:13From
00:31:14Sales
00:31:18Sales
00:31:20Sales
00:31:21S
00:31:33on
00:31:34E dot
00:31:35E dot
00:31:37Ton an вопрос
00:31:39from
00:31:41As
00:31:42They
00:31:44might
00:31:45Find
00:31:47Oh
00:31:53Oh
00:31:57sales
00:32:00it's a group by my user one as an employee ID or a cut month name
00:32:03Yes, sir, I have to add an alliance name, so you can add it.
00:32:11Employee table, sir, we are using sales table.
00:32:15Yes, sir, group by employee ID.
00:32:17Yes, sir.
00:32:18Yes, sir.
00:32:20Date name, I have to copy it.
00:32:23Yes, sir, I think it's a little bit of a question.
00:32:30No, no, I think everything is okay.
00:32:33Select.
00:32:38Yes, sir.
00:32:40Yes, sir, I am going to write here.
00:32:44I am going to write here.
00:32:47Yes, sir, I am going to write here.
00:32:54Order by employee ID and your name name.
00:32:59Order by employee ID.
00:33:06And then after that, you will write your name.
00:33:10nd.
00:33:21I am so happy.
00:33:24Yes, sir.
00:33:26All of this, I know,
00:33:30but, yes, it is time to write there.
00:33:31Ah wait.
00:33:32foreign
00:33:46foreign
00:34:02Is your ascending?
00:34:07Is it not?
00:34:12We don't know...
00:34:15The alphabet is being processed with this alphabet...
00:34:18I am going to do this...
00:34:23Let's do this...
00:34:29order by is coach for care date name nahi leke
00:34:34he is a helper there is a house sales date on the number check was
00:34:40sell sell date keung galatera
00:34:47sell dating hapaham nahi le saktay
00:34:53I am not sure how to do it.
00:34:58It's not possible to come from order.
00:35:01I'm not sure how to do it.
00:35:05I'm not sure how to do it.
00:35:10It's not that I'm not sure how to do it.
00:35:14I have given it.
00:35:17is
00:35:19yeah
00:35:20yeah
00:35:21yeah
00:35:22month
00:35:23we will
00:35:24go
00:35:25yeah
00:35:26no
00:35:27not
00:35:28not
00:35:29not
00:35:30not
00:35:32not
00:35:34where
00:35:35where
00:35:36where
00:35:37where
00:35:38is
00:35:39how
00:35:40Yes, if we do here, where is the problem?
00:35:52Okay, so here we are saying that we have to take a month from here.
00:36:01Sir, we have to take a month from here.
00:36:07Let me take it with you.
00:36:11Will he take it?
00:36:15He will take it here.
00:36:17I don't like it.
00:36:30Did he say this?
00:36:32Let's see.
00:36:34Where did he take it?
00:36:37The group are going to fit in the group by.
00:36:41We will take it in the group by.
00:36:43We will take it on the group by.
00:36:45No, not on the group.
00:36:47Let's stop.
00:36:49Let's do it.
00:36:51Let's do it.
00:36:53Let's do it.
00:36:55Let's do it.
00:36:57I'm doing it.
00:36:59I'm doing it.
00:37:01The group is closing.
00:37:03The group is closing.
00:37:05is it okay?
00:37:10Yes sir, the requirement is not required.
00:37:14It's a comma, sir, it's a comma.
00:37:19The name of the name is comma.
00:37:22Yes, it's okay.
00:37:24It's been a good employee ID.
00:37:29but this is the one thing I wrote about on which basis is the important thing
00:37:38on the month but this is on the basis of the basis of the basis of the basis of the
00:37:44employee ID is divided by the point of the education of the employee ID is a great
00:37:50by order by me and select the other two months ago then we will see that
00:37:57okay let's do that we will do that we will do it
00:38:02we will do this on the apply base
00:38:08then we will do it
00:38:11we will do it
00:38:16Harry Potter yeah son total sale and I'll say here
00:38:23can I lay function treasures little I'll
00:38:27get a picture of all us not Hey
00:38:30a sorry which one of our teachers
00:38:34like it like a living picture of a man
00:38:37on the leg leg make a tree
00:38:41okay one one dollar one switcher hum a previous a month in a bus
00:38:49oh ma
00:38:53oh sir yeah you tell you some of sin
00:38:56oh hey as you wanna sir
00:39:00oh hero or
00:39:04oh thank god over chillah kushka
00:39:06is
00:39:08a
00:39:10a
00:39:12a
00:39:14a
00:39:16a
00:39:18a
00:39:20a
00:39:22a
00:39:24a
00:39:26a
00:39:28a
00:39:30a
00:39:32a
00:39:34a
00:39:36a
00:39:38a
00:39:40a
00:39:42a
00:39:44a
00:39:46a
00:39:48a
00:39:54a
00:39:56a
00:39:58a
00:40:00a
00:40:04a
00:40:06sales
00:40:08amount
00:40:10one
00:40:12zero
00:40:14zero
00:40:16zero
00:40:18one
00:40:20partition
00:40:24imply id
00:40:26yes sir
00:40:28partition
00:40:30what
00:40:32imply
00:40:34imply
00:40:36id
00:40:38or
00:40:40order by
00:40:42sales
00:40:44date
00:40:46and
00:40:48i
00:40:50month
00:40:52month
00:40:53sales date
00:40:54month
00:40:55function
00:40:56or
00:40:57sales date
00:40:58oh
00:41:00oh
00:41:02oh
00:41:04oh
00:41:06oh
00:41:08oh
00:41:10oh
00:41:12oh
00:41:14oh
00:41:16oh
00:41:18oh
00:41:20oh
00:41:22oh
00:41:24oh
00:41:26oh
00:41:28oh
00:41:30oh
00:41:32oh
00:41:34oh
00:41:36oh
00:41:38oh
00:41:40oh
00:41:42oh
00:41:44oh
00:41:48oh
00:41:50oh
00:41:52oh
00:41:54oh
00:41:56oh
00:42:00oh
00:42:02oh
00:42:04oh
00:42:08oh
00:42:10oh
00:42:12oh
00:42:16oh
00:42:20oh
00:42:22and here I am going to show some sale amount
00:42:31Let's see what comes from the edge
00:42:39I am
00:42:41I am
00:42:43I
00:42:45I
00:42:47I
00:42:49I
00:42:51I
00:42:53I
00:42:55I
00:42:57I
00:42:59I
00:43:05I
00:43:07I
00:43:09I
00:43:11I
00:43:13I
00:43:15I
00:43:17I
00:43:19I
00:43:21I
00:43:23I
00:43:25I
00:43:31I
00:43:33I
00:43:35I
00:43:37I
00:43:39I
00:43:41I
00:43:43I
00:43:45I
00:43:47I
00:43:49I
00:43:51I
00:43:53I
00:43:55I
00:43:57I
00:43:59I
00:44:01I
00:44:03I
00:44:05I
00:44:07I
00:44:09I
00:44:11I
00:44:13I
00:44:15I
00:44:17I
00:44:19I
00:44:21I
00:44:23I
00:44:25I
00:44:27I
00:44:29I
00:44:31I
00:44:33I
00:44:35I
00:44:37I
00:44:39I
00:44:41I
00:44:43I
00:44:45I
00:44:47I
00:44:49I
00:44:51I
00:44:53I
00:44:55I
00:44:57I
00:44:59I
00:45:01I
00:45:03I
00:45:07I
00:45:09I
00:45:11I
00:45:13I
00:45:15I
00:45:17I
00:45:19I
00:45:21I
00:45:23I
00:45:25I
00:45:27I
00:45:29I
00:45:31I
00:45:33I
00:45:35I
00:45:37I
00:45:39I
00:45:41I
00:45:43I
00:45:45I
00:45:47I
00:45:49I
00:45:51I
00:45:53I
00:45:55I
00:45:57I
00:45:59I
00:46:01I
00:46:03I
00:46:05I
00:46:07I
00:46:09I
00:46:11I
00:46:13I
00:46:15I
00:46:17I
00:46:19I
00:46:21I
00:46:27I
00:46:29I
00:46:31I
00:46:33I
00:46:35I
00:46:37I
00:46:39I
00:46:41I
00:46:43I
00:46:45I
00:46:47I
00:46:49I
00:46:51I
00:46:53I
00:46:55I
00:46:57I
00:46:59I
00:47:01I
00:47:03I
00:47:05I
00:47:07I
00:47:09I
00:47:11I
00:47:13I
00:47:15I
00:47:17I
00:47:19I
00:47:21I
00:47:23I
00:47:25I
00:47:27I
00:47:29I
00:47:31I
00:47:33I
00:47:35I
00:47:37I
00:47:39I
00:47:41I
00:47:43I
00:47:45I
00:47:47I
00:47:49I
00:47:51I
00:47:53I
00:47:55I
00:47:57I
00:47:58I
00:47:59I
00:48:00to
00:48:01I
00:48:02I
00:48:03I
00:48:04I
00:48:06I
00:48:10I
00:48:11I
00:48:12I
00:48:13I
00:48:14I
00:48:15month, sales, comma, this is how we minus the total sale, current month, sale, or minus
00:48:30last month?
00:48:31Yes, sir, yes, sir, total sale minus last month.
00:48:41Yes, sir, as a different sale, as a different sale, as a different sale, it's okay, it's
00:49:01okay, it's okay, it's okay.
00:49:06So, it's on apply .
00:49:08So only those departments whose sales exceed 1 lakh classified implied as
00:49:37top performance, okay, okay, okay, okay, okay, okay, okay, okay, okay,
00:50:07okay, okay, okay, okay, okay, okay, okay, all right, so just choose too.
00:50:19But, Lite somewhat covered here on the five-row basis and
00:50:24the four per
00:50:33department
00:50:43department
00:50:44is up
00:50:45in the upper
00:50:46section
00:50:47in the upper
00:50:48section
00:50:49select
00:50:50start from
00:50:54imply
00:50:57simply e. department or some
00:51:12yeah, say it.
00:51:15No, it's okay sir, but we are doing all department.
00:51:22so only do department which department can now
00:51:31tell me to tell you, so you will also have a name for the top performance, so you can
00:51:38also have a name for the person, so you can also have a name for the person, so I have
00:51:44a name, so I have to say this, we have to add this, select star for, select star,
00:51:50your sales, start, start, tell me, start, why are you taking it, start, why are you taking
00:52:00áriy ṣr ڈال'ि ṣr । �r ૫r ૫r ૫r ૪ ૫r ્ડ ૫r � હ�r ૃ ત્ હ ફr ્ડ � t'૨ેમ હ�r ૧ર સ હેવડ હૂડ સ્ડ સેર્ત મે હાતરર્ત્ત હ્ડ �
00:52:30I don't know the group.
00:52:32I think that we put a condition in which the total sales department exists.
00:52:40So, first, we put total and then we put having.
00:52:44It will be like this.
00:52:46Yes, yes.
00:52:48I will do this.
00:52:50If I do this, I will do this.
00:52:52E.Department.
00:52:54Join us.
00:52:56Or.
00:53:00S dot.
00:53:04Sales amount.
00:53:08On E dot.
00:53:10Imply ID.
00:53:12S.
00:53:16Dot.
00:53:18EM.
00:53:20Is it ok?
00:53:22Yes.
00:53:24It's not.
00:53:26Where is it?
00:53:28Where is it?
00:53:30Where is it?
00:53:32Where is it?
00:53:34It's equal to on.
00:53:36There is comma.
00:53:38It's not.
00:53:40.
00:53:47.
00:53:54.
00:53:59.
00:54:04.
00:54:09I am playing in need
00:54:21Okay?
00:54:23Okay sir
00:54:25It's coming from here
00:54:27Now
00:54:31It's coming
00:54:33Now
00:54:35Having a condition
00:54:37It is popping
00:54:39You can start charging
00:54:41Okay, let's start
00:54:43Then I will start charging
00:54:45We can start charging
00:54:47Some amount of amount
00:54:51Greater than
00:54:57Is this coming from here
00:55:01Yes sir
00:55:03And now we're saying
00:55:05The average department and person is the person with the department and person.
00:55:26I am saying that if you are in this department, the average,
00:55:38okay? Yes sir.
00:55:41If you are doing the average, one will go down, that will be the top, but not below.
00:55:49What do you have to write?
00:55:55TTL sales.
00:56:04Do you have to write it in CT?
00:56:09Do you have to write it in CT?
00:56:14No sir, question is, but do you have to write it in CT?
00:56:20Now, we have to show this in total sales.
00:56:24The top performer is the top, or below?
00:56:32What do you mean by the top?
00:56:35Yeah, tell me, compare.
00:56:38Just compare it?
00:56:40Compare, compare, compare.
00:56:41The average of sales, this in total,
00:56:46the average of sales, this in total?
00:56:49average now sales means a two
00:56:54yes sir
00:56:55yes he in these two average
00:56:57between the average
00:57:00which is more average
00:57:04it will be back
00:57:06the top and the below
00:57:07will be back
00:57:08sir it and sales
00:57:10no not
00:57:12sales
00:57:13department
00:57:14that
00:57:15sales
00:57:16there are two
00:57:17people
00:57:19Oh, yes.
00:57:20Now, the average will become one?
00:57:23Yes.
00:57:24So, the average will be more than the top and the lower than the top.
00:57:32Yes.
00:57:33Is that okay?
00:57:38The average will be easy, but it will go down city.
00:57:43So, average?
00:57:47Yes.
00:57:48Know, we will just call it.
00:57:51It's not only the average?
00:57:54Average?
00:57:57Is that correct?
00:57:59Yes.
00:58:00You have to call it.
00:58:04Yes.
00:58:05I have to call it.
00:58:08You do the total.
00:58:16foreign
00:58:23foreign
00:58:28foreign
00:58:33foreign
00:58:44foreign
00:58:48department
00:58:55is
00:58:56just
00:58:58just
00:59:00Let's go, this is the order in the order.
00:59:06If you put it in the order, there will be some benefit from it.
00:59:09No, no, no, no, no, no.
00:59:11Put the name of the column.
00:59:13No, sir.
00:59:15No, sir.
00:59:16No, sir.
00:59:17No, sir.
00:59:18No, sir.
00:59:19No, sir.
00:59:20No, sir.
00:59:21No, sir.
00:59:23No, sir.
00:59:27Now, we have to make it popular.
00:59:31I try to change the floor keep everything there.
00:59:34Yes.
00:59:35I make up?
00:59:37And do this plan to go small.
00:59:41Yes sir.
00:59:42Yes sir.
00:59:44No, sir.
00:59:45No, sir.
00:59:46Okay, it's easier to subtract everyone.
00:59:52Let's writehes.
00:59:54Setup.
00:59:55okay
00:59:59this minute
01:00:09I am
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: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:34I
01:02:36I
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:28I
01:03:30I
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: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: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: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:10I
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
01:08:40I
01:08:42I
01:08:44I
01:08:46I
01:08:48I
01:08:50I
01:08:52I
01:08:54I
01:08:56I
01:08:58I
01:09:00I
01:09:02I
01:09:04I
01:09:06I
01:09:08I
01:09:10I
01:09:12I
01:09:14I
01:09:20I
01:09:22I
01:09:24I
01:09:26I
01:09:28I
01:09:30I
01:09:32I
01:09:34I
01:09:36I
01:09:38I
01:09:40I
01:09:42I
01:09:44I
01:09:46I
01:09:48I
01:09:50I
01:09:52I
01:09:54I
01:09:56I
01:09:58You
01:09:58I
01:10:12compared to
01:10:14a
01:10:16i
01:10:18in
01:10:19a
01:10:20oh
01:10:26oh yeah
01:10:28I have a
01:10:30I'm
01:10:32I'm
01:10:34and subject
01:10:36I
01:10:38I
01:10:40I
01:10:42I
01:10:44I
01:10:46I
01:10:50Okay, let's close your hands.
01:10:57Okay, let's close your hands.
01:11:02Okay, sir.
01:11:03Power BI is still here.
01:11:05If you have time, please tell me.
01:11:07One second.
Be the first to comment