Ÿ??Getting An expression of non-boolean type specified in a context where a condition is expectedŸ? error with my query?

Ÿ??Getting An expression of non-boolean type specified in a context where
a condition is expectedŸ? error with my query?

References

Reference NO 1

#EANF#

Reference NO 2

#EANF#

Reference NO 3

#EANF#

Reference NO 4

#EANF#

Reference NO 5

#EANF#

Reference NO 6

#EANF#

Reference NO 7

#EANF#

Reference NO 8

#EANF#