Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
create table sales (
sold_at datetime,
product_name text,
product_color text,
customer_gender text,
customer_age integer,
customer_prefecture integer
);
insert into sales values ('2017-02-17 11:20:30', 'Cupcake', 'green', 'male', 35, 28);
insert into sales values ('2017-02-17 11:21:49', 'Donut', 'red', 'female', 50, 15);
insert into sales values ('2017-02-17 12:06:07', 'Donut', 'yellow', 'male', 50, 31);
insert into sales values ('2017-02-17 12:15:58', 'Eclair', 'red', 'male', 48, 32);
insert into sales values ('2017-02-17 12:30:06', 'Donut', 'red', 'female', 46, 21);
insert into sales values ('2017-02-17 12:31:23', 'Eclair', 'yellow', 'female', 47, 38);
insert into sales values ('2017-02-17 12:32:46', 'Eclair', 'red', 'female', 43, 41);
insert into sales values ('2017-02-17 12:59:27', 'Cupcake', 'green', 'male', 45, 15);
insert into sales values ('2017-02-17 13:12:12', 'Eclair', 'blue', 'male', 23, 42);
insert into sales values ('2017-02-17 13:39:02', 'Eclair', 'yellow', 'male', 27, 19);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment