SQL Practice Session 20 April 2025

RAKESH KUMAR

SQL Practice Session 20 April 2025  Source file :- https://drive.google.com/file/d/1WE9q4UiksSBT96ekzVpIVsHQz9uCNrdG/view?usp=sharing Link for whatsapp - https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt

Transcript

00:00:00I have two tables, one employee and one department, the question is, get all the employees who work in the same department as the escort,

00:00:13I have two employees who work in the same department as the escort,

00:00:30I have two employees who work in the same department as the escort.

00:00:40So, sir, employee or DCM department number.

00:00:44So, select dptno from ENP where e-name equal to Scott.

00:01:07Let's go.

00:01:08Escort.

00:01:09Entry.

00:01:10Abh?

00:01:11Abh?

00:01:12Abh, sir.

00:01:14Select.

00:01:15Abh, sir, e-name from ENP or, sir, where dptno equal to.

00:01:16Or, sir, e-name from ENP or, sir, where dptno equal to.

00:01:17Or, sir, e-name from ENP or, sir, where dptno equal to.

00:01:18Or, sir, bracket number.

00:01:19Or, sir, where dptno equal to.

00:01:24Or, sir, where dptno what, sir, where dptno equal to.

00:01:37Or, sir, bracket number.

00:01:41.

00:01:46.

00:01:48.

00:01:51.

00:01:55.

00:02:03.

00:02:08.

00:02:10okay yes sir it is easy

00:02:20so now let me see

00:02:23display all the employees who have joined before their manager

00:02:28who have joined before their manager

00:02:58Oh

00:03:06Oh, stable code this character

00:03:10Oh

00:03:18I compare

00:03:28yeah

00:03:30manager

00:03:32we will make a table

00:03:36which is a manager

00:03:38a table

00:03:40no

00:03:42comparison

00:03:44two parts

00:03:46this

00:03:48you can say

00:03:50we will solve

00:03:52Select manager ID.

00:04:00Select MGR.

00:04:04From EMP.

00:04:16You can see that.

00:04:23If you have this short version,

00:04:24I've added a short version.

00:04:26I do not have this.

00:04:29I have one version of the screen.

00:04:33Tell me...

00:04:37Yes, it's a good version for the screen.

00:04:43you

00:04:44you

00:04:45you

00:04:46you

00:04:47you

00:04:48you

00:04:49a MP number

00:04:51you

00:04:52you

00:04:53you

00:04:54you

00:04:55you

00:04:56you

00:04:57you

00:04:58want to

00:04:59for

00:05:00you

00:05:01you

00:05:02you

00:05:03you

00:05:04you

00:05:05you

00:05:06you

00:05:07can

00:05:08display all the employees who had joined before their manager

00:05:12so we need two tables to change

00:05:14okay

00:05:15two tables to change

00:05:17here

00:05:18here

00:05:19here

00:05:20here

00:05:21here

00:05:22so

00:05:23select

00:05:28select

00:05:29duty

00:05:30the

00:05:31car

00:05:32self

00:05:33to

00:05:34do

00:05:35to

00:05:36do

00:05:37to

00:05:38do

00:05:39to

00:05:40do

00:05:41to

00:05:42do

00:05:43to

00:05:44do

00:05:45do

00:05:46do

00:05:47do

00:05:48do

00:05:49do

00:05:50do

00:05:51do

00:05:52do

00:05:53do

00:05:54do

00:05:55do

00:05:56do

00:05:57dot

00:05:58e

00:05:59name

00:06:00hire

00:06:03date

00:06:04e

00:06:06dot

00:06:07hire

00:06:08date

00:06:09take

00:06:10a

00:06:11a

00:06:12a

00:06:13a

00:06:14a

00:06:15a

00:06:16a

00:06:17a

00:06:18a

00:06:19a

00:06:20a

00:06:21a

00:06:22a

00:06:23a

00:06:24a

00:06:25a

00:06:26a

00:06:27a

00:06:28a

00:06:29a

00:06:30a

00:06:31mp

00:06:33and

00:06:34no

00:06:35we don't

00:06:37we don't know

00:06:39e dot

00:06:40e

00:06:41mp and no

00:06:42equal to

00:06:43equal to नहीं इसमोन वह यहां पर होगा M.

00:06:49कहे इसलिचल टू एड़ॉट

00:06:54मजी आर इसको देखते हैं तकिया आता है इतना चीजा आगाया

00:07:02क्ला हुआ हाँ हाँ हाँ हाँ हाँ हाहे और ये तो यहां पर

00:07:09hide it

00:07:12m dot

00:07:18a dekho

00:07:22aysa are high is quick

00:07:25verify carna padega kiss

00:07:27he are a hacky nahi a raha

00:07:28other my score and kia

00:07:30to have my face

00:07:33aia is co

00:07:34select all copy with

00:07:36copy with header

00:07:38this app

00:07:432

00:07:44mi

00:07:44yeah

00:07:45we are

00:07:45a

00:07:50a

00:07:51mp7336

00:07:53mp7369

00:07:54mp7369

00:07:55mp7369

00:07:56is

00:08:01it

00:08:02it

00:08:02is

00:08:04it

00:08:05is

00:08:06seven nine zero two two of a hassle low seven nine zero two a join kiya

00:08:14I say to Smith ka hai bada satara bada tina kasi agad dunoka again I did

00:08:24have been happy I got some you know some you take me don't heard it for some that I was some data

00:08:38yeah

00:08:42edge mgr name

00:08:46I see a guy a band a can now go yeah it's been deka sorry imp impal I know you apply

00:08:55now I'm going to apply number again plan now I'm going to come manager can I'm

00:09:00going to get a person who had it hey a manager who had it hey so you have for

00:09:04I will write as EMP, Hide it, and here I will write as EMP, Hide it, and here I will write as manager, Hide it,

00:09:30I will write as a clear opinion,

00:09:36and here I will write as a clear opinion,

00:09:45See if we have a clear opinion?

00:09:46It has been a clear opinion?

00:09:50It has been so clear that we have been able to do,

00:09:56hello thank you that somebody is Abhi Hatta Koga up can Nick Kala here I said you have

00:10:07that data Casey I it clear Hora I'm gonna sell it I must love the course the only joint here

00:10:15so you can say I'm sorry I'm not meaning huh do you know I'm an empty table for a camera to

00:10:27me Nekata Bali job himself join a made Karin gay the self enjoyment a key hotel table yes it will

00:10:38I will not be able to see the details of the details.

00:10:44He will not be able to see the details of the details of the details.

00:10:55okay so this code call card name manager call card now or isco call card in play ballease

00:11:03so if I got a score you are in cardia to go to the level of the city

00:11:07me as a guy I got a pen I saw cardia

00:11:12so to this may output is some of the other than I have kuchna kuchis me

00:11:16now see 7902 is 81 and this is who is 7902

00:11:32I seek a bar as I tell it that we have a hot girl what I'm 790 sorry so 790 to net 736 9 736 9

00:11:50they call you happen nam get a nice a one-night kiss combat car at a player SME's gonna

00:11:59answers SME's kahe bat horatana pelle to go SME's kabat kya 736 9 to 730

00:12:12is

00:12:15is

00:12:167369

00:12:177369

00:12:19this is my

00:12:20I

00:12:21I

00:12:23I

00:12:24I

00:12:25I

00:12:26I

00:12:27I

00:12:28I

00:12:29I

00:12:30I

00:12:31I

00:12:32I

00:12:33I

00:12:34I

00:12:35I

00:12:36I

00:12:37I

00:12:38I

00:12:39I

00:12:40I

00:12:41I

00:12:43I

00:12:44I

00:12:45I

00:12:46I

00:12:48I

00:12:50I

00:12:52I

00:12:54I

00:12:57I

00:13:02A

00:13:03I

00:13:05I

00:13:06I

00:13:07I

00:13:08I

00:13:10I said, I'm going to put it here.

00:13:16I'm going to put it here.

00:13:19EMP.

00:13:20Hide it.

00:13:22EMP.

00:13:24Hide it.

00:13:25Who should I put it?

00:13:27MGR.

00:13:29MGR.

00:13:31MGR.

00:13:33MNAGER.

00:13:35is still like in my life I feel my money is a call come over again

00:13:41it got a bit later

00:13:44is column co-united car

00:13:49yeah so you have for m dot head car though

00:13:52are you happy dot head

00:13:57underscore sir I'm running I'm gonna look at it to go up winning the great

00:14:10me khatakya it to other or II hopper I got a man I got a ski Jaga I got a man

00:14:18name a half a other

00:14:27my manager dot head with manager underscore hired it

00:14:34and here I am P and there is for hired it

00:14:39it's it's it's it's it's it's it's it's it's it's it's it's it's it's it's it's it's it's

00:14:47it's it's it's it's it's it's it's I think it's important too as you think why

00:15:08question what I am interview me of is me a question or view a sector is my hacky

00:15:16nahi here earning her list of imply is can't have a lie here if what clear who

00:15:23are yes sir I'm to abuse kebadawala same question hiya he was sub kuch where he

00:15:30a car I list all the imply who are earning more than their manager the Pura Kapura copy

00:15:41and paste and where the high debt was, we will do the sell and imply salary and here is m.cell

00:16:02I have a manager salary we are in a dot sell you have got greater over then

00:16:17I'm gonna yes sir

00:16:18and so now it's clear that this manager is this one.

00:16:39is

00:16:424 people

00:16:45are

00:16:46a

00:16:47a

00:16:48a

00:16:49a

00:16:50a

00:16:51a

00:16:53a

00:16:54a

00:16:56a

00:16:57a

00:16:58a

00:16:59a

00:17:00a

00:17:01a

00:17:02a

00:17:03a

00:17:04a

00:17:05a

00:17:06a

00:17:07a

00:17:10m

00:17:16M

00:17:18a

00:17:19a

00:17:21key

00:17:22a

00:17:25a

00:17:29a

00:17:30a

00:17:31a

00:17:32a

00:17:33a

00:17:34a

00:17:35so here we have to go to manager here we have to go to manager here we have to go to manager

00:17:44join key and college NK it is Hannah also at the list of me as I got a man I got a

00:17:51mine is it is Coran Kia the year like a pata-kikon-kon-kis coming in a janet

00:17:58I'm gonna

00:18:01I'm gonna stay with a lot of Taki-con kiss come in a janet or it's here

00:18:06as a me a pata laga hi yes are a band-day has caught her this case

00:18:11this is the main manager of the shareholder of the shareholder is the main manager of the shareholder

00:18:19is that the other stable comment change

00:18:21I am not sure if I take a copy of the ares

00:18:29we have our past do can now are Hannah

00:18:34we have our past

00:18:41is

00:18:42the

00:18:43two

00:18:44names

00:18:45are

00:18:46now

00:18:47I'm

00:18:48going to

00:18:49tell

00:18:50who

00:18:51is

00:18:52who

00:18:53is

00:18:54who

00:18:55is

00:18:56the

00:18:57escort

00:18:58or

00:18:59for

00:19:00select

00:19:01star

00:19:02from

00:19:03emp

00:19:04escort

00:19:05or

00:19:06for

00:19:07for

00:19:08for

00:19:097

00:19:106

00:19:119

00:19:128

00:19:1312

00:19:14or

00:19:157

00:19:166

00:19:179

00:19:188

00:19:198

00:19:208

00:19:218

00:19:228

00:19:238

00:19:248

00:19:258

00:19:269

00:19:279

00:19:2810

00:19:2910

00:19:3010

00:19:3110

00:19:3210

00:19:3310

00:19:3410

00:19:3510

00:19:3610

00:19:3710

00:19:3810

00:19:3910

00:19:4010

00:19:4110

00:19:4210

00:19:4310

00:19:4410

00:19:4610

00:19:4710

00:19:4811

00:19:4912

00:19:5012

00:19:5113

00:19:5215

00:19:5320

00:19:5415

00:19:5515

00:19:5615

00:19:5715

00:19:5815

00:19:5915

00:20:0015

00:20:0116

00:20:0215

00:20:0316

00:20:0415

00:20:0520

00:20:0616

00:20:07so this is how you see me

00:20:10yes

00:20:11I don't know

00:20:14I will

00:20:16have a question

00:20:17no

00:20:18no

00:20:18it's all imply who are earning same salary

00:20:23if you are

00:20:24about it

00:20:25it

00:20:25is

00:20:25I have

00:20:26you

00:20:27I am

00:20:28I am

00:20:29I am

00:20:30I am

00:20:31I am

00:20:32I am

00:20:33I am

00:20:34I am

00:20:36I am

00:20:37can't be a sector HR be a sector who is a sector yes sir the happy up go on sorry imply

00:20:45is a name that is the name of the salary, which is the same.

00:20:54How does it look like that?

00:20:59I am so happy when the ice cream has been a thousand dollars

00:21:07have been a thousand dollars and a thousand dollars

00:21:10and one and two people change and make it.

00:21:15First, let's talk about how it will be.

00:21:19In one minute, we will be able to get out of the way.

00:21:28Let's talk about how it will be.

00:21:33Oh

00:21:34Oh

00:21:35Oh

00:21:36Oh

00:21:37Oh

00:21:38So

00:21:39H-Logic

00:21:40Thin

00:21:41Count

00:21:42That

00:21:43Is

00:21:44Just

00:21:45Count

00:21:46Count

00:21:47Count

00:21:48Count

00:21:49Count

00:21:50Count

00:21:53Count

00:21:54Count

00:21:55заб

00:21:56Celestine

00:21:59Write

00:22:00To

00:22:01Fy

00:22:02Rd

00:22:05I

00:22:06This

00:22:07Pod

00:22:16Is

00:22:17...

00:22:18...

00:26:02select star from EMP where cell is equal to

00:26:12name the line.

00:26:32oh

00:26:35oh

00:26:37oh

00:26:38oh

00:26:39oh

00:26:42oh

00:26:43greater than one

00:26:44oh

00:26:46oh

00:26:47oh

00:26:48oh

00:26:49yeah

00:26:50oh

00:26:51oh

00:26:52oh

00:26:53oh

00:26:54oh

00:26:55oh

00:26:56oh

00:26:57oh

00:26:58oh

00:26:59oh

00:27:00Oh

00:27:01Yes

00:27:02How is it going to be going to work in this space?

00:27:06no

00:27:09No

00:27:10No

00:27:11No

00:27:12No

00:27:13No

00:27:14That's it

00:27:15No

00:27:16You can not tell us

00:27:17Yes

00:27:18Your

00:27:19Very

00:27:21One

00:27:22answer

00:27:23That's it

00:27:24Yes

00:27:26Your

00:27:27Count

00:27:29who greater than one of 80

00:27:36ah in key condition on this response condition on that for only one expression can be a space

00:28:02in which the subcuree count, count, start and start

00:28:08in which you can use the query to compare

00:28:16the same salary gain

00:28:29so this is a new change of the same

00:28:36as Smith and Alan same

00:28:40okay

00:28:41update

00:28:44EMP

00:28:46set cell is equal to

00:28:491600

00:28:51where EMPNO

00:28:53is equal to 7369

00:28:56yeah

00:29:05yes

00:29:08here

00:29:13here

00:29:14here

00:29:17on

00:29:18score

00:29:23correct

00:29:25Again, if you ask the salary amount,

00:29:32what is the salary amount which is taken by,

00:29:50what is the salary amount which is one to more than one?

00:30:03Yes, I want to say salary amount which is the salary amount which is the salary amount which is the salary amount which is the salary amount.

00:30:15Oh, yes, it is a problem.

00:30:17I am not sure what you are getting by more than one person.

00:30:26So, the same case is not a problem.

00:30:30I am not sure what you are getting by more than one person.

00:30:36The same question is not a problem.

00:30:41I am again doing this, is it clear?

00:30:44Yes, sir.

00:30:45If I can do this, I will do this work.

00:30:50Is it done?

00:30:55Is it right?

00:30:59Yes.

00:31:00It is done.

00:31:03Yes.

00:31:04It is done.

00:31:06Yes.

00:31:08Yeah.

00:31:09Yeah.

00:31:10Yeah.

00:31:11Yeah.

00:31:12Yeah.

00:31:20Yeah.

00:31:21Yeah.

00:31:22Yeah.

00:31:23Yeah.

00:31:24Yeah.

00:31:25It's got.

00:31:26Select all the imply.

00:31:27Who are earning same as Smith.

00:31:29It is.

00:31:30It's.

00:31:31It's.

00:31:32hello

00:31:37hello

00:31:53I mean I'm not a

00:31:57a

00:31:59a

00:32:01a

00:32:03a

00:32:05a

00:32:07a

00:32:09a

00:32:11a

00:32:13a

00:32:15a

00:32:17I have changed the application and I have a simple answer so it's my take well to

00:32:30send me to select sell for on EMP where he is a name is meaning Smith Smith Kasseli

00:32:44is Solasa I'll select star forum EMP where sell is equal to a copa come a car

00:32:55okay here for the day yeah yeah yeah yeah yeah yeah yeah yeah yeah yeah yeah yeah yeah yeah yeah

00:33:12question job 1 is your question banana ithah which all the imply who are getting same salaries

00:33:21if you would like to create a new method,

00:33:28then it will also become a self-join.

00:33:39Now, I can write, select a star from EMP,

00:33:47a m p e where e dot e e dot e dot salary is equal to m dot making a many

00:34:13million how many how some send me a week for return of the

00:34:23unit with semble lovey the Korku ya m dot yeah even this code p.cally

00:34:27karda tha

00:34:28a f dot salary and the bus case elderly Samho Lincoln

00:34:39is

00:34:41yes

00:34:43is

00:34:45is

00:34:47not

00:34:49equal to

00:34:51F

00:34:53dot

00:34:57E

00:34:59MP

00:35:01is

00:35:03is

00:35:05is

00:35:07is

00:35:09is

00:35:11select

00:35:13star

00:35:15E

00:35:17MP

00:35:19MP

00:35:21MP

00:35:23MP

00:35:25MP

00:35:27where

00:35:28E

00:35:29X

00:35:30is

00:35:31exist

00:35:32I

00:35:33am

00:35:34I

00:35:35am

00:35:36I

00:35:37am

00:35:38I

00:35:39am

00:35:40I

00:35:41am

00:35:42I

00:35:43am

00:35:44I

00:35:45am

00:35:46I

00:35:47am

00:35:48I

00:35:49am

00:35:51I

00:35:52am

00:35:53I

00:35:54am

00:35:55I

00:35:56here

00:35:58because

00:36:12we

00:36:14need

00:36:16to

00:36:18help

00:36:20I

00:36:21know

00:36:23can you do not apply ID same no

00:36:29oh yes salary same

00:36:30oh yes

00:36:32I don't know if I'm stable

00:36:34it will be here and it's

00:36:36a virtual table

00:36:38yeah it's a table

00:36:38brahliya do table

00:36:40or I don't know

00:36:41my score or

00:36:42score my same

00:36:43card with it sorry

00:36:44I'm going to score

00:36:47risk of

00:36:48Kata to same person

00:36:49Kari ho

00:36:49Jaega

00:36:50or is this

00:36:51this salary is 800 and this salary is 800. So, I want to say that a and this

00:37:00two tables are not the same. I mean, this is 7369, which is not the same. This is 7369,

00:37:08which is not the same. This is 7369, which is not the same. This is not the same.

00:37:20ཅསླ ཅམતའར འྲིག�ིིག མાྲའར ར྾রོར བ྾রོར འྲོ ཟ ཚདང ས�ོག རྱསར ཆདི འ རྭ མ� རྷད ར྾রབ ར྾བས । ས�ྲོ�

00:37:507 499 per hour get to yeah you have per isco ignore carrega

00:37:56oh audio first malaco check carrega or

00:37:59pisco check carrega is called chemical a check

00:38:03is you can not equal to all of you know

00:38:05will cool inside okay you have to have them in the iq in plain and cm no

00:38:11oh sir it's my question about this i have no

00:38:13and select start from EMP as where exist.

00:38:18This where exist, sir?

00:38:20Oh, yeah. Exist.

00:38:22What does exist?

00:38:24Exist, sir, what do you say?

00:38:28What did you say about it?

00:38:31No, no, exist.

00:38:34Exist or not exist was the same thing.

00:38:38Exist?

00:38:47I don't remember.

00:38:56When we create a table, what happens if we write?

00:39:01Exist or Exist?

00:39:02If we create a table, we will not do it.

00:39:05foreign

00:39:12foreign

00:39:20foreign

00:39:25foreign

00:39:28you

00:39:32so you have to exist

00:39:34a second

00:39:36okay

00:39:38I'm just

00:39:38to lie

00:39:39I don't

00:39:40I don't

00:39:41I don't

00:39:42I don't

00:39:44I don't

00:39:46I don't

00:39:48I don't

00:39:50I don't

00:39:52I don't

00:39:54I don't

00:39:56I don't

00:39:57I don't

00:39:58I don't

00:39:59I don't

00:40:00I don't

00:40:01I don't

00:40:02I don't

00:40:03I don't

00:40:04I don't

00:40:05I don't

00:40:06I don't

00:40:07I don't

00:40:08I don't

00:40:09I don't

00:40:10I don't

00:40:11I don't

00:40:12I don't

00:40:13I don't

00:40:14I don't

00:40:15I don't

00:40:16I don't

00:40:17I don't

00:40:18I don't

00:40:19I don't

00:40:20I don't

00:40:21I don't

00:40:22I don't

00:40:23I don't

00:40:24I don't

00:40:25I don't

00:40:26to relate inner and outer query be different keyword like in not all any be a subuse

00:40:41and not exactly be generally not exist where correlated nested query core related nested query

00:40:51when the inner query is used by the outer query. If the exist operator returns 12 true or false

00:41:13return rows from other table exist operator test whether a subcury returns any row subcury

00:41:26row do not return at least one row then exist command in condition true and outer query exist

00:41:36here is the query if it will give you something else then it will be out of the way it will not be out of the way

00:41:43to the example here we come from a b c d e f mark mark here we take two tables

00:42:02I am going to make this.

00:42:03I am going to make this.

00:42:09I am going to make this.

00:42:20I am going to make this last one.

00:42:25.

00:42:33.

00:42:41.

00:42:44.

00:42:45.

00:42:46.

00:42:49.

00:42:51.

00:42:52.

00:42:53.

00:42:54.

00:42:56.

00:43:02.

00:43:04.

00:43:05.

00:43:10।

00:43:12.

00:43:23Select a star from number one.

00:43:27I have done this.

00:43:28All right.

00:43:29Then, one table.

00:43:33This is the same thing.

00:43:34I have to remember everything.

00:43:37This is the same thing.

00:43:47It's done.

00:43:49Now, I will

00:43:50I am going to run two tables for the two tables.

00:44:00Is it done?

00:44:02Did you do it?

00:44:04Yes, sir.

00:44:06Now, what do I say?

00:44:09What do I say?

00:44:11One thing I want to tell.

00:44:13If I say that A from this table,

00:44:17let me show you the name.

00:44:19If you see B from this table,

00:44:21it will match the name.

00:44:23It will match the name?

00:44:25No, sir.

00:44:27How do you match the name?

00:44:29Look at B from this table.

00:44:31Okay.

00:44:32No, A from this table.

00:44:34Sorry.

00:44:35Table number one.

00:44:37First table,

00:44:38which is the second table?

00:44:41It will match the name?

00:44:43Yes, sir.

00:44:4545 or 50.

00:44:47Yes.

00:44:48All right.

00:44:49Yes, sir.

00:44:50Now, my name is here.

00:44:51Select marks from number two.

00:45:02I say,

00:45:03come here?

00:45:04Yes, sir.

00:45:05Now, this is correct.

00:45:06Yes, sir.

00:45:07Now, this is correct.

00:45:08This is correct.

00:45:09This is correct.

00:45:10This is correct.

00:45:11It will match.

00:45:12Yes, sir.

00:45:13What if?

00:45:14You can double.

00:45:15Yes.

00:45:16Remember,

00:45:17I think it will match.

00:45:18You can double.

00:45:19Yeah.

00:45:20The Carver.

00:45:21Yes.

00:45:22It is correct.

00:45:23Select.

00:45:24It will match.

00:45:26None.

00:45:27Marks from number one.

00:45:29Marks is equal to name.

00:45:30Two.

00:45:31Mark.

00:45:32Marks.

00:45:33Marks.

00:45:34Is it?

00:45:35Marks.

00:45:36Marks.

00:45:37I will tell you what is going to do.

00:45:42Just tell me,

00:45:45if we can give anything,

00:45:51then we will forget.

00:45:53Okay?

00:45:55Yes sir.

00:45:57If I run both tables,

00:46:02I will copy it.

00:46:05a copy with header and keep it here and I have run it

00:46:18copy with header and keep it here

00:46:21if I will match this mark with this mark, if it will match this mark, then what is the output?

00:46:35False, false, then if it will match this mark, so this will match

00:46:43you and the chopper at this point, if it's sure you want to match it, it will be true.

00:46:47The output of this decision will be true and false.

00:46:54If I said that this means Flow, Malaysia, or the name of the column will be true.

00:46:59The matter will be true and false, after I will read the unboxing,

00:47:02select star from number one number one table says oh sorry to do Joe exist

00:47:11,

00:47:12,

00:47:18,

00:47:23,

00:47:24,

00:47:29,

00:47:31,

00:47:33,

00:47:35,

00:47:36,

00:47:37,

00:47:39,

00:47:40,

00:47:41,

00:47:43,

00:47:45,

00:47:47,

00:47:48,

00:47:49from

00:47:52,

00:47:53,

00:47:54,

00:47:55,

00:47:56,

00:47:57,

00:47:58,

00:47:59,

00:48:01,

00:48:03,

00:48:04,

00:48:06,

00:48:07,

00:48:09where

00:48:10here

00:48:15I will write

00:48:15number

00:48:15select

00:48:18star

00:48:18from

00:48:19number

00:48:20to

00:48:21this

00:48:23output

00:48:23nothing

00:48:23will

00:48:24do

00:48:24okay

00:48:24I will

00:48:27here

00:48:27I will

00:48:27select

00:48:28one

00:48:28I will

00:48:29say

00:48:29one

00:48:30I will

00:48:30see

00:48:30one

00:48:30column

00:48:30name

00:48:31to

00:48:31select

00:48:32one

00:48:33from

00:48:34number

00:48:35to

00:48:35where

00:48:36num

00:48:39one

00:48:39marks

00:48:40num

00:48:40two

00:48:40marks

00:48:41match

00:48:41now

00:48:43I will

00:48:43write

00:48:44select

00:48:44star

00:48:45from

00:48:45num

00:48:49one

00:48:49where

00:48:51exist

00:48:52exists

00:48:54I will

00:48:55do

00:48:55I will

00:48:57do

00:48:57this

00:48:57I will

00:48:59do

00:49:00this

00:49:00here

00:49:02I will

00:49:02do

00:49:02this

00:49:02here

00:49:04when he is running the first one, he will check every record from each record and when he gets it,

00:49:15he will give it to true or false. He will say that he will get to true or false.

00:49:24He will give it to true, then he will give it to me.

00:49:29No.

00:49:31So this is not enough.

00:49:32So that is what we call this.

00:49:36And I said to myself that I have something in the one place.

00:49:40If I give this one, I have to give this one.

00:49:42Sorry, this one is not a word.

00:49:46So if I give this person,

00:49:50I will also give this person.

00:49:55can do it by the person or the person who can do it.

00:49:59This is core related.

00:50:03It is a one-way and it will check all of the people.

00:50:08It will go and then it will check all of the people.

00:50:13It will check all of the people.

00:50:14What do you think?

00:50:17Is it something else?

00:50:19Is it something else?

00:50:21Yes, I understand.

00:50:23So, we have the same salary, and the same salary is the same, and the same name is the same.

00:50:49if the same implies so that the same implies is that it will match the same implies to that

00:50:56if we match the same implies that the same implies that any means that we will apply the same

00:51:04कि पाइब

00:51:08करो सुesis का मइड नदकर कर जाता हैना

00:51:14के तो दैशिष्योंधर ना उनोश्यों कहीं नहीं करता कुछ

00:51:18इस तयाप से है सोड़ी इन नहीं काम करता है लेकिन एगजिस्ट ऑन समर्ट दिस्त काम कर जाता है कुछ इस तअथ

00:51:2535

00:51:25this is not in gate any not in because of curators null data let us change with net

00:51:43so it exists in case case in this case we are going to do it so is it exist or not exist

00:51:55yes

00:51:58so this is the last question

00:52:13me

00:52:16display imply name imply not to his date of joining Uska joining data but

00:52:22up with some manager can not to and his manager's date of joining to us

00:52:27manage or good though it doesn't mean celi will not need a calendar

00:52:33no joining like it but it's not

00:52:38oh yes sir

00:52:38our date of joining

00:52:39about that

00:52:40we are

00:52:44here

00:52:45it is

00:52:47it is

00:52:48it is

00:52:48is

00:52:50if

00:52:51I'm going to see

00:52:51I'll copy

00:52:52is

00:52:52going to

00:52:54you

00:52:54I'll

00:52:55I'll

00:52:55we'll

00:52:56paste

00:52:56the

00:52:56I'll

00:52:57do

00:52:57I'll

00:52:59do

00:52:59so

00:53:00you

00:53:00have

00:53:00I'll

00:53:00keep

00:53:01the

00:53:01first

00:53:01join

00:53:01I'll

00:53:02So, I have to change the condition in the first join, and I will change the condition.

00:53:06Now, let's see here.

00:53:08Our question is fulfilled.

00:53:10Display the implied name.

00:53:13The joining is this.

00:53:16His manager's name, the manager's name, and his manager's date of joining.

00:53:21It's gone.

00:53:25Is it?

00:53:27It's gone.

00:53:29But if you did not change the date of the date, you can change the date of the date.

00:53:35It's done by the end of the month.

00:53:37So this is our last one.

00:53:40It was 49 questions, 45 sessions, but it was fun.

00:53:46You should practice here.

00:53:50You should practice.

00:53:52Without practice, it won't be.

00:53:54and now people are saying that I am going to do this, but it is not going to happen.

00:54:04If it is not happening here, then how will it happen in the interview?

00:54:10It is not happening here.

00:54:13There are other things happening here.

00:54:17New query.

00:54:19Let's see 2-4 query.

00:54:22New query is gone.

00:54:31You will also find Google.

00:54:36Open it, but tell me.

00:54:40Is it okay?

00:54:44I want to find Google.

00:54:46I want to find the solution.

00:54:48I want to find the solution.

00:54:50It is a simple concept.

00:54:52You have to find the solution.

00:54:54It doesn't matter.

00:54:56The matter is that you have to find the solution.

00:55:00Is it no solution.

00:55:03Yes, it is another solution

00:55:17Let's set the table here.

00:55:18I am not a database, let's see some other questions.

00:55:34Yes sir.

00:56:02So now we are going to make this table down.

00:56:11We are going to make this table.

00:56:15We are going to make this table.

00:56:21Let's do something here.

00:56:26if I am a code table with a

00:56:29a

00:56:31I

00:56:33I

00:56:35I

00:56:36I do

00:56:38I

00:56:40I

00:56:42I

00:56:44I

00:56:45I

00:56:46I

00:56:48I

00:56:50I

00:56:51I

00:56:52I

00:56:54I

00:56:55customer, purchase amount, order date, customer ID, salesman ID, a customer

00:57:01table, order table, customer table, customer name, city, grade, salesman ID,

00:57:20consultation, customer, customer, customer, customer crowe, customer local

00:57:36customer.

00:57:46We have two tables, this is the customer and this is the order, clear?

00:57:57Yes sir.

00:58:00This is the heading and this is the heading.

00:58:05Let's do one and two questions and then I will close.

00:58:09Now let's go to questions.

00:58:14From the following table, write a query to calculate total purchase amount of all orders.

00:58:42What is the question?

00:58:46The order of total purchase amount of all orders.

00:58:52Select a star.

00:58:54The order of total purchase amount of all orders.

00:58:55The order of total purchase amount of all orders.

00:59:00How's it going to be made?

00:59:01It's going to be made in the order of all orders.

00:59:06The order of total purchase amount of all orders.

00:59:09I am

00:59:11I

00:59:13I

00:59:15I

00:59:17I

00:59:21I

00:59:23I

00:59:25I

00:59:27I

00:59:29I

00:59:31I

00:59:33I

00:59:35I

00:59:37I

00:59:39I

00:59:41I

00:59:43I

00:59:45I

00:59:47I

00:59:49I

00:59:51I

00:59:53I

00:59:57I

00:59:59I

01:00:01I

01:00:03I

01:00:05I

01:00:07I

01:00:09I

01:00:11I

01:00:13I

01:00:15I

01:00:17I

01:00:19I

01:00:21I

01:00:23I

01:00:25I

01:00:27I

01:00:29I

01:00:31I

01:00:33I

01:00:35I

01:00:37I

01:00:39I

01:00:41I

01:00:43I

01:00:45I

01:00:47I

01:00:49I

01:00:51I

01:00:53I

01:00:55I

01:00:57I

01:00:59I

01:01:01I

01:01:03I

01:01:05I

01:01:07I

01:01:09I

01:01:15I

01:01:17I

01:01:19I

01:01:21I

01:01:23I

01:01:25I

01:01:27I

01:01:29I

01:01:31I

01:01:33I

01:01:35I

01:01:37I

01:01:39I

01:01:45I

01:01:47I

01:01:49I

01:01:51I

01:01:53I

01:01:55I

01:01:57I

01:01:59I

01:02:01I

01:02:03I

01:02:05I

01:02:07I

01:02:09I

01:02:11I

01:02:13I

01:02:15I

01:02:17I

01:02:19I

01:02:21I

01:02:23I

01:02:25I

01:02:27I

01:02:29I

01:02:31I

01:02:33I

01:02:35I

01:02:39I

01:02:41I

01:02:43I

01:02:45I

01:02:47I

01:02:49I

01:03:03I

01:03:05I

01:03:07I

01:03:08I

01:04:54I know the question has been asked.

01:04:57from customers where the grade is not null.

01:05:13The question is that your answer is wrong.

01:05:19The customer who receives at least one grade from their activities.

01:05:31Is it a full detail?

01:05:40Is it a start?

01:05:41Yes, this is a start.

01:05:43Yes, it is not an option.

01:05:50It got the start and what is it that the way we use?

01:06:00I don't know where the condition is, but then he will give it to me, because he will

01:06:04have to give it to me.

01:06:05How do I write it?

01:06:09I write it as a count star from customer.

01:06:18I write it as a customer ID, which is the star star ID.

01:06:27Count star, what is it?

01:06:29। जब हम कॉलम का नाम देते हैं तो उस केस में वह नल को

01:06:39कि इगनोर करता है ना कि यस हाग गया है यह इस चीज कुई याद रखना

01:06:47करें एक और दो कोस्टन और कर लेते हैं यार छोटा-छोटा है

01:06:58I am sorry about it a little bit

01:07:04so you got a lot of next class

01:07:07of the next session

01:07:09台灣 is SQL query

01:07:11find out the maximum purchase amount

01:07:14this is where the fill

01:07:15Here is simple

01:07:15purchase amount

01:07:18if you are eligible

01:07:19and simply

01:07:21this is why you know

01:07:23select

01:07:26select select next purchase among the case underscore from orders minimum

01:07:42write a SQL query to find the find the highest grade of customer in each city return city or maximum

01:08:05grade है पुजय अगर से इप्रोब बाइस हो जाएद है चलो आते हैं अब हमारा यह दो

01:08:16city है फश्ट में customer ID customer name city grade salesman ID सकेंड में

01:08:23order ID purchase amount order date customer ID salesman ID write a SQL query to find

01:08:31the highest grade of customer in each city अच्छा है इच सीटी में customer का अच्छा सकेंड टेवल से

01:08:42हमारा कोई मतलब नहीं है नहीं है तो सब अभी सकेंड अमांट सेकेंड टेबल में है और

01:08:50customer में सब्सक्राइब कर रहा है यहां पर कह रहा है कि जो सब्सक्राइब करेंगे सब्सक्राइब

01:09:08अच्छा है तरस्टी अ कॉमा मैक्स ग्रेट रम कस्तमर गुरूब बाइब शिटी यह सब सीटी है इसमें अगर मैं

01:09:38इसमें कंपेर करना चाहां दोनों का तो निव यार्क में दो है निव यार्क में दो है एक और दो सब्सक्राइब

01:09:48दो सब्सक्राइब भूट बल्लीन एक एक सो कैलफर्निया कि दो सब्सक्राइब लंदन लंदन में एक मिनल एक में तीन सब्सक्राइब

01:10:00Moscow in Moscow 200 200 New York 100 200 200

01:10:10Okay, I am going to get output.

01:10:13The rest of the next step is OK?

01:10:16OK, sir.

01:10:18So, this is a tough question.

01:10:22Now, what we will do next class,

01:10:26we will do 4-5 questions.

01:10:28It will be easy and tough questions.

01:10:30And easy, easy, easy, simple,

01:10:35which we already remember the basic concept.

01:10:38So, I am going to close the next step.

01:10:40sorry next class

01:10:43take it

01:10:44okay bye

01:10:45bye

Category

Transcript

Recommended