problem in HAVING statement

[GOBIN]

hi ,  i just started learning SQL on w3 school and i have a question :

in the SQL HAVING statement course last example i tried to write the code then checked the example but it didn't work 

this my code

 

and this is the example

thnk you .

[niche]

It’s not clear to me whether your second example worked.  It looks like it did.  Did it?
If not, what were you expecting?

 

[GOBIN]

the second exemple is not mine , it's on the tutorial , mine is the first one and it didn't work

[GOBIN]

13 hours ago, niche said:

It’s not clear to me whether your second example worked.  It looks like it did.  Did it?
If not, what were you expecting?

 

the second exemple is not mine , it's on the tutorial , mine is the first one and it didn't work

 

[niche]

So, why not do the join?

EDIT:

I’d do your OR differently:

WHERE 

this = that AND ln =

OR 

this = that AND ln =

 

Edited May 25, 2021 by niche

[GOBIN]

2 hours ago, niche said:

So, why not do the join?

EDIT:

I’d do your OR differently:

WHERE 

this = that AND ln =

OR 

this = that AND ln =

 

i'll try it , thank you