Hi
In practice Lab1 exercise 4 what are the values of active column
When creating a post, please add:
- Module # must be added in the tags option of the post. (ex: Module-1)
- Link to the classroom item you are referring to:
- Description (include relevant info but please do not post solution code or your entire notebook)
Hello @Rosamma,
You could get the values of the active column if you add active in the SELECT statement. Once I SELECT active FROM the staff table as well, I get a boolean. The WHERE Clause will output all the active one, since all of them are 1. Thank you
in the WHERE clause you can use the True value which is represented as a 1 in the database. so …
WHERE active = True
