task1.py

import sqlite3
import os
os.chdir(os.path.dirname(__file__))
print(os.getcwd())


db = sqlite3.connect("bikes.db")
db.isolation_level = None

def distance_of_user(user):
    count=db.execute(f'''
        SELECT SUM(distance)
        FROM Users LEFT JOIN Trips ON Users.id=Trips.user_id
        WHERE Users.name={user}
    ''').fetchone()
    return count


print("Test 1:", distance_of_user("user123"))
# print("Test 2:", speed_of_user("user123"))
# print("Test 3:", duration_in_each_city("2021-06-01"))
# print("Test 4:", users_in_city("city5"))
# print("Test 5:", trips_on_each_day("city5"))
# print("Test 6:", most_popular_start("city5"))