All Questions
2 questions
0
votes
1
answer
91
views
pset7 "index" - using SQL SUM adds a parenthesis to returned dict strings
I executed the following to return a dict (grouped by stock symbols) of stock symbols, total shares and total value owned.
stocks = db.execute("SELECT buy.stock_code, SUM(buy.value), SUM(buy.shares) ...
- 21k
0
votes
1
answer
206
views
SQL SELECT query
Sorry if this is a novice error but I had some problems with SELECT. I executed a query for retrieving all the stocks, which were purchased by a user, in a database called portfolio. 'Usernamer' is a ...
- 13