Uncategorized

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

Similar Posts