-- create a table
CREATE TABLE Pets
(
Name  Varchar(15) NOT NULL,
Owner  Varchar(25) NOT NULL,
Species  Varchar(10) NOT NULL,
Sex  Char(1) NOT NULL,
Birth  Date  NOT NULL,
Death  Date
);
-- insert some values
INSERT INTO Pets (Name, Owner, Species, Sex, Birth, Death) 
VALUES ("Tommy", "Harish", "DOG", "M", "11-02-2017", NULL);
INSERT INTO Pets (Name, Owner, Species, Sex, Birth, Death)
VALUES ("BULL", "SAM", "DOG", "M", "12-10-2009", NULL);
INSERT INTO Pets (Name, Owner, Species, Sex, Birth, Death)
VALUES ("Slim", "RAM", "Bird", "F", "12-01-2017", NULL);
INSERT INTO Pets (Name, Owner, Species, Sex, Birth, Death)
VALUES ("SPUW", "Arvind", "CAT", "M", "1-10-2019", NULL);
INSERT INTO Pets (Name, Owner, Species, Sex, Birth, Death)
VALUES ("Kelly", "Danush", "CAT", "F", "12-08-2018", NULL);
INSERT INTO Pets (Name, Owner, Species, Sex, Birth, Death)
VALUES ("Monty", "Anik", "DOG", "M", "02-09-2010", "13-09-2017");
INSERT INTO Pets (Name, Owner, Species, Sex, Birth, Death)
VALUES ("BUnti", "Manoj", "Bird", "F", "22-10-2019", NULL);
-- fetch some values
SELECT * FROM Pets;
SELECT Name,Owner FROM Pets;
SELECT Species,Name FROM Pets;
SELECT distinct Species FROM Pets;