WHERE filters, ORDER BY sorts, LIMIT caps the rows you print.

Goal

Filter Nairobi sales and print the top row.

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE sales (city TEXT, units INTEGER)")
con.executemany("INSERT INTO sales VALUES (?, ?)", [("Nairobi", 12), ("Kisumu", 3), ("Nairobi", 7)])
print(con.execute("SELECT * FROM sales WHERE city = 'Nairobi'").fetchall())
con.close()

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE sales (city TEXT, units INTEGER)")
con.executemany("INSERT INTO sales VALUES (?, ?)", [("Nairobi", 12), ("Kisumu", 3), ("Mombasa", 9)])
print(con.execute("SELECT * FROM sales ORDER BY units DESC").fetchall())
con.close()

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE sales (city TEXT, units INTEGER)")
con.executemany("INSERT INTO sales VALUES (?, ?)", [("Nairobi", 12), ("Kisumu", 3), ("Mombasa", 9)])
print(con.execute("SELECT * FROM sales ORDER BY units DESC LIMIT 1").fetchall())
con.close()

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE sales (city TEXT, units INTEGER)")
con.executemany("INSERT INTO sales VALUES (?, ?)", [("Nairobi", 12), ("Kisumu", 3)])
print(con.execute("SELECT city FROM sales WHERE units >= 10").fetchall())
con.close()