All Questions
3 questions
0
votes
1
answer
75
views
pset 7 houses passes check 50 but shows the names 4 times
I have a really strange problem here: both import and rooster passes every check in check 50, but if I run Rooster the names on every house appear 4 times. I have no clue about why this is happening, ...
0
votes
1
answer
71
views
PSET 7 HOUSES - Syntax error on case function
I'm trying to select the first name and last name and ONLY select the middle name when there is one. The logic of my query makes sense. Every time I am extracting the first name, last name, and birth. ...
- 5
0
votes
1
answer
515
views
pset7 houses: dict to SQL
I need to pass a python dict to a database with SQL.
one of my dicts is:
print(student[1])
{'first': 'Adrian', 'house': 'Slytherin', 'birth': '1977', 'middle': 'NULL', 'last': 'Pucey'}
I want to ...
- 153