sql query results depend on attributes of other table

Cars:

id name
1  Mercedes
2  Audi

​x
 
id name1  Mercedes2  Audi​

CarAttributes:

id car_id attribute
1  1      fast
2  1      modern
3  1      fancy
4  1      green
5  2      fast
6  2      quiet
7  2      blue
8  2      old

 
id car_id attribute1  1      fast2  1      modern3  1      fancy4  1      green5  2      fast6  2      quiet7  2      blue8  2      old​

How would the sql query look if the returns depend on the attributes of the car like following:

[fast OR modern] AND [fancy OR old] = would return both cars
[fast OR modern] AND [old OR blue] = would only return the audi car

 
[fast OR modern] AND [fancy OR old] = would return both cars[fast OR modern] AND [old OR blue] = would only return the audi car​

Answer

You can use aggregation with a having clause:

select car_id
from carattributes
group by car_id
having sum( attribute in ('fast', 'modern')) > 0 and
       sum( attribute in ('fancy', old')) > 0

 
select car_idfrom carattributesgroup by car_idhaving sum( attribute in ('fast', 'modern')) > 0 and       sum( attribute in ('fancy', old')) > 0​