Class O2.S3 (Duration, Element, Computed)


=centercr @ []QUERY Q 3.3.1: When did somebody have the same salary for the longest continuous period?
ANSWER: ``09/01/86–01/01/90''
CATEGORY: (None, Element, Derived) / (Duration, Element, Computed) (temporal aggregate) /


=centercr @ []QUERY Q 3.3.2: When did anybody work for a manager in a department for as long as that manager managed that department?
ANSWER: ``1/1/82–1/1/90'' and ``4/1/87–1/1/90.''
CATEGORY: (None, Element, Union) / (Duration, Element, Computed) /


=centercr @ []QUERY Q 3.3.3: When did someone manage the Toy department for longer than DI did?
ANSWER: ``No time.''
CATEGORY: (None, Element, Union) / (Duration, Element, Computed) / (=, Constant) (=, Constant)


=centercr @ []QUERY Q 3.3.4: When did anyone have a skill longer than ED had Driving?
ANSWER: ``{ [1/1/82 - now], [4/1/82 - now], [1/1/85 - now] }''
CATEGORY: (None, Element, Union) / (Duration, Element, Computed) / (=, Constant) (=, Constant)