Question: Is there a function like millis() from Arduino IDE in Python? I tried to manipulate date and time stuff in python but can't find or get anything close to the millis() function from Arduino.

Answer: 
Use conditional aggregation:

```
SELECT
    COUNT(CASE WHEN winner = 'white' THEN 1 END) AS WHITE_WINS,
    COUNT(CASE WHEN winner = 'black' THEN 1 END) AS BLACK_WINS
FROM yourTable;

```
Use below one.

```
SELECT COUNT(CASE 
            WHEN winner = 'white'
                THEN 1
            ELSE 0
            END) AS WHITE_WINS
    ,COUNT(CASE 
            WHEN winner = 'black'
                THEN 1
            ELSE 0
            END) AS BLACK_WINS
FROM ChessTable;

```