Skip to content

Instantly share code, notes, and snippets.

@briu

briu/customers.sql

Created August 26, 2016 15:23
Show Gist options
  • Save briu/3fa94fb0fee3aedc518393fea81f5c35 to your computer and use it in GitHub Desktop.
Save briu/3fa94fb0fee3aedc518393fea81f5c35 to your computer and use it in GitHub Desktop.
Download ZIP
interview
Raw
customers.sql
CREATE TABLE customers (
source_id integer,
name varchar(255)
);
INSERT INTO customers (source_id, name) values (null, 't1'), (1, 't2'), (2, 't3'), (3, 't5'), (null, 't5');
SELECT COUNT(*) FROM customers WHERE source_id <> 3;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment