MySQL: Self Join

Select an expression that demonstrates a self join type.

Pick ONE option

SELECT $*$ FROM users users, users clients

SELECT $*$ FROM users SELF JOIN users AS clients

SELECT $*$ FROM users JOIN users AS clients

None of the above, a self join type does not exist in MySQL

Clear Selection

MySQL: String Comparison

Select the expression that causes a MySQL error.

Pick ONE OR MORE options

SELECT $*$ FROM transactions WHERE flag IN$(\text{'}$A$\text{'},\text{'}$B$\text{'},\text{'}$C$\text{'})$

SELECT $*$ FROM transactions WHERE flag BETWEEN $\text{'}$A$\text{'}$ AND $\text{'}$C$\text{'}$

SELECT $*$ FROM transactions WHERE flag $>=\text{'}$A$\text{'}$ AND flag $\text{'}$C$\text{'}$

none of the above, all expressions are correct