So I have a relation:
Cars (model, passenger)
All models are unique, say, {A, B, C, D, E}.
Passengers are simply the ability of a car (any positive nonzero integer), say, {1,2,2,3,3}
Model|Passenger
A |1
B |2
C |2
D |3
E |3
I need to find an expression of relational algebra that will provide opportunities for more than one car. Thus, with the above examples, the expression should return {2, 3}, since they appear more than once for different vehicles.
I have a strong tendency to think that the expression will use some kind of connection, but I cannot figure out how to do this.