=centercr
@ []QUERY Q 2.3.1: Who worked in the Toy department for at least as long as DI worked there?
ANSWER: ``DI''
CATEGORY: (Projected, None) / (Duration, Element, Computed) / (=, Constant)
(=, Constant)
=centercr
@ []QUERY Q 2.3.2: Who worked in a department longer than their current manager worked
in that department?
ANSWER: ``None''
CATEGORY: (Projected, None) / (Duration, Element, Computed) (Containment,
Event, Explicit) /
=centercr
@ []QUERY Q 2.3.3: Which managers managed which departments, longer than Di managed
the Toy department?
ANSWER: ``None''
CATEGORY: (Projected, None) / (Duration, Element, Computed) / (=, Constant)
(=, Constant)
=centercr
@ []QUERY Q 2.3.4: Who had the same salary for the longest total time?
ANSWER: ``ED''
CATEGORY: (Projected, None) / (Duration, Element, Computed) /
=centercr
@ []QUERY Q 2.3.5: Which departments had managers who served for the shortest
total time?
ANSWER: ``Book''
CATEGORY: (Projected, None) / (Duration, Element, Computed) /
=centercr
@ []QUERY Q 2.3.6: List all employees currently in the Book department who
received salaries of over 40K longer than ED did.
ANSWER: ``None''
CATEGORY: (Projected, None) / (Duration, Element, Computed) / (=, Constant)
(<>, Constant) (=, Constant)
=centercr
@ []QUERY Q 2.3.7: Who worked in the Toy department for at least as long as the total
time that the Toy department was NOT managed by ED?
ANSWER: ``DI''
CATEGORY: (Projected, None) / (Duration, Element, Computed) / (=, Constant)
(< >, Constant)
=centercr
@ []QUERY Q 2.3.8: Find the names of employees that have been in a department
named Toy for a shorter period than has DI.
ANSWER: ``Ed'' and ``Edward.''
CATEGORY: (Projected, None) / (Duration, Element, Computed) / (=, Constant)
(=, Constant)
=centercr
@ []QUERY Q 2.3.9: Find the current name and department for the employees which
made $40K for a longer period than DI did.
ANSWER: ``(Edward, Book).''
CATEGORY: (Projected, None) / (Duration, Element, Computed) (Containment,
Event, Explicit) / (=, Constant)