kazminaviktoriya1
Пригласите друга
В профиль
Выход
![](data:image/svg+xml,<svg xmlns="http://www.w3.org/2000/svg" width="42" height="42"><rect fill-opacity="0"/></svg>)
Добавить аккаунт
Чат поддержки
Практикум
Привет! Это поддержка Практикума 👋 Если что-то не получается — постараемся помочь. Пишите в чат или выберите другой способ связипт, 2 декабряв 17:21
Мы уже начали заниматься вашим вопросом, ответим в ближайшее время
Практикум
Здравствуйте!
Поддержка не сможет помочь с вопросами, связанными с теорией или задачам из курса «Системный аналитик» — в этой ситуации рекомендуем вам обратиться к вашему преподавателю в чате в Slack.
Если же у вас возникнут иные вопросы — обязательно пишите, будем рады помочь :)
17:24
Выбрать способ связи
Обзор тренажера
1.
Добавьте условие в код задания: выгрузите из таблицы
invoice несколько полей, в которых указаны идентификаторы покупателей от 20 до 50 включительно.Подсказка
Чтобы указать диапазон значений, воспользуйтесь оператором
BETWEEN.2.
Добавьте к выгруженным полям информацию о месяце и неделе заказа. Информацию о дате хранит поле
invoice_date. Месяц заказа должен быть представлен первым числом месяца в формате '2009-01-01 00:00:00', а неделя заказа — номером недели. Не забудьте изменить тип данных поля
invoice_date, чтобы применить функции для работы с датой. Поменяйте тип данных поля на timestamp. Тогда данные не исказятся от автоматической поправки на часовой пояс.Подсказка
Измените тип данных поля
invoice_date на timestamp. Выгрузите информацию о месяце и неделе заказа с помощью функций DATE_TRUNC и EXTRACT.3.
Отфильтруйте получившуюся таблицу по номерам недель. Оставьте в таблице данные за 5, 7, 10, 33 и 48-ю недели.
Подсказка
4.
Выгрузите из таблицы
invoice всю информацию о заказах, оформленных первого числа каждого месяца. Не забудьте привести дату к типу timestamp.Подсказка
5.
Выгрузите адреса электронной почты сотрудников из города Калгари (англ. Calgary), которых наняли на работу в 2002 году.
Подсказка
Код
xxxxxxxxxx1
SELECT customer_id,2
total,3
invoice_date,4
DATE_TRUNC('month', CAST(invoice_date AS timestamp)),5
EXTRACT(WEEK FROM CAST(invoice_date AS timestamp))6
FROM invoice7
WHERE customer_id BETWEEN 20 AND 508
--AND DATE_TRUNC('month', invoice_date); Результат
| customer_id | total | invoice_date | date_trunc | date_part |
|---|---|---|---|---|
| 23 | 13.86 | 2009-01-11 00:00:00 | 2009-01-01 00:00:00 | 2 |
| 37 | 0.99 | 2009-01-19 00:00:00 | 2009-01-01 00:00:00 | 4 |
| 38 | 1.98 | 2009-02-01 00:00:00 | 2009-02-01 00:00:00 | 5 |
| 40 | 1.98 | 2009-02-01 00:00:00 | 2009-02-01 00:00:00 | 5 |
| 42 | 3.96 | 2009-02-02 00:00:00 | 2009-02-01 00:00:00 | 6 |
| 46 | 5.94 | 2009-02-03 00:00:00 | 2009-02-01 00:00:00 | 6 |
| 21 | 3.96 | 2009-03-05 00:00:00 | 2009-03-01 00:00:00 | 10 |
| 25 | 5.94 | 2009-03-06 00:00:00 | 2009-03-01 00:00:00 | 10 |
| 31 | 8.91 | 2009-03-09 00:00:00 | 2009-03-01 00:00:00 | 11 |
| 40 | 13.86 | 2009-03-14 00:00:00 | 2009-03-01 00:00:00 | 11 |
| 33 | 0.99 | 2009-04-22 00:00:00 | 2009-04-01 00:00:00 | 17 |
| 34 | 1.98 | 2009-05-05 00:00:00 | 2009-05-01 00:00:00 | 19 |
| 36 | 1.98 | 2009-05-05 00:00:00 | 2009-05-01 00:00:00 | 19 |
| 38 | 3.96 | 2009-05-06 00:00:00 | 2009-05-01 00:00:00 | 19 |
| 42 | 5.94 | 2009-05-07 00:00:00 | 2009-05-01 00:00:00 | 19 |
| 48 | 8.91 | 2009-05-10 00:00:00 | 2009-05-01 00:00:00 | 19 |
| 21 | 5.94 | 2009-06-07 00:00:00 | 2009-06-01 00:00:00 | 23 |
| 27 | 8.91 | 2009-06-10 00:00:00 | 2009-06-01 00:00:00 | 24 |
| 36 | 13.86 | 2009-06-15 00:00:00 | 2009-06-01 00:00:00 | 25 |
| 50 | 0.99 | 2009-06-23 00:00:00 | 2009-06-01 00:00:00 | 26 |
| 29 | 0.99 | 2009-07-24 00:00:00 | 2009-07-01 00:00:00 | 30 |
| 30 | 1.98 | 2009-08-06 00:00:00 | 2009-08-01 00:00:00 | 32 |
| 32 | 1.98 | 2009-08-06 00:00:00 | 2009-08-01 00:00:00 | 32 |
| 34 | 3.96 | 2009-08-07 00:00:00 | 2009-08-01 00:00:00 | 32 |
| 38 | 5.94 | 2009-08-08 00:00:00 | 2009-08-01 00:00:00 | 32 |
| 44 | 8.91 | 2009-08-11 00:00:00 | 2009-08-01 00:00:00 | 33 |
| 23 | 8.91 | 2009-09-11 00:00:00 | 2009-09-01 00:00:00 | 37 |
| 32 | 13.86 | 2009-09-16 00:00:00 | 2009-09-01 00:00:00 | 38 |
| 46 | 0.99 | 2009-09-24 00:00:00 | 2009-09-01 00:00:00 | 39 |
| 47 | 1.98 | 2009-10-07 00:00:00 | 2009-10-01 00:00:00 | 41 |
| 49 | 1.98 | 2009-10-07 00:00:00 | 2009-10-01 00:00:00 | 41 |
| 25 | 0.99 | 2009-10-25 00:00:00 | 2009-10-01 00:00:00 | 43 |
| 26 | 1.98 | 2009-11-07 00:00:00 | 2009-11-01 00:00:00 | 45 |
| 28 | 1.98 | 2009-11-07 00:00:00 | 2009-11-01 00:00:00 | 45 |
| 30 | 3.96 | 2009-11-08 00:00:00 | 2009-11-01 00:00:00 | 45 |
| 34 | 5.94 | 2009-11-09 00:00:00 | 2009-11-01 00:00:00 | 46 |
| 40 | 8.91 | 2009-11-12 00:00:00 | 2009-11-01 00:00:00 | 46 |
| 49 | 13.86 | 2009-11-17 00:00:00 | 2009-11-01 00:00:00 | 47 |
| 28 | 13.86 | 2009-12-18 00:00:00 | 2009-12-01 00:00:00 | 51 |
| 42 | 0.99 | 2009-12-26 00:00:00 | 2009-12-01 00:00:00 | 52 |
| 43 | 1.98 | 2010-01-08 00:00:00 | 2010-01-01 00:00:00 | 1 |
| 45 | 1.98 | 2010-01-08 00:00:00 | 2010-01-01 00:00:00 | 1 |
| 47 | 3.96 | 2010-01-09 00:00:00 | 2010-01-01 00:00:00 | 1 |
| 21 | 0.99 | 2010-01-26 00:00:00 | 2010-01-01 00:00:00 | 4 |
| 22 | 1.98 | 2010-02-08 00:00:00 | 2010-02-01 00:00:00 | 6 |
| 24 | 1.98 | 2010-02-08 00:00:00 | 2010-02-01 00:00:00 | 6 |
| 26 | 3.96 | 2010-02-09 00:00:00 | 2010-02-01 00:00:00 | 6 |
| 30 | 5.94 | 2010-02-10 00:00:00 | 2010-02-01 00:00:00 | 6 |
| 36 | 8.91 | 2010-02-13 00:00:00 | 2010-02-01 00:00:00 | 6 |
| 45 | 21.86 | 2010-02-18 00:00:00 | 2010-02-01 00:00:00 | 7 |
| 24 | 15.86 | 2010-03-21 00:00:00 | 2010-03-01 00:00:00 | 11 |
| 38 | 0.99 | 2010-03-29 00:00:00 | 2010-03-01 00:00:00 | 13 |
| 39 | 1.98 | 2010-04-11 00:00:00 | 2010-04-01 00:00:00 | 14 |
| 41 | 1.98 | 2010-04-11 00:00:00 | 2010-04-01 00:00:00 | 14 |
| 43 | 3.96 | 2010-04-12 00:00:00 | 2010-04-01 00:00:00 | 15 |
| 47 | 5.94 | 2010-04-13 00:00:00 | 2010-04-01 00:00:00 | 15 |
| 20 | 1.98 | 2010-05-12 00:00:00 | 2010-05-01 00:00:00 | 19 |
| 22 | 3.96 | 2010-05-13 00:00:00 | 2010-05-01 00:00:00 | 19 |
| 26 | 5.94 | 2010-05-14 00:00:00 | 2010-05-01 00:00:00 | 19 |
| 32 | 8.91 | 2010-05-17 00:00:00 | 2010-05-01 00:00:00 | 20 |
| 41 | 13.86 | 2010-05-22 00:00:00 | 2010-05-01 00:00:00 | 20 |
| 20 | 13.86 | 2010-06-22 00:00:00 | 2010-06-01 00:00:00 | 25 |
| 34 | 0.99 | 2010-06-30 00:00:00 | 2010-06-01 00:00:00 | 26 |
| 35 | 1.98 | 2010-07-13 00:00:00 | 2010-07-01 00:00:00 | 28 |
| 37 | 1.98 | 2010-07-13 00:00:00 | 2010-07-01 00:00:00 | 28 |
| 39 | 3.96 | 2010-07-14 00:00:00 | 2010-07-01 00:00:00 | 28 |
| 43 | 5.94 | 2010-07-15 00:00:00 | 2010-07-01 00:00:00 | 28 |
| 49 | 8.91 | 2010-07-18 00:00:00 | 2010-07-01 00:00:00 | 28 |
| 22 | 5.94 | 2010-08-15 00:00:00 | 2010-08-01 00:00:00 | 32 |
| 28 | 8.91 | 2010-08-18 00:00:00 | 2010-08-01 00:00:00 | 33 |
| 37 | 13.86 | 2010-08-23 00:00:00 | 2010-08-01 00:00:00 | 34 |
| 30 | 0.99 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 39 |
| 31 | 1.98 | 2010-10-14 00:00:00 | 2010-10-01 00:00:00 | 41 |
| 33 | 1.98 | 2010-10-14 00:00:00 | 2010-10-01 00:00:00 | 41 |
| 35 | 3.96 | 2010-10-15 00:00:00 | 2010-10-01 00:00:00 | 41 |
| 39 | 5.94 | 2010-10-16 00:00:00 | 2010-10-01 00:00:00 | 41 |
| 45 | 8.91 | 2010-10-19 00:00:00 | 2010-10-01 00:00:00 | 42 |
| 24 | 8.91 | 2010-11-19 00:00:00 | 2010-11-01 00:00:00 | 46 |
| 33 | 13.86 | 2010-11-24 00:00:00 | 2010-11-01 00:00:00 | 47 |
| 47 | 0.99 | 2010-12-02 00:00:00 | 2010-12-01 00:00:00 | 48 |
| 48 | 1.98 | 2010-12-15 00:00:00 | 2010-12-01 00:00:00 | 50 |
| 50 | 1.98 | 2010-12-15 00:00:00 | 2010-12-01 00:00:00 | 50 |
| 26 | 0.99 | 2011-01-02 00:00:00 | 2011-01-01 00:00:00 | 52 |
| 27 | 1.98 | 2011-01-15 00:00:00 | 2011-01-01 00:00:00 | 2 |
| 29 | 1.98 | 2011-01-15 00:00:00 | 2011-01-01 00:00:00 | 2 |
| 31 | 3.96 | 2011-01-16 00:00:00 | 2011-01-01 00:00:00 | 2 |
| 35 | 5.94 | 2011-01-17 00:00:00 | 2011-01-01 00:00:00 | 3 |
| 41 | 8.91 | 2011-01-20 00:00:00 | 2011-01-01 00:00:00 | 3 |
| 50 | 13.86 | 2011-01-25 00:00:00 | 2011-01-01 00:00:00 | 4 |
| 20 | 8.91 | 2011-02-20 00:00:00 | 2011-02-01 00:00:00 | 7 |
| 29 | 13.86 | 2011-02-25 00:00:00 | 2011-02-01 00:00:00 | 8 |
| 43 | 0.99 | 2011-03-05 00:00:00 | 2011-03-01 00:00:00 | 9 |
| 44 | 1.98 | 2011-03-18 00:00:00 | 2011-03-01 00:00:00 | 11 |
| 46 | 1.98 | 2011-03-18 00:00:00 | 2011-03-01 00:00:00 | 11 |
| 48 | 3.96 | 2011-03-19 00:00:00 | 2011-03-01 00:00:00 | 11 |
| 22 | 0.99 | 2011-04-05 00:00:00 | 2011-04-01 00:00:00 | 14 |
| 23 | 1.98 | 2011-04-18 00:00:00 | 2011-04-01 00:00:00 | 16 |
| 25 | 1.98 | 2011-04-18 00:00:00 | 2011-04-01 00:00:00 | 16 |
| 27 | 3.96 | 2011-04-19 00:00:00 | 2011-04-01 00:00:00 | 16 |
| 31 | 5.94 | 2011-04-20 00:00:00 | 2011-04-01 00:00:00 | 16 |
| 37 | 14.91 | 2011-04-23 00:00:00 | 2011-04-01 00:00:00 | 16 |
| 46 | 21.86 | 2011-04-28 00:00:00 | 2011-04-01 00:00:00 | 17 |
| 25 | 18.86 | 2011-05-29 00:00:00 | 2011-05-01 00:00:00 | 21 |
| 39 | 1.99 | 2011-06-06 00:00:00 | 2011-06-01 00:00:00 | 23 |
| 40 | 2.98 | 2011-06-19 00:00:00 | 2011-06-01 00:00:00 | 24 |
| 42 | 3.98 | 2011-06-19 00:00:00 | 2011-06-01 00:00:00 | 24 |
| 44 | 7.96 | 2011-06-20 00:00:00 | 2011-06-01 00:00:00 | 25 |
| 48 | 8.94 | 2011-06-21 00:00:00 | 2011-06-01 00:00:00 | 25 |
| 21 | 1.98 | 2011-07-20 00:00:00 | 2011-07-01 00:00:00 | 29 |
| 23 | 3.96 | 2011-07-21 00:00:00 | 2011-07-01 00:00:00 | 29 |
| 27 | 5.94 | 2011-07-22 00:00:00 | 2011-07-01 00:00:00 | 29 |
| 33 | 8.91 | 2011-07-25 00:00:00 | 2011-07-01 00:00:00 | 30 |
| 42 | 13.86 | 2011-07-30 00:00:00 | 2011-07-01 00:00:00 | 30 |
| 21 | 13.86 | 2011-08-30 00:00:00 | 2011-08-01 00:00:00 | 35 |
| 35 | 0.99 | 2011-09-07 00:00:00 | 2011-09-01 00:00:00 | 36 |
| 36 | 1.98 | 2011-09-20 00:00:00 | 2011-09-01 00:00:00 | 38 |
| 38 | 1.98 | 2011-09-20 00:00:00 | 2011-09-01 00:00:00 | 38 |
| 40 | 3.96 | 2011-09-21 00:00:00 | 2011-09-01 00:00:00 | 38 |
| 44 | 5.94 | 2011-09-22 00:00:00 | 2011-09-01 00:00:00 | 38 |
| 50 | 8.91 | 2011-09-25 00:00:00 | 2011-09-01 00:00:00 | 38 |
| 23 | 5.94 | 2011-10-23 00:00:00 | 2011-10-01 00:00:00 | 42 |
| 29 | 8.91 | 2011-10-26 00:00:00 | 2011-10-01 00:00:00 | 43 |
| 38 | 13.86 | 2011-10-31 00:00:00 | 2011-10-01 00:00:00 | 44 |
| 31 | 0.99 | 2011-12-09 00:00:00 | 2011-12-01 00:00:00 | 49 |
| 32 | 1.98 | 2011-12-22 00:00:00 | 2011-12-01 00:00:00 | 51 |
| 34 | 1.98 | 2011-12-22 00:00:00 | 2011-12-01 00:00:00 | 51 |
| 36 | 3.96 | 2011-12-23 00:00:00 | 2011-12-01 00:00:00 | 51 |
| 40 | 5.94 | 2011-12-24 00:00:00 | 2011-12-01 00:00:00 | 51 |
| 46 | 8.91 | 2011-12-27 00:00:00 | 2011-12-01 00:00:00 | 52 |
| 25 | 8.91 | 2012-01-27 00:00:00 | 2012-01-01 00:00:00 | 4 |
| 34 | 13.86 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 5 |
| 48 | 0.99 | 2012-02-09 00:00:00 | 2012-02-01 00:00:00 | 6 |
| 49 | 1.98 | 2012-02-22 00:00:00 | 2012-02-01 00:00:00 | 8 |
| 27 | 0.99 | 2012-03-11 00:00:00 | 2012-03-01 00:00:00 | 10 |
| 28 | 1.98 | 2012-03-24 00:00:00 | 2012-03-01 00:00:00 | 12 |
| 30 | 1.98 | 2012-03-24 00:00:00 | 2012-03-01 00:00:00 | 12 |
| 32 | 3.96 | 2012-03-25 00:00:00 | 2012-03-01 00:00:00 | 12 |
| 36 | 5.94 | 2012-03-26 00:00:00 | 2012-03-01 00:00:00 | 13 |
| 42 | 8.91 | 2012-03-29 00:00:00 | 2012-03-01 00:00:00 | 13 |
| 21 | 8.91 | 2012-04-29 00:00:00 | 2012-04-01 00:00:00 | 17 |
| 30 | 13.86 | 2012-05-04 00:00:00 | 2012-05-01 00:00:00 | 18 |
| 44 | 0.99 | 2012-05-12 00:00:00 | 2012-05-01 00:00:00 | 19 |
| 45 | 1.98 | 2012-05-25 00:00:00 | 2012-05-01 00:00:00 | 21 |
| 47 | 1.98 | 2012-05-25 00:00:00 | 2012-05-01 00:00:00 | 21 |
| 49 | 3.96 | 2012-05-26 00:00:00 | 2012-05-01 00:00:00 | 21 |
| 23 | 0.99 | 2012-06-12 00:00:00 | 2012-06-01 00:00:00 | 24 |
| 24 | 1.98 | 2012-06-25 00:00:00 | 2012-06-01 00:00:00 | 26 |
| 26 | 1.98 | 2012-06-25 00:00:00 | 2012-06-01 00:00:00 | 26 |
| 28 | 3.96 | 2012-06-26 00:00:00 | 2012-06-01 00:00:00 | 26 |
| 32 | 5.94 | 2012-06-27 00:00:00 | 2012-06-01 00:00:00 | 26 |
| 38 | 8.91 | 2012-06-30 00:00:00 | 2012-06-01 00:00:00 | 26 |
| 47 | 13.86 | 2012-07-05 00:00:00 | 2012-07-01 00:00:00 | 27 |
| 26 | 23.86 | 2012-08-05 00:00:00 | 2012-08-01 00:00:00 | 31 |
| 40 | 0.99 | 2012-08-13 00:00:00 | 2012-08-01 00:00:00 | 33 |
| 41 | 1.98 | 2012-08-26 00:00:00 | 2012-08-01 00:00:00 | 34 |
| 43 | 1.98 | 2012-08-26 00:00:00 | 2012-08-01 00:00:00 | 34 |
| 45 | 3.96 | 2012-08-27 00:00:00 | 2012-08-01 00:00:00 | 35 |
| 49 | 5.94 | 2012-08-28 00:00:00 | 2012-08-01 00:00:00 | 35 |
| 20 | 3.98 | 2012-09-26 00:00:00 | 2012-09-01 00:00:00 | 39 |
| 22 | 3.98 | 2012-09-26 00:00:00 | 2012-09-01 00:00:00 | 39 |
| 24 | 7.96 | 2012-09-27 00:00:00 | 2012-09-01 00:00:00 | 39 |
| 28 | 11.94 | 2012-09-28 00:00:00 | 2012-09-01 00:00:00 | 39 |
| 34 | 10.91 | 2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 40 |
| 43 | 16.86 | 2012-10-06 00:00:00 | 2012-10-01 00:00:00 | 40 |
| 22 | 13.86 | 2012-11-06 00:00:00 | 2012-11-01 00:00:00 | 45 |
| 36 | 0.99 | 2012-11-14 00:00:00 | 2012-11-01 00:00:00 | 46 |
| 37 | 1.98 | 2012-11-27 00:00:00 | 2012-11-01 00:00:00 | 48 |
| 39 | 1.98 | 2012-11-27 00:00:00 | 2012-11-01 00:00:00 | 48 |
| 41 | 3.96 | 2012-11-28 00:00:00 | 2012-11-01 00:00:00 | 48 |
| 45 | 5.94 | 2012-11-29 00:00:00 | 2012-11-01 00:00:00 | 48 |
| 20 | 3.96 | 2012-12-29 00:00:00 | 2012-12-01 00:00:00 | 52 |
| 24 | 5.94 | 2012-12-30 00:00:00 | 2012-12-01 00:00:00 | 52 |
| 30 | 8.91 | 2013-01-02 00:00:00 | 2013-01-01 00:00:00 | 1 |
| 39 | 13.86 | 2013-01-07 00:00:00 | 2013-01-01 00:00:00 | 2 |
| 32 | 0.99 | 2013-02-15 00:00:00 | 2013-02-01 00:00:00 | 7 |
| 33 | 1.98 | 2013-02-28 00:00:00 | 2013-02-01 00:00:00 | 9 |
| 35 | 1.98 | 2013-02-28 00:00:00 | 2013-02-01 00:00:00 | 9 |
| 37 | 3.96 | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 | 9 |
| 41 | 5.94 | 2013-03-02 00:00:00 | 2013-03-01 00:00:00 | 9 |
| 47 | 8.91 | 2013-03-05 00:00:00 | 2013-03-01 00:00:00 | 10 |
| 20 | 5.94 | 2013-04-02 00:00:00 | 2013-04-01 00:00:00 | 14 |
| 26 | 8.91 | 2013-04-05 00:00:00 | 2013-04-01 00:00:00 | 14 |
| 35 | 13.86 | 2013-04-10 00:00:00 | 2013-04-01 00:00:00 | 15 |
| 49 | 0.99 | 2013-04-18 00:00:00 | 2013-04-01 00:00:00 | 16 |
| 50 | 1.98 | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 | 18 |
| 28 | 0.99 | 2013-05-19 00:00:00 | 2013-05-01 00:00:00 | 20 |
| 29 | 1.98 | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 | 22 |
| 31 | 1.98 | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 | 22 |
| 33 | 3.96 | 2013-06-02 00:00:00 | 2013-06-01 00:00:00 | 22 |
| 37 | 5.94 | 2013-06-03 00:00:00 | 2013-06-01 00:00:00 | 23 |
| 43 | 8.91 | 2013-06-06 00:00:00 | 2013-06-01 00:00:00 | 23 |
| 22 | 8.91 | 2013-07-07 00:00:00 | 2013-07-01 00:00:00 | 27 |
| 31 | 13.86 | 2013-07-12 00:00:00 | 2013-07-01 00:00:00 | 28 |
| 45 | 0.99 | 2013-07-20 00:00:00 | 2013-07-01 00:00:00 | 29 |
| 46 | 1.98 | 2013-08-02 00:00:00 | 2013-08-01 00:00:00 | 31 |
| 48 | 1.98 | 2013-08-02 00:00:00 | 2013-08-01 00:00:00 | 31 |
| 50 | 3.96 | 2013-08-03 00:00:00 | 2013-08-01 00:00:00 | 31 |
| 24 | 0.99 | 2013-08-20 00:00:00 | 2013-08-01 00:00:00 | 34 |
| 25 | 1.98 | 2013-09-02 00:00:00 | 2013-09-01 00:00:00 | 36 |
| 27 | 1.98 | 2013-09-02 00:00:00 | 2013-09-01 00:00:00 | 36 |