Class O2.S9 (Other, Element, Computed)


=centercr @ []QUERY Q 3.9.1: At what times did an employee simultaneously posses at least the same skills that DI possessed?
ANSWER: ``No times.''
CATEGORY: (None, Element, Intersection) / (Containment, Element, Computed) / (=, Constant)


=centercr @ []QUERY Q 3.9.2: When was the budget for Toy department more than 100K?
ANSWER: ``01/01/82–12/31/86.''
CATEGORY: (None, Element, Derived) / (Containment, Element, Computed) / (=, Constant) (< >, Constant)


=centercr @ []QUERY Q 3.9.3: What was the last continuous period when ED was named Edward and had Driving, Filing and Typing as skills simultaneously?
ANSWER: ``01/01/88–05/31/88.''
CATEGORY: (None, Interval, Intersection) / (Containment, Event, Computed) (temporal aggregate) / (=, Constant) (=, Constant)


=centercr @ []QUERY Q 3.9.4: When did DI earn less than ED?
ANSWER: ``Never.''
CATEGORY: (None, Element, Intersection) / (Duration, Element, Computed) / (=, Constant) (=, Constant)


=centercr @ []QUERY Q 3.9.5: When did ED work in Toy department while the department was managed by DI?
ANSWER: ``02/01/82–01/31/87''
CATEGORY: (None, Element, Union) / (Duration, Element, Computed) / (=, Constant) / (=, Constant) (=, Constant)


=centercr @ []QUERY Q 3.9.6: When did an employee currently named Edward have driving skills?
ANSWER: ``01/01/82–05/01/82'' and ``06/01/84–05/31/88.''
CATEGORY: (None, Element, Derived) / (Containment, Element, Computed) / (=, Constant) (=, Constant)