Skip to playerSkip to main contentSkip to footer
RAKESH KUMAR
  • 6/2/2025
10 SQL Practice Session 18 May 2025

source file :--https://drive.google.com/file/d/1Xh_Kkenf2vqXKjoaVEfgmnTDUhqlaU4K/view?usp=sharing

Link for whatsapp - https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
Transcript
00:00:00I don't have a lot of dates, but I have some questions that I have done, okay?
00:00:07Okay.
00:00:10Is it an adventure work or a data set?
00:00:16No, sir.
00:00:19I have told you in class, so I have done a data set.
00:00:25Okay, I got a lot of data sets.
00:00:32There are some questions that I have come to.
00:00:36There are many tables.
00:00:39When I go here, there are many tables installed in the system.
00:00:48All these are all?
00:00:50Yes, sir, I will give you a lot of questions.
00:00:53I will give you a lot of questions.
00:00:56Let's start this question.
00:01:00Let's see.
00:01:02Let's see.
00:01:03I have to ask about the data set.
00:01:05Let's see.
00:01:06I have to ask about data set.
00:01:09I have to ask about data set.
00:01:11Let's see.
00:01:12Let's save this.
00:01:13Write a query to generate the report, and in the report, you need to display an additional column as the report generated date.
00:01:35What does it mean?
00:01:36What does it mean?
00:01:37That when we make a report, then after that, in the last column, the report generated date should come to the report generated date.
00:01:50What will the report generated date happen?
00:01:52No, sir.
00:01:53Let's do this.
00:01:54I am going to create a date.
00:01:55Will you get a date date?
00:01:56Yes.
00:01:57To create a date?
00:01:58I will get a date, sir.
00:01:59What do you do?
00:02:00Yes, sir?
00:02:01Get a date.
00:02:02Yes, yes, get date date.
00:02:04I am a local which will be the code banana mainly mainly a mainly table is select star
00:02:10from the name of the customer in the customer make a milk milk status
00:02:19the select count and select marital marital status from dim customer
00:02:38group by mar status
00:02:52Yes sir.
00:02:53This report we are going to be made today.
00:02:57In this bagel, we need one.
00:03:03Emeritable status.
00:03:06Coma.
00:03:08Count.
00:03:11I think this report was done.
00:03:15Yes sir.
00:03:16We have counted.
00:03:19I will create a date column in the last column, then tell me what I will write.
00:03:26Koma?
00:03:28Sir, get date?
00:03:30Just.
00:03:32Do you have any name of the column?
00:03:35Just.
00:03:36The name of the column is written here.
00:03:39The name of the column is written here.
00:03:42Just add this.
00:03:44Did you get it?
00:03:50Yes.
00:03:51If we update this type, what is our date date?
00:03:55Current date?
00:03:57Current date.
00:03:59Yes.
00:04:00Yes.
00:04:01Yes.
00:04:02Yes.
00:04:03Yes.
00:04:05Yes.
00:04:07Yes.
00:04:09Yes.
00:04:11Yes.
00:04:12Yes.
00:04:13Yes.
00:04:14Since it's your name, what is trailer, it's not yesterday till it's gone.
00:04:18Would you say the meaning of this?
00:04:19This has been a total number of new information.
00:04:20The purchase siteх╗вуВКуБ╛уБЧуБЯ.
00:04:21If run after the purchase site, you can buy it.
00:04:23If you can buy it.
00:04:25Just check your new information.
00:04:26Trust your app, where do you have any additional information?
00:04:27The purchase site.
00:04:28No?
00:04:29No?
00:04:30No?
00:04:31No.
00:04:32Is Gathering module there.
00:04:33The purchase site join now?
00:04:34If you recall, anyone from,,,You....
00:04:36You areppenfeldorfotto, it.
00:04:37Right.
00:04:38If you recall.
00:04:39From there, it is the table.
00:04:40this is a rate of record
00:04:48рдХрд┐ рдЗрдиреНрдкреВ рддреЛ рдпрд╣ рдиреНрд░реВрдЯ рдХрд░ рд▓рд┐рдП рдЗрд╕рд░реЗ рдмрдВрджреЗ рдиреЗ рдХрд░ рд░рд╣рд╛ рддрдм рдХреА рд░рд┐рдЬрд╛рдиреНрдЯ рд╕рд┐рдд рдЕрдм рджреЗ рдЖрдкрдХреЛ рдмрддрд╛ рд╣реИ рдХрд┐ рдЗрд╕рдХрд╛ рд▓рд╛рд╕реНрдЯ рд╣реЛрдЧреЛрдВ рдХрдн рд╣реЛрдЧрд╛
00:05:06and as per company policy 90 days notice period
00:05:10is
00:05:11so
00:05:12I
00:05:14am
00:05:15I
00:05:18am
00:05:20I
00:05:22am
00:05:23I
00:05:24am
00:05:25I
00:05:26am
00:05:27I
00:05:29am
00:05:30I
00:05:31am
00:05:32I
00:05:34would
00:05:36add
00:05:37that
00:05:41a
00:05:42a
00:05:44a
00:05:45a
00:05:47a
00:05:48a
00:05:49a
00:05:52a
00:05:54a
00:05:55a
00:05:56a
00:05:57yeah
00:05:59no no
00:06:01you can do so
00:06:03oh
00:06:05yes
00:06:07yes
00:06:09oh
00:06:11oh
00:06:13oh
00:06:15oh
00:06:17oh
00:06:19Linkenbacher
00:06:49Linkenbacher
00:07:03Nor se ang dugo
00:07:12No, isu ?
00:07:17I see on screen
00:07:19I am going to share the skin.
00:07:35What is the skin?
00:07:45Why is the skin coming?
00:07:49What is it that I am including?
00:07:56Why is this skin coming?
00:08:00Is it?
00:08:02Let's take it in the residing date.
00:08:04If we will take the residing date,
00:08:07we will take 90 days.
00:08:09We don't need the residing date,
00:08:11we must be the last working date.
00:08:13No sir, it's that last working date?
00:08:15Put your residing date,
00:08:17to resign date рдХреЗ рдмрд╛рдж рдХреЙрдорд╛ рдбрд╛рд▓рд┐рдП рд╣рд╛рдБ рд╣рд╛рдБ рдЧреЗрдЯ рдбреЗрдЯ рдкреНрд▓рд╕ рдПрдЯреВ рдирд╛рдЗрди рд╣рд╛рдБ рд╣рд╛рдБ рд╣рд╛рдБ рд╣рд╛рдБ рд╣реИ рд▓рд╛рд╕реНрдЯ рд╡рд░реНрдерд┐рдВрджреЗ рдФрд░ рд╕рд░ рдЗрд╕рдореЗрдВ рдлрд┐рд░ рдбрд╛рд▓ рджреАрдП рд▓рд╛рд╕реНрдЯ рдореЗрдВ рд╡рд┐рдпрд░ рд╣реИ рдпрд╣ рддреЛ рдХрд╛рдо рддреЛ рдХрд░рдиреЗ рд░рд╣рд╛
00:08:47рд╕реНрдХрд╛рд░ рдХрд╛рд░рд░реЛрдВ рд╕рдмреНрд╕рдХреНрд░рд╛рдЗрдм рдХреНрдпреЛрдЧреА рдЕрдзрд┐рдпреБрдП рд╡реЛрд▓рд╕ рдПрдХ рдХрд┐ рдпреВрдЬ рдирд╛рд╡рд┐рдП рд╡реНрдпреЛрдкрд╛ рдбреАрдбрд┐рддрди рдЧрд┐рдпрд╛ рдХреЗ рдкрд╛рдиреЗ рдкреАрдЯреЛрдВ рдЖрд╢реНрдЯ рдЙрдЦрд┐рдПрд╡ рдирд┐рд╡рд╛рдЪреНрдкрд╛рд░реНрдпрд╛рд▓реАрдж
00:09:17okay
00:09:19I
00:09:21I
00:09:23I
00:09:25I
00:09:27I
00:09:31I
00:09:33I
00:09:35I
00:09:37I
00:09:39I
00:09:41I
00:09:43I
00:09:45I will give you a good sign today, so my notice will count on my own notice.
00:10:00Yes, it's 15 minutes.
00:10:02Yes, I'm telling you.
00:10:04It's 80-90, right?
00:10:08It's right.
00:10:09Yes, sir.
00:10:10It's gone.
00:10:15Write a query to display birthday, birth name and birth year from the birthday column using dim implied table.
00:10:35Dim implied table.
00:10:37Select star from dim implied.
00:10:41This data is fine.
00:10:43Here you can see.
00:10:47It's different.
00:10:49Okay?
00:10:50It's the date column.
00:10:52Birthday.
00:10:56Tell us how it will come.
00:10:57Yes, sir.
00:11:01This is a different one.
00:11:02I need to select.
00:11:10Formate to do it, sir.
00:11:12Formate to do it.
00:11:13Formate to do it.
00:11:14Formate to do it.
00:11:15Formate to do it as well.
00:11:17I have a date, month, year.
00:11:20Look, we need a different date, month, year.
00:11:29So, for the day, we have a birthplace.
00:11:35What is spelling?
00:11:37I have a date, month, year.
00:11:47This is the date, month, year.
00:11:53This is the date, month, year.
00:11:57This is the date, month, year.
00:12:12Your date recently already.
00:12:19How do you use the date part?
00:12:30First name, first name, first name, first name, first name, date part,
00:12:47and then the date part,
00:12:53once the date part,
00:12:57then the date is complete,
00:13:03the date is complete,
00:13:07the date part is complete,
00:13:15I am going to paste this part of the month.
00:13:22I am going to remove this part of the month.
00:13:32I am going to remove this part of the month.
00:13:39Again?
00:13:58Yes sir, it's done.
00:14:02It's done.
00:14:09It's done.
00:14:11It's done.
00:14:19Find the information which birthday is 1974.
00:14:25Find the information which birthday is 1974.
00:14:35So, it's done.
00:14:37It's done.
00:14:39It's done.
00:14:41It's done.
00:14:48It's done.
00:14:51It's done.
00:14:55It's done.
00:14:56You can't pick up the answer here.
00:15:02To my channel on our website, go to www.khodman.com,
00:15:19.
00:15:29.
00:15:40.
00:15:41.
00:15:42.
00:15:43.
00:15:48You need to count the number of implies based on their birth year.
00:16:10Did you understand the question?
00:16:12Is it simple?
00:16:14It's simple.
00:16:16Let me tell you it's simple.
00:16:18How will it happen?
00:16:22It's the same thing.
00:16:24Yes, it's the same thing.
00:16:26Yes, it's the same thing.
00:16:28Is it the same thing?
00:16:30Is it the same thing?
00:16:34Yes.
00:16:36My skin is gone.
00:16:38Okay.
00:16:40I'm sorry.
00:16:42Yes.
00:16:44Just select here.
00:16:46What is it?
00:16:48Yes, I'm sorry.
00:16:50Yes, I'm sorry.
00:16:52I'm sorry.
00:16:54Just hit it.
00:16:56Yes.
00:16:58Then just add here.
00:17:02as a total employee, and it has to be a total employee, and it has to be a total employee.
00:17:22So, let's get started.
00:17:27That's the year birth relief
00:17:53The recording has lost
00:17:57And I realized that this year,
00:18:05there are ten people.
00:18:09Yes sir.
00:18:12That's all.
00:18:14This is the question.
00:18:19All my questions are in mind, sir.
00:18:23Yes, tell me.
00:18:25We have 20-25,000,000 rows from our data from powerpairies.
00:18:30Okay sir?
00:18:32We have used the command to use,
00:18:35which has 20-25,000,000 rows from the table.
00:18:39And how will we go to Excel?
00:18:42No, it won't happen.
00:18:4425,000,000 to Excel won't happen.
00:18:47It won't happen.
00:18:49When one sheet is finished,
00:18:51then the other sheet will go to the other.
00:18:54It won't happen.
00:18:56But when it comes to power,
00:18:58then it won't happen.
00:19:00What is the easy method?
00:19:05You can copy paste it in Excel.
00:19:08Copy paste it.
00:19:10Copy paste it will also happen.
00:19:12If you see it,
00:19:14you can keep it in the CSV.
00:19:20You can copy paste it in the CSV.
00:19:22If you see it,
00:19:23you can copy it in the CSV.
00:19:24But the CSV will go to the CSV.
00:19:26It will automatically be generated.
00:19:28No, no, no.
00:19:30You can create a query in Power BI.
00:19:32You can create a query in Power BI.
00:19:34But why will it go to Excel in 25,000,000?
00:19:38It won't happen,
00:19:39but the same is running in Power BI.
00:19:40You can cut it in Power BI,
00:19:41and you're running out of Power BI.
00:19:42So you can quickly run it and run it.
00:19:44You can do it and run it and run it.
00:19:45If you've done it,
00:19:46a lot of data will run out.
00:19:47So it's up to the other page.
00:19:49You'll be running out the├кtu.
00:19:50I think I can reduce the number of groups and share the number of records.
00:19:53Yes, it will be possible.
00:19:56I think it will be possible.
00:19:58I think the number of records will get worse.
00:20:01Yes, sir, I will do that.
00:20:03But if you do not get the number of records,
00:20:05you will get the number of records in Excel.
00:20:07Do you think that it will happen in Excel?
00:20:10Yes, sir.
00:20:12Yes, sir.
00:20:14It will do XR.
00:20:16I will do XR.
00:20:17I will do XR.
00:20:18find the imply information who was born in December
00:20:27I asked all the people who were born in December
00:20:34I was born in December
00:20:49I was born in December
00:20:56is
00:20:58the
00:21:00one
00:21:02is
00:21:04equal to
00:21:0612
00:21:08all
00:21:10this is
00:21:12this is
00:21:14this is
00:21:16this is
00:21:18October
00:21:20November
00:21:22December
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:00I
00:22:02I
00:22:04I
00:22:06I
00:22:08I
00:22:10I
00:22:12I
00:22:14I
00:22:16I
00:22:18I
00:22:20I
00:22:22I
00:22:24I
00:22:26I
00:22:28I
00:22:30I
00:22:32I
00:22:34I
00:22:36I
00:22:38I
00:22:40I
00:22:42I
00:22:44I
00:22:46I
00:22:48I
00:22:50I
00:22:52I
00:22:54I
00:22:56I
00:22:58I
00:23:00I
00:23:02I
00:23:04I
00:23:06I
00:23:08I
00:23:10I
00:23:12I
00:23:14I
00:23:16I
00:23:18I
00:23:20I
00:23:22I
00:23:24I
00:23:26I
00:23:28I
00:23:30I
00:23:32I
00:23:34I
00:23:36I
00:23:38I
00:23:40I
00:23:42I
00:23:44I
00:23:46I
00:23:48I
00:23:50I
00:23:52I
00:23:54I
00:23:56I
00:23:58I
00:24:00I
00:24:02I
00:24:04I
00:24:06I
00:24:08I
00:24:10I
00:24:12I
00:24:14I
00:24:16I
00:24:18I
00:24:20I
00:24:22I
00:24:24I
00:24:26I
00:24:28I
00:24:30I
00:24:32I
00:24:34I
00:24:36I
00:24:38I
00:24:40I
00:24:42I
00:24:44I
00:24:46I
00:24:48I
00:24:50I
00:24:52I
00:24:54I
00:24:56I
00:24:58I
00:25:00I
00:25:02I
00:25:04I
00:25:06I
00:25:08I
00:25:10I
00:25:12I
00:25:14I
00:25:16I
00:25:18I
00:25:20I
00:25:22I
00:25:24I
00:25:26I
00:25:28I
00:25:30I
00:25:32I
00:25:34I
00:25:36I
00:25:46I
00:25:48I
00:25:50I
00:25:56I
00:25:58I
00:26:00I
00:26:02I
00:26:04I
00:26:06I
00:26:12I
00:26:14I
00:26:16I
00:26:18I
00:26:20I
00:26:22I
00:26:24I
00:26:25I
00:26:27I
00:26:29I
00:26:31I
00:26:33I
00:26:35I
00:26:37I
00:26:39I
00:26:41I
00:26:43I
00:26:45I
00:26:47I
00:26:49I
00:26:51I
00:26:53I
00:26:55I
00:26:57I
00:26:59I
00:27:01I
00:27:03I
00:27:05I
00:27:07I
00:27:09I
00:27:11I
00:27:13I
00:27:15I
00:27:17I
00:27:19I
00:27:21I
00:27:23I
00:27:25I
00:27:27I
00:27:29I
00:27:31I
00:27:33I
00:27:35I
00:27:37I
00:27:39I
00:27:41I
00:27:43I
00:27:45I
00:27:47I
00:27:49I
00:27:51I
00:27:53I
00:27:55I
00:27:57I
00:27:59I
00:28:01I
00:28:03I
00:28:05I
00:28:07I
00:28:09I
00:28:11I
00:28:13I
00:28:15I
00:28:17I
00:28:19I
00:28:21I
00:28:23I
00:28:25I
00:28:27I
00:28:29I
00:28:31I
00:28:33I
00:28:35I
00:28:37I
00:28:39I
00:28:41I
00:28:43I
00:28:45I
00:28:47I
00:28:49I
00:28:51I
00:28:53I
00:28:55I
00:28:57I
00:28:59I
00:29:01I
00:29:03I
00:29:05I
00:29:07I
00:29:09I
00:29:11I
00:29:13I
00:29:15I
00:29:17I
00:29:19I
00:29:21I
00:29:23I
00:29:25I
00:29:27I
00:29:29I
00:29:31I
00:29:33I
00:29:35╨╡╨║
00:29:37I
00:29:39I
00:29:41I
00:29:43I
00:29:45think
00:29:47I
00:29:49guess
00:29:50I
00:29:53I
00:29:55I
00:30:01I
00:30:02we can do this.
00:30:08But I can understand this.
00:30:13How do I do this?
00:30:162.5.
00:30:19There is no one or something.
00:30:22It's not an honor to claim.
00:30:28We will never see this tree from any other tree.
00:30:31We will never see this tree.
00:30:37It's all we keep doing.
00:30:39That's it.
00:30:49find the imply information who have greater or equal to 10 years of experience in the organization
00:31:02I am saying that all the people who have taken a list of 10 years of experience in the company
00:31:26Hey.
00:31:27Hey.
00:31:28Hey.
00:31:30Hey.
00:31:31Hey, I'm going to tell you how to do that.
00:31:38I'm going to select employee.
00:31:45I'm going to be a first.
00:31:47Hey, that's right.
00:31:48I'm going to select employee.
00:31:50I'm going to select employee.
00:31:52I'm going to select employee.
00:31:55I am playing first name.
00:32:02First name.
00:32:04First name.
00:32:05First name.
00:32:06And just so much.
00:32:08Now you can put it in the head.
00:32:10Sir, you can put it in the experience.
00:32:12Sir, put it in the formula.
00:32:15Sir, get dead.
00:32:18Break and start.
00:32:24Minus.
00:32:26Higher date.
00:32:28Bracket.
00:32:30Bracket.
00:32:32Bracket.
00:32:34Where?
00:32:36Get dead and higher date.
00:32:38Yes.
00:32:39And divided by 365.
00:32:44But this error is coming.
00:32:50Yes.
00:32:51I am.
00:32:52Yes.
00:32:53I am.
00:32:54Yes.
00:32:55Yes.
00:32:56And then we will use the date.
00:32:58Yes.
00:32:59Yes.
00:33:00Yes.
00:33:01Yes.
00:33:02Yes.
00:33:03Yes.
00:33:04Yes.
00:33:05Yes.
00:33:06Yes.
00:33:07Yes.
00:33:08Yes.
00:33:09Yes.
00:33:10Yes.
00:33:11Yes.
00:33:12Yes.
00:33:13Yes.
00:33:14No.
00:33:16Yes.
00:33:21Yes.
00:33:22I am.
00:33:24As a experience.
00:33:34Now, let me put a wear condition here.
00:33:39If I have to show high date, I will show high date.
00:33:45I am
00:33:47I
00:33:49I
00:33:51I
00:33:53I
00:33:55I
00:33:57I
00:33:59I
00:34:01I
00:34:03I
00:34:05I
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: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: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:31I
00:37:33I
00:37:35I
00:37:37I
00:37:39I
00:37:41I
00:37:43I
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: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: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:25This is the date part in DW, this will tell you the date part of which day is.
00:40:32By default, how does it start?
00:40:37Sunday is starting.
00:40:38Sunday is starting.
00:40:40Now, this is the date part.
00:40:43If you want to check your name, then I will do the date name DW.
00:40:51High date.
00:40:52Look, Saturday is 7 and Monday is 2.
00:40:58Right?
00:41:01Yes.
00:41:02So, what do we do?
00:41:04I will give you the date part of this line.
00:41:07And the date part is as join on Monday.
00:41:21Monday is written.
00:41:23And then copy it.
00:41:25And then go to the last line.
00:41:29Where?
00:41:30This is called to 2.
00:41:32Sunday is 1, then Monday is 2.
00:41:36Yes.
00:41:37And then do this work.
00:41:38Why do people?
00:41:39Do you want to choose this?
00:41:40Keep it in order to and continue.
00:41:41Do you want to make it like this?
00:41:42Yes, sir.
00:41:43Oh, that's good.
00:41:44I will give it the date name to you.
00:41:45This is the date name.
00:41:47And then practice this culture.
00:41:48It's all right?
00:41:49Yes.
00:41:50It's okay, right?
00:41:54Yes, sir.
00:41:56Oh, that's deep.
00:42:07It's okay.
00:42:09Right, security to display joining days of impolet. Joining days of impolet.
00:42:21Joining days of impolet.
00:42:23What does it mean?
00:42:24They joined days.
00:42:27So, days of impolet.
00:42:305-6 times?
00:42:32Yes, days of impolet.
00:42:34But they don't have to ask.
00:42:37So, simple is, sir.
00:42:40Higher date.
00:42:41If I just add date function, then join date.
00:42:45Join date.
00:42:48So, select.
00:42:53The top one will copy.
00:43:02Copy paste.
00:43:04Select impolet first.
00:43:07Date comes in place, sir.
00:43:09So, there is a place.
00:43:10Is this a place?
00:43:11Say it.
00:43:12Yes, sir.
00:43:13Where is the condition received all the times?
00:43:20I mean, the 28th.
00:43:21This is in the 21st.
00:43:22And this is in the 28th.
00:43:24This is in the 21st.
00:43:25No?
00:43:26Yes, sir.
00:43:27That's fine.
00:43:28okay
00:43:47find the details of an employee who has more than five years
00:43:53in the organization. Did you create this?
00:43:59This is the same thing as a designer, right?
00:44:01no, no.
00:44:02the experience is called for the month of the month,
00:44:07which we had made here the 15th year of the year.
00:44:10it was the same thing,
00:44:13it was the same thing.
00:44:15Yes, no no no.
00:44:21It was greater than 50% of the $100.
00:44:24Yes, yes?
00:44:26Yes.
00:44:29Yes, there was a few years ahead of the debt and the debt was also the same.
00:44:36so here we will give you 5 years, but here we will give you 5 years, but here we will give you 5 years.
00:44:43This is good.
00:44:49Find the details of imply who is more than 30 years old in age.
00:44:58In this data, everyone will be more than 30 years.
00:45:07Select a star from dim imply order by birth date.
00:45:18If I go to 1949, the maximum order by DSC.
00:45:29Order by DSC.
00:45:33Order by DSC.
00:45:37So, it is a year of birth date.
00:45:47It is a year of 1990.
00:45:49So, it is 30 years old.
00:45:50We will give you 40 years.
00:45:52It is a year of 40.
00:45:54Now, it is a year of 40.
00:45:56It is a year of 40.
00:45:58Now, let me tell you.
00:46:00Select a star from dim.
00:46:06I will copy it.
00:46:08No title.
00:46:10Dim imply.
00:46:12Select.
00:46:14Imply key.
00:46:16First name.
00:46:19First.
00:46:20Then, what is there?
00:46:23Now, we will add here.
00:46:25Dated is.
00:46:27Dated.
00:46:28Diff.
00:46:29And,
00:46:31Dated.
00:46:32Dated.
00:46:33A screengive.
00:46:38Again, join with joom.
00:46:41Dated.
00:46:44Ah ha ha I got a date this you have to
00:47:04this is a very good day and this is a good day and this is a good day
00:47:18birth date, comma, get date, bracket band also divided by 365, 365, as a age,
00:47:34age, around reply, where, I can copy this direct age, not yet, if I go here,
00:48:00I am not working.
00:48:07No, it's a data difference.
00:48:10No, it's not.
00:48:11It's not.
00:48:12Just give it.
00:48:13After the wear.
00:48:15Sorry, sorry, sorry.
00:48:16Data difference.
00:48:17Now, you can't take it.
00:48:21Tell me about this.
00:48:22Yes.
00:48:23It's a data difference.
00:48:25Because it's invalid.
00:48:27What is it?
00:48:28What is it?
00:48:30Why is it?
00:48:31Yes, sir.
00:48:32We have defined it.
00:48:33No, no.
00:48:34It's called Order of Education.
00:48:38Order of Education.
00:48:41What is the first thing?
00:48:43From.
00:48:45Where.
00:48:47No.
00:48:49From.
00:48:50Join.
00:48:51Where.
00:48:53Group by.
00:48:55Nursing.
00:48:56What is it?
00:48:58Find it.
00:49:00Have.
00:49:01Now, head.
00:49:02Then select.
00:49:04Then select.
00:49:05Then select.
00:49:06Then select.
00:49:07Then select.
00:49:08Then select.
00:49:09Then select.
00:49:10Then select.
00:49:11Then select.
00:49:12Then type.
00:49:13I say No?
00:49:14Then?
00:49:15education in sql
00:49:26yeah from where group by from where group by
00:49:31having select distinct top top limit
00:49:37is equal to the top will be my squalping limit
00:49:43limit plus with this to prevent the order of execution
00:49:51this is a
00:49:57or I might notice this is only that
00:50:03So then where is it? Where is it? Where is it?
00:50:08I have to remove it. What is it?
00:50:13No, it is not.
00:50:15So I have to remove it.
00:50:18And paste it here.
00:50:22I will keep it here.
00:50:27From dim imply.
00:50:31I will keep it here.
00:50:33This data is now.
00:50:36Now I will write it here.
00:50:39Then I will write it here.
00:50:41Select star from.
00:50:44Last time I will copy as EE.
00:50:49Where age is greater than 40.
00:50:54Now I will write it here.
00:50:57Yes, I will write it here.
00:51:00I was very careful.
00:51:02I will not understand.
00:51:06Why is this happening?
00:51:08Find the details of customer who made the first purchase.
00:51:25Use of dim customer table.
00:51:29Find the details of who made the first purchase.
00:51:32Now I will write it here.
00:51:33How will it be?
00:51:34Select star from dim customer.
00:51:39This is the customer ID.
00:51:43Geographical key.
00:51:45Geography key.
00:51:46Last name.
00:51:47Style.
00:51:48Birthday.
00:51:49Address.
00:51:50Email address.
00:51:51Early income.
00:51:52First purchase date.
00:51:54Date.
00:51:55Date.
00:51:56First purchase date.
00:51:57Date.
00:51:58First purchase date.
00:51:59Date.
00:52:00First purchase.
00:52:01First purchase date.
00:52:03Tell me.
00:52:04How will it be?
00:52:05Find the details of customer.
00:52:07First purchase date.
00:52:08Date.
00:52:09Find the details of customer who made the first purchase.
00:52:13is saying that I will leave the customer who made the first purchase.
00:52:36Am in
00:52:37I'll be honest but okay it's a clear condition well if you said select star sir last my condition
00:52:47in the video.
00:52:49Yeah.
00:52:52Or bracket me.
00:52:53Select.
00:52:57Yeah for select.
00:53:01No, first, first, first, first, first, first, first, first, first, first, first, first,
00:53:141 2
00:53:151
00:53:162
00:53:173
00:53:183
00:53:194
00:53:204
00:53:214
00:53:224
00:53:235
00:53:245
00:53:256
00:53:265
00:53:276
00:53:286
00:53:297
00:53:307
00:53:318
00:53:328
00:53:3310
00:53:348
00:53:359
00:53:3610
00:53:3710
00:53:3811
00:53:3911
00:53:4011
00:53:4111
00:53:429
00:53:43ba
00:53:44ьЭ┤
00:53:45ыДд
00:53:46recebo
00:53:488
00:53:4912
00:53:5011
00:53:5212
00:53:5312
00:53:5412
00:53:5512
00:53:5912
00:54:0012
00:54:0012
00:54:0112
00:54:0212
00:54:0312
00:54:0512
00:54:0512
00:54:0712
00:54:0912
00:54:0912
00:54:1012
00:54:11record and timing is not. If timing is happening, we can do it at 12 o'clock or 9 o'clock
00:54:20then we can do it. Yes, but it is that when the shop is open or online, the minimum date
00:54:32write the query to find the monthly income of the customer monthly income select and start from
00:54:50dim customer data is 18000 now go to the column here is the yearly income
00:55:03oh
00:55:05oh
00:55:07and
00:55:09so
00:55:11here
00:55:13select
00:55:15all
00:55:17imply
00:55:19key
00:55:21area
00:55:23I am
00:55:25I
00:55:32Yeah, I can't
00:55:34I
00:55:35I
00:55:37I
00:55:39Customer
00:55:41Customer
00:55:43Customer
00:55:45First name
00:55:47Early income
00:55:49This is the yearly income and what we will do is divide by 12 as monthly income.
00:56:05If I have 12 divided by 12, then monthly income will come.
00:56:13Write a query to find the age when the employee joins the organization.
00:56:26What does this mean?
00:56:29Write a query to find the age when the employee joins the organization.
00:56:37Where we put the date, there is a higher date.
00:56:41What is the question?
00:56:43When he joined, his age was enough.
00:56:47Yes, yes, yes.
00:56:49This is also a dim customer?
00:56:53No, dim customer.
00:56:57Dim imply.
00:56:59Dim imply.
00:57:01Dim imply.
00:57:03Dim imply.
00:57:04Dim.
00:57:05Dim imply.
00:57:06Dim imply.
00:57:07Dim imply.
00:57:08Dim imply.
00:57:09Dim first name.
00:57:10Dim mean he asked what Puch rake, when the Tyrone joins it until his age was only for the year.
00:57:13How many years?
00:57:14Yes, no.
00:57:15Here also the date.
00:57:16Find the date again.
00:57:17Division date the date also used.
00:57:18High date the date also used.
00:57:19To see.
00:57:20Yes, yes.
00:57:21In this case, the date is already due to the date.
00:57:22We will have to show.
00:57:23Let's just see.
00:57:24I will give this to show you.
00:57:28The date is now.
00:57:31Date,
00:57:33year.
00:57:35Sir,
00:57:36now,
00:57:37you can use the year.
00:57:40After you write the year,
00:57:42you can write the birth date.
00:57:46Yes,
00:57:48and here,
00:57:51and here is a higher date
00:57:53higher date
00:57:55age
00:57:57age
00:57:59when
00:58:01joined
00:58:03ok
00:58:05ok
00:58:07ok
00:58:09now this person
00:58:11has written his birth
00:58:13so
00:58:15where you can get it
00:58:17and get it
00:58:19and
00:58:21get it
00:58:23and
00:58:25and
00:58:27and
00:58:29and
00:58:31and
00:58:33and
00:58:35and
00:58:37and
00:58:39and
00:58:41and
00:58:43and
00:58:45and
00:58:47and
00:58:49and
00:58:51and
00:58:53and
00:58:55and
00:58:57and
00:58:59and
00:59:01and
00:59:03and
00:59:05and
00:59:07and
00:59:09and
00:59:11and
00:59:13and
00:59:15and
00:59:17and
00:59:19and
00:59:21and
00:59:23and
00:59:25and
00:59:27and
00:59:29and
00:59:31and
00:59:33and
00:59:35and
00:59:37and
00:59:39and
00:59:41and
00:59:43and
00:59:45and
00:59:47and
00:59:49and
00:59:51and
00:59:53and
00:59:55and
00:59:57and
00:59:59and
01:00:01and
01:00:03and
01:00:05and
01:00:07and
01:00:09and
01:00:11and
01:00:13and
01:00:15and
01:00:17and
01:00:19and
01:00:21and
01:00:23and
01:00:25and
01:00:27and
01:00:29and
01:00:31and
01:00:33and
01:00:35and
01:00:37and
01:00:39and
01:00:41and
01:00:43and
01:00:45and
01:00:47and
01:00:49and
01:00:51and
01:00:53and
01:00:55for this year
01:00:57when
01:00:59India
01:01:00will
01:01:01celebrate
01:01:02in
01:01:03in
01:01:04in
01:01:05in
01:01:07and
01:01:09dance
01:01:10day
01:01:11рдорддрд▓рдм рдпрд╣ рдХрд╣ рд░рд╣рд╛ рд╣реИ рдХрд┐
01:01:13рдЗрд╕ рд╕рд╛рд▓ рдХрд╛ рдЙрд╕ рджреАрди рдХрд╛ рдирд╛рдо рдмрддрд╛рдУ рдордиреЗ рд╕реЛрдВрдмрд╛рд░ рдордВрдЧрд▓рд╡рд╛рд░ рдмреБрдзрд╡рд╛рд░ рдЬрдм рдЗрдиреНрдбрд┐рдпрд╛ рдЗрдиреНрдбрд┐рдкреЗрдиреЗрдВрдбреЗрдВрд╕ рдмрдирд╛рдПрдЧрд╛ рдмрддрд╛рдУ рдХреИрд╕реЗ рд╣реЛрдЧрд╛
01:01:21select date name, date name, date name, date name, date name, date name, date name,
01:01:41Brexit start, then here we go, DW, and here we go, date date, year, month,
01:01:51date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date date
01:02:21Friday, but this question is, if I will run in 2026, then I will do this work.
01:02:26Hello?
01:02:41I can't do it.
01:02:48I am going to work with you.
01:02:57I am going to work with you.
01:03:01I am
01:03:03I
01:03:05I
01:03:07I
01:03:09I
01:03:11I
01:03:13I
01:03:15I
01:03:17I
01:03:19I
01:03:31I
01:03:33I
01:03:35I
01:03:37I
01:03:39I
01:03:41I
01:03:43I
01:03:45I
01:03:47I
01:03:49I
01:03:51I
01:03:53I
01:03:55I
01:03:57I
01:03:59I
01:04:01I
01:04:03I
01:04:05I
01:04:07I
01:04:09I
01:04:11I
01:04:13I
01:04:15I
01:04:17I
01:04:19I
01:04:21I
01:04:23I
01:04:25I
01:04:27I
01:04:29I
01:04:31I
01:04:33I
01:04:35I
01:04:37I
01:04:39I
01:04:41I
01:04:43I
01:04:45I
01:04:47I
01:04:49I
01:04:51I
01:04:53I
01:04:55I
01:04:57I
01:04:59I
01:05:01I
01:05:03I
01:05:05I
01:05:07I
01:05:09I
01:05:11I
01:05:13I
01:05:15I
01:05:17I
01:05:19I
01:05:21I
01:05:23I
01:05:25I
01:05:27I
01:05:29I
01:05:31I
01:05:33I
01:05:35I
01:05:37I
01:05:39I
01:05:41I
01:05:43I
01:05:45I
01:05:47I
01:05:49I
01:05:51I
01:05:53I
01:05:55I
01:05:57I
01:05:59I
01:06:01I
01:06:03I
01:06:05I
01:06:07I
01:06:09I
01:06:11I
01:06:13I
01:06:15I
01:06:17I
01:06:19I
01:06:21I
01:06:23I
01:06:25I
01:06:27I
01:06:29I
01:06:31I
01:06:33I
01:06:35I
01:06:37I
01:06:39I
01:06:41I
01:06:43I
01:06:45I
01:06:47I
01:06:49I
01:06:51I
01:06:53I
01:06:55I
01:06:57I
01:06:59I
01:07:01I
01:07:03I
01:07:05I
01:07:07I
01:07:09I
01:07:11I
01:07:13I
01:07:15I
01:07:17I
01:07:19I
01:07:21I
01:07:23I
01:07:25I
01:07:27I
01:07:29I
01:07:31I
01:07:33I
01:07:35I
01:07:37I
01:07:39I
01:07:53I
01:07:55I
01:07:57I
01:07:59I
01:08:01I
01:08:03I
01:08:05I
01:08:07I
01:08:09I
01:08:11I
01:08:13I
01:08:15I
01:08:17I
01:08:19I
01:08:21I
01:08:23I
01:08:25I
01:08:31I
01:08:33I
01:08:35I
01:08:37I
01:08:39I
01:08:41I
01:08:43I
01:08:45I
01:08:47I
01:08:49I
01:08:51I
01:08:53I
01:08:55I
01:08:57I
01:08:59I
01:09:01I
01:09:03I
01:09:05I
01:09:07I
01:09:09I
01:09:11I
01:09:13I
01:09:15I
01:09:17I
01:09:19I
01:09:21I
01:09:23I
01:09:25I
01:09:27I
01:09:29I
01:09:31I
01:09:33I
01:09:35I
01:09:37I
01:09:39I
01:09:41I
01:09:43I
01:09:45I
01:09:47I
01:09:49I
01:09:51I
01:09:53I
01:09:55I
01:09:57I
01:09:59I
01:10:01I
01:10:03I
01:10:05I
01:10:07I
01:10:09I
01:10:11I
01:10:13I
01:10:15I
01:10:17I
01:10:19I
01:10:21I
01:10:23I
01:10:25I
01:10:27I
01:10:29I
01:10:31I
01:10:33I
01:10:35I
01:10:37I
01:10:39I
01:10:41I
01:10:43I
01:10:45I
01:10:47I
01:10:49I
01:10:51I
01:10:53I
01:10:55I
01:10:57I
01:10:59I
01:11:01I
01:11:03I
01:11:05I
01:11:07I
01:11:09I
01:11:11I
01:11:13I
01:11:15I
01:11:17I
01:11:19I
01:11:21I
01:11:23I
01:11:25I
01:11:27I
01:11:29I
01:11:31I
01:11:33I
01:11:35I
01:11:37I
01:11:39I
01:11:41I
01:11:43I
01:11:57I
01:11:59I
01:12:01I