[quote user="Leszek Gniadkowski"] And dishdy should be 5 sql stars (after correct data) and please correct order of Beakdan and xaloc rows [/quote] Corrected the order of Beakdan. Regarding the sqlstars of @dishdy, let me recalculate and get back to y

[quote user="Leszek Gniadkowski"] In 1st line should be ",,karinloos" instead of ",karinloos". [/quote] Corrected.

@Pragnesh, I corrected it. Thanks

@Sean, It was a typo. Fixed it. Thanks

This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string. This challenge has got a fake (or self?) reference to the TSQL Challenges itself. Your job is to calc

[quote user="Mazhar Ehsan"] Hi Jacob, It would also be nice to be confirmed that the time stamp data in the field 'DownTime' will always be in the default format YYYY-MM-DD HH:MM [/quote] Hi Mazhar, The time data will always be in the above forma

At present the evaluation system we have does not support this. That is one of the reason why we do not allow multi-statement queries. In the future, we may be able to allow them.

[quote user="Parth Patel"] Attendee A logged in TCI time zone and logged out in TCA time zone? [/quote] Yes, that is quite possible.

There will be a prior login record for every logout record.

[quote user="dtodd"] This might be a silly question, but can we assume for the sake of this challenge, that all datetimes are perfect 5 min intervals? [/quote] Yes, you can assume that.