How to output different rows with same columns?

Question

MySQL

You need to select students living in the same city and on the same street.
The table has three columns: name , city and street .

Answer 1

Here you need to use aliases.
Here is an example for the Customer(cname, city) table:
By analogy, it is easy to complete for your student