7 / 10
SQL (SQLite engine)

Handle NULL with IS NULL

Easy30 pts~12 min
  • Acme Commerce DB
Practice app · Acme Commerce DB

A real SQL database (SQLite engine) seeded with an e-commerce and HR dataset, with schema browser and query runner.

Test URL
/lab/databases-handle-null-with-is-null

Your starter code already declares TEST_URL — never hardcode a host.

Objective

Handle NULL with IS NULL. Practise it against the Acme Commerce DB practice application (A real SQL database (SQLite engine) seeded with an e-commerce and HR dataset, with schema browser and query runner.).

Your task

  1. 1Open the practice application at the test URL shown above and wait for it to finish loading.
  2. 2Inspect the page to find the elements you need — key elements include #schema-browser, #sql-editor, #run-query.
  3. 3Write and run a test that demonstrates: handle null with is null.
  4. 4Finish with at least one assertion on a user-visible outcome, not an internal detail.

Acceptance criteria

  • The test runs to completion without errors.
  • The test contains at least one passing assertion on a user-visible outcome.

SQL (SQLite engine) · Databases · SQL basics: SELECT