Quant Python

Logins From Two Countries in SQL

Difficulty

Asked at Marshall Wace

Theory: Quant Python That Survives Review

Read the problem, hints and solution here. The editor needs a bigger screen: open this page on a laptop to write and run your code.

This problem is only available to subscribers.

Language: Python 3.12multi_country_logins

import sqlite3


def load_login_attempts(rows: list[tuple[int, int, str, str, str]]) -> sqlite3.Connection:
    """..."""
    conn = sqlite3.connect(":memory:")
    conn.execute(
        "CREATE TABLE login_attempts (attempt_id INTEGER PRIMARY KEY, "
        "user_id INTEGER NOT NULL, ts TEXT NOT NULL, status TEXT NOT NULL, "
        "country TEXT NOT NULL)"
    )
    conn.executemany("INSERT INTO login_attempts VALUES (?, ?, ?, ?, ?)", rows)
    return conn


QUERY = """..."""


def multi_country_logins(conn: sqlite3.Connection) -> list[tuple[int, int, str]]:
    """..."""
    # ...
    return conn.execute(QUERY).fetchall()

Unlock to runUpgrade

Unlock the problem to run it against the tests.

Logins From Two Countries in SQL

xxxxxxxx

xxxxxxxxxxx