Table Schema

 
CREATE TABLE person (
    id          INTEGER      NOT NULL,
    firstname   VARCHAR (25),
    lastname    VARCHAR (30),
    gender      CHAR (1),
    age         INTEGER,
    active_flag CHAR (1),
    PRIMARY KEY (
        id
    )
);

Data

insert into person (firstname, lastname,gender, age, active_flag) values ("James    ", "Bag","M",  28,"");
insert into person (firstname, lastname,gender, age, active_flag) values ("Mary",  "Meigh","F",  "","");
insert into person (firstname, lastname,gender, age, active_flag) values ("Trump", "Sucks"      ,"",  45,"");
insert into person (firstname, lastname,gender, age, active_flag) values ("Trump", "Isacrook"   ,"",  4,"");
insert into person (firstname, lastname,gender, age, active_flag) values ("James", "Beam"       ,"M",  56,"");
insert into person (firstname, lastname,gender, age, active_flag) values ("Barney    ","Rubble"     ,"",  34,"N");
insert into person (firstname, lastname,gender, age, active_flag) values ("James", "Beam"       ,"",  "","");
insert into person (firstname, lastname,gender, age, active_flag) values ("  Betty", "Rubble"     ,"T",  "","");
insert into person (firstname, lastname,gender, age, active_flag) values ("  BamBam","Rubble"     ,"",  0,"");
insert into person (firstname, lastname,gender, age, active_flag) values ("James", "Beam"       ,"",  103,"");
insert into person (firstname, lastname,gender, age, active_flag) values ("Pebbles","Flintstone","F",  7,"");
insert into person (firstname, lastname,gender, age, active_flag) values ("Wilma",  "  Flintstone","F",  32,"");
insert into person (firstname, lastname,gender, age, active_flag) values ("Fred",   "Flintstone","M",  35,"");