Clarifications about Assignment 1
Some issues regarding Assignment 1 have been raised and I wanted to clarify them with everyone:
- The handout stated that questions should be sent to Espen Volnes (espenvol@ifi.uio.no), but this is a mistake they should be sent to Marta Quemada Lopez (martaq@ifi.uio.no), the document has now been corrected.
- Exercise 4 in the handout says that the right answer should contain 7 tuples, but it will also be accepted if the answer only contains 2 tuples.
- Some students have raised questions regarding how to format timestamps into dates, there is information regarding this here: https://esper.espertech.com/release-5.3.0/esper-reference/html/datetimereference.html#datetime-method-format
Take into account that if you apply a function on the timestamp (like max or min; last and first don't allow this in the Esper version we are using) the formatting should be done afterward, for example:
SELECT MAX(timestamp).toDate() as last_date, ……
Publisert 25. sep. 2023 14:01
- Sist endret 5. okt. 2023 10:44