artem78

+----+-------+
| id | value |
+----+-------+
|  1 | alpha |
|  2 | delta |
|  3 | beta  |
|  4 | gamma |
|  5 | beta  |
|  6 | beta  |
|  7 | alpha |
|  8 | beta  |
+----+-------+

SELECT `value` , COUNT( * ) AS `cnt`
FROM `testtable2`
GROUP BY `value`
ORDER BY `cnt` DESC

+-------+-----+
| value | cnt |
+-------+-----+
| beta  |   4 |
| alpha |   2 |
| delta |   1 |
| gamma |   1 |
+-------+-----+

# coding: utf8

print u'Привет питон!'

from datetime import datetime, timedelta
import calendar

date = datetime.now()
days_in_month = calendar.monthrange(date.year, date.month)[1]
date += timedelta(days=days_in_month)
print(date)

sudo add-apt-repository ppa:jonathonf/python-3.6
sudo apt update
sudo apt install python3.6 idle3

errors = list(map(str.strip, map(str, validator.iter_errors(js))))

import requests

url = 'https://route.cit.api.here.com/routing/7.2/calculateroute.json'
params = {
	'app_id': 'DemoAppId01082013GAL',
	'app_code': 'AJKnXv84fjrb0KIHawS0Tg',
	'waypoint0': 'geo!52.5,13.4',
	'waypoint1': 'geo!52.5,13.45',
	'mode': 'fastest;car;traffic:disabled',
}

response = requests.get(url, params=params)
result = response.json()

The result is always rounded towards minus infinity: 1//2 is 0, (-1)//2 is -1, 1//(-2) is -1, and (-1)//(-2) is 0.