I have this table and these queries
I'm confused about the line with the WHERE clause in each query. Specifically that ALL and that ANY. I understand what ALL and ANY do. Shouldn't they return a boolean value?
This syntax is confusing me. It would make sense that the first query verifies if player is different from ALL the players of Member, which would return 0 rows, and the second query verifies that player is different from ANY player of Member, which would be true if there was at least one player in the table that was different from player. Is this correct and is the syntax just a bit different from usual? If I remember right the condition should be in the parentheses and not outside of them.