All Questions
3 questions
0
votes
1
answer
206
views
Problem taking a SUM with SQL to python
I am doing Finance and I am fighting with this code... could anyone help me?
I want to "select" some data from a sql table and put this value to a variable in python (a specific FLOAT number)...
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) ...
- 5
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 ...
- 193