Sha256: d717929eecd9351435a462821f9c4e8b445f9da475347751a9fff84399fb98c6
Contents?: true
Size: 718 Bytes
Versions: 5
Compression:
Stored size: 718 Bytes
Contents
- alf: |-
intersect(suppliers_in_paris, suppliers_in_london)
sql: |-
(SELECT t1.sid, t1.name, t1.status, t1.city
FROM suppliers AS t1
WHERE t1.city = 'Paris')
INTERSECT
(SELECT t2.sid, t2.name, t2.status, t2.city
FROM suppliers AS t2
WHERE t2.city = 'London')
- alf: |-
intersect(intersect(suppliers_in_paris, suppliers_in_london), suppliers)
sql: |-
((SELECT t1.sid, t1.name, t1.status, t1.city
FROM suppliers AS t1
WHERE t1.city = 'Paris')
INTERSECT
(SELECT t2.sid, t2.name, t2.status, t2.city
FROM suppliers AS t2
WHERE t2.city = 'London'))
INTERSECT
(SELECT t3.sid, t3.name, t3.status, t3.city
FROM suppliers AS t3)
Version data entries
5 entries across 5 versions & 1 rubygems