def METHOD_NAME(conn, fuel_type_abbrev: str):
    res = conn.execute(sa.text('SELECT id FROM fuel_types WHERE abbrev = \'{}\''.format(fuel_type_abbrev)))
    results = res.fetchall()
    return results[0][0]