Question

What will the output of the following query on the table below

Answer 1

It will return 0 rows, because there are no rows that have two different Name values at the same time. The AND statement makes this impossible.

Answer 2

Answer:

The query will return an empty result (i.e. zero rows)

Explanation:

The meaning of the query is that;

Select all rows where the value of Name column is Mary and at the same time the value or content of the name column is Joe.

This is impossible. Why?

Because every row and column of a table is distinct and unique.

No single row or column can contain more than one value at a time.

Since this is not possible because of the AND condition, the MySQL query will definitely return an empty result.

See attachment below.