SQLite

CREATE TABLE cats (
    id     INTEGER     PRIMARY KEY AUTOINCREMENT,
    name   VARCHAR(10) NOT NULL,
    colour VARCHAR(10) NOT NULL,
    legs   INTEGER     DEFAULT(4),
    added  TIMESTAMP   DEFAULT(CURRENT_TIMESTAMP)
);

INSERT INTO cats
    (name, colour)
VALUES
    ("Jane", "Black"),
    ("Mike", "Ginger"),
    ("Dave", "Tabby"),
    ("Gary", "Ginger"),
    ("Thom", "White");

INSERT INTO cats
    (name, colour, legs)
VALUES
    ("Fred", "Tabby", 3);

SELECT * FROM cats;

SELECT id, name, legs
FROM cats
ORDER BY name ASC

SELECT id, name
FROM cats
WHERE legs < 4

TESTS

CREATE TABLE cats (
    id     INTEGER     PRIMARY KEY AUTOINCREMENT,
    name   VARCHAR(10) NOT NULL,
    colour VARCHAR(10) NOT NULL,
    legs   INTEGER     DEFAULT(4),
    added  TIMESTAMP   DEFAULT(CURRENT_TIMESTAMP)
);

INSERT INTO cats
    (name, colour)
VALUES
    ('Jane', 'Black'),
    ('Mike', 'Ginger'),
    ('Dave', 'Tabby'),
    ('Gary', 'Ginger'),
    ('Thom', 'White');

INSERT INTO cats
    (name, colour, legs)
VALUES
    ('Fred', 'Tabby', 3);

SELECT * FROM cats;

Then...

CREATE TABLE cats (
    id     INTEGER     PRIMARY KEY AUTOINCREMENT,
    name   VARCHAR(10) NOT NULL,
    colour VARCHAR(10) NOT NULL,
    legs   INTEGER     DEFAULT(4),
    added  TIMESTAMP   DEFAULT(CURRENT_TIMESTAMP)
);

INSERT INTO cats
    (name, colour)
VALUES
    ('Jane', 'Black'),
    ('Mike', 'Ginger'),
    ('Dave', 'Tabby'),
    ('Gary', 'Ginger'),
    ('Thom', 'White');

INSERT INTO cats
    (name, colour, legs)
VALUES
    ('Fred', 'Tabby', 3);

SELECT * FROM cats;