Recently I have seen a lot of similar questions that boil down to same idea:

> 
> I need to select values from my table that have a row meeting one requirement and another row meeting another requirement.
> 
> 
> 

To explain what I mean, consider this table:

```
| student | course  |
+---------+---------+
|  Adam   | Math    |
|  Adam   | Science |
|  John   | Math    |
|  John   | Science |
|  Jane   | Math    |
|  Jane   | Physics |

```

I want to pull all students who are taking *both* math and science. This means Adam and John should be returned.

I have seen these questions a lot, and they are always under different names that are often related to the project itself. Is there a tag for this type of problem, and a way to mark them as duplicates?

Here are [two](https://stackoverflow.com/questions/27622645/mysql-query-to-run-query-after-grouping-rows-based-on-product-id) examples of questions I've seen in the last [few](https://stackoverflow.com/questions/27570493/find-rows-from-the-results-of-one-query-that-meet-another-requirement) days alone.

Both questions could be solved in the same way, but it's a stretch and difficult to mark them as duplicates. 

What can we do to not only remove duplicate problems, but also make it easier for new users to find these questions in the future as to avoid creating more duplicates?

**EDIT**

Thanks to the comments, I have learned that this sort of question is known as relational division. However, I imagine this may remain unknown to many users (such as myself until today) and I'm wondering if there's anything we can do to flag duplicates and/or make it easier for new users to find these questions.