Error using convert MySQL in Python
In fact, it is not easy to find the right command we need for queries in the MySQL documentation. 
However, by testing, I saw that this should be fine:

sql = f"SELECT DATEDIFF(NOW(), timestamp), count_issue FROM total_unresolved_issue WHERE project = '{project}'"


DATEDIFF(NOW(), timestamp) returns the difference between two dates in days.