In the Index function on APP.PY of my finance code, I'm getting "RuntimeError: no such column: total_per_share" even though I'm using "AS" to create this column -- please advise.
@app.route("/")
@login_required
def index():
userid = session["user_id"]
"""Show portfolio of stocks"""
# Calculate the sum cash value of each share holding and update it in PORTFOLIO
db.execute("SELECT symbol, shares, price, (shares * price) AS total_per_share, sum(total_per_share) AS total_share FROM portfolio WHERE id = ? GROUP BY symbol", userid)
cash_dict = db.execute("SELECT cash FROM users WHERE id = ?", session["user_id"])
owned_stocks = db.execute("SELECT symbol, total_share, name, sum(shares) AS sum_shares, price FROM portfolio WHERE id = ? GROUP BY symbol", userid)
cash = cash_dict[0]["cash"]
