create table t1 (
  pk        integer primary key,
  id integer not null,
  cnt integer not null,
  rank text not null,
  suit text not null
);

insert into t1 values ( 1, 1, 0, 2, "a" );
insert into t1 values ( 2, 1, 1, 4, "b" );
insert into t1 values ( 3, 2, 0, 1, "c" );
insert into t1 values ( 4, 2, 1, 7, "c" );
insert into t1 values ( 5, 3, 0, 2, "d" );
insert into t1 values ( 6, 3, 1, 5, "a" );
insert into t1 values ( 7, 4, 0, 6, "b" );
insert into t1 values ( 8, 4, 1, 6, "c" );