sample_data.sql

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);