The offices table in the default database on the VM includes one row with NULL in state_province column. Which of the following would provide that row in the result? Check all that apply.
Question 8
The offices table in the default database on the VM includes one row with NULL in state_province column. Which of the following would provide that row in the result? Check all that apply.
1 point
- SELECT * from default.offices WHERE state_province=”Santa Fe” AND state_province IS NOT NULL
- SELECT * from default.offices WHERE state_province=”Santa Fe” OR state_province IS NULL
- SELECT * from default.offices WHERE state_province IS NULL
- SELECT * from default.offices WHERE state_province=”Santa Fe” AND state_province IS NULL
- SELECT * from default.offices WHERE state_province IS NOT NULL
- SELECT * from default.offices WHERE state_province=”Santa Fe” OR state_province IS NOT NULL