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 `sum()`

```
select 
    sum(case when winner='white' then 1 else 0 end) as white,
    sum(case when winner='black' then 1 else 0 end) as black
from tableA

```