people_db

from bash:

createdb presentation

psql presentation

in psql:

CREATE table people(id serial, last_name text, first_name text, age integer);

insert into people (last_name, first_name, age) values ('Howard','Emma',72),
('Quinn','Dominic',56),
('Churchill','Dan',42),
('Mathis','Liam',36),
('Dowd','Brandon',58),
('Welch','Gabrielle',52),
('Martin','Ian',68),
('Sutherland','Leah',82),
('Grant','Harry',38),
('Thomson','Nicholas',78),
('Murray','Faith',82),
('Clarkson','Max',57),
('Mackay','Caroline',22),
('Springer','Robert',56),
('Poole','Gavin',51),
('Bower','Phil',82),
('White','Rose',41),
('Knox','Evan',56),
('Pullman','Steven',50),
('Hudson','Neil',60),
('McDonald','Dylan',66),
('Cameron','Elizabeth',66),
('Peters','Benjamin',82),
('Anderson','Gordon',33),
('Lyman','Neil',19),
('Butler','Jason',54),
('Morrison','Bernadette',75),
('Ross','Isaac',27),
('Hardacre','Angela',82),
('MacDonald','Boris',19),
('Ince','Jacob',82),
('Welch','Victoria',68),
('Baker','Anna',27),
('Marshall','Robert',64),
('Greene','Hannah',23),
('Glover','Luke',16),
('Miller','Oliver',54),
('Hardacre','Natalie',54),
('Hunter','Amy',83),
('Ellison','Adam',56),
('Ince','Christopher',52),
('Paige','Sean',65),
('Hart','Leah',23),
('MacDonald','Trevor',33),
('Lambert','Gordon',38),
('Cameron','Abigail',21),
('Lyman','Austin',24),
('Payne','Kylie',39),
('Hudson','Adam',73),
('Jones','Jacob',26),
('Clarkson','Samantha',51),
('Henderson','Ava',16),
('Sutherland','Molly',76),
('Bailey','Blake',48),
('Davies','John',77),
('Cornish','Joseph',28),
('Ince','Penelope',63),
('Blake','Carolyn',41),
('Poole','Sophie',71),
('Mackenzie','Matt',27),
('Brown','Irene',38),
('Howard','Luke',49),
('Dyer','Maria',58),
('Berry','Ella',31),
('Welch','Jasmine',63),
('Scott','Boris',58),
('Springer','Keith',18),
('Vaughan','Charles',66),
('Ellison','Owen',20),
('Arnold','Elizabeth',51),
('Wilkins','Richard',69),
('Randall','Deirdre',39),
('Cameron','Ian',79),
('Coleman','Amanda',70),
('Vance','Joan',73),
('Grant','Anne',79),
('Peters','Tracey',55),
('Bower','Gavin',53),
('Black','Mary',58),
('Butler','Benjamin',22),
('Bell','Luke',26),
('Newman','Benjamin',23),
('Coleman','David',65),
('Mills','Adrian',26),
('Rees','Luke',33),
('Gill','Deirdre',47),
('Simpson','Neil',29),
('Brown','Mary',74),
('Lewis','Joanne',40),
('Allan','Diane',79),
('Hill','Christopher',50),
('McDonald','Charles',21),
('Wilkins','Nicholas',64),
('Jones','Sarah',74),
('Robertson','Tracey',30),
('Hamilton','Christian',37),
('King','Andrew',80),
('Bond','Bernadette',44),
('Johnston','Carolyn',78),
('Hardacre','Peter',85),
('Ball','Alan',24),
('Mitchell','Brandon',72),
('Lewis','Luke',40),
('Gibson','Lillian',72),
('Short','Theresa',52),
('Nolan','Natalie',33),
('Kerr','Dominic',41),
('Underwood','Sophie',52),
('Butler','Owen',34),
('Hudson','Emma',75),
('Young','Liam',73),
('Duncan','Audrey',39),
('Allan','Joshua',56),
('Black','Anna',34),
('Hardacre','Ryan',27),
('Cornish','Robert',82),
('Baker','Richard',27),
('Miller','Jennifer',85),
('Welch','Adam',84),
('Wright','Sam',35),
('Henderson','Grace',43),
('Bell','Simon',66),
('Wilson','Matt',23),
('Harris','Kimberly',63),
('Stewart','Luke',56),
('Watson','Una',27),
('Jackson','Felicity',38),
('Avery','Sophie',57),
('Vaughan','Penelope',39),
('Forsyth','Julian',16),
('Taylor','Sally',36),
('Wallace','Paul',26),
('Ball','Emily',68),
('White','Molly',62),
('Newman','Blake',43),
('White','Sebastian',70),
('Allan','Elizabeth',47),
('Skinner','Amanda',17),
('Miller','Brian',63),
('Mackay','Joe',56),
('Ball','Abigail',73),
('Howard','Amelia',65),
('Sharp','Gavin',59),
('Anderson','Mary',47),
('McLean','Leonard',46),
('Anderson','Dylan',70),
('Dyer','Pippa',32),
('Tucker','Madeleine',26),
('Randall','Leah',33),
('Peake','Vanessa',22),
('King','Blake',63),
('Metcalfe','Justin',45),
('Roberts','Max',38),
('Mackay','Madeleine',37),
('Alsop','Joan',78),
('Terry','Harry',83),
('Wright','Victor',83),
('Poole','Jessica',57),
('Sharp','Thomas',23),
('Paige','Adrian',43),
('Manning','Emma',45),
('Arnold','Gabrielle',51),
('Quinn','Joe',38),
('Nash','Piers',19),
('Ball','Samantha',63),
('Young','Joseph',33),
('Mills','Isaac',45),
('King','Alexander',25),
('Terry','Robert',59),
('Simpson','Dorothy',60),
('Gill','Maria',57),
('Churchill','Charles',71),
('Dowd','Theresa',46),
('Hart','Brandon',24),
('Edmunds','Lily',53),
('Poole','Olivia',17),
('Oliver','Edward',47),
('Coleman','Anthony',24),
('Berry','Benjamin',75),
('Vance','Rose',17),
('Campbell','Leah',44),
('Harris','Anthony',27),
('Marshall','Maria',67),
('Kerr','Owen',35),
('Short','Eric',77),
('Slater','Thomas',52),
('Nolan','Sally',32),
('Ferguson','Anna',36),
('MacDonald','Heather',71),
('Sharp','Elizabeth',56),
('Butler','Audrey',59),
('Cornish','Piers',69),
('Black','Donna',56),
('Nash','Wanda',50),
('Bond','Tim',73),
('Skinner','Jessica',80),
('Jackson','Julian',32),
('James','Jane',39),
('Welch','Nicola',50),
('Parr','Diana',46),
('Hamilton','Trevor',72),
('Short','Owen',48),
('Morgan','Jason',29),
('Harris','Keith',38),
('Underwood','Fiona',69),
('Young','Isaac',21),
('Sharp','Julian',62),
('Graham','Jessica',36),
('Campbell','Anne',71),
('Roberts','Robert',27),
('Walsh','Lily',50),
('Buckland','Kimberly',71),
('Mackay','Claire',62),
('Watson','Sarah',81),
('North','Katherine',20),
('Bower','Frank',20),
('Peters','Ella',53),
('Knox','Trevor',61),
('Blake','Sean',36),
('Turner','Owen',19),
('Knox','Wanda',58),
('Scott','Steven',16),
('Hudson','Julian',35),
('Murray','Jake',75),
('Walsh','David',74),
('Bell','Alison',72),
('Kelly','Amy',27),
('Sutherland','Jake',27),
('Cornish','Thomas',22),
('Alsop','Evan',83),
('Ferguson','Lucas',19),
('Springer','Ava',79),
('Hill','Alexander',66),
('Springer','Melanie',18),
('Kerr','Jonathan',72),
('May','Joshua',61),
('McDonald','Andrew',63),
('Avery','Carolyn',32),
('Bond','Nathan',54),
('Davidson','Sonia',58),
('Ogden','Adrian',64),
('Hardacre','Wanda',28),
('Randall','Olivia',23),
('Allan','Emily',44),
('MacDonald','Alexander',46),
('Edmunds','Una',81),
('Quinn','Samantha',47),
('Edmunds','Carol',44),
('Henderson','Angela',23),
('McGrath','Amanda',37),
('Piper','Chloe',34),
('Gray','Amelia',68),
('Manning','Simon',77),
('Henderson','Peter',27),
('Knox','Oliver',75),
('Hudson','Jasmine',49),
('Hardacre','Carl',42),
('Springer','Maria',43),
('Terry','Paul',68),
('Bailey','Joseph',41),
('Duncan','Dorothy',33),
('Avery','Ella',50),
('Kelly','Dan',16),
('Grant','Charles',49),
('Forsyth','Natalie',36),
('Blake','Lauren',75),
('MacLeod','Brandon',85),
('Scott','Grace',67),
('Rampling','Diane',66),
('Hamilton','Vanessa',78),
('Hodges','Stephen',78),
('Jackson','Liam',59),
('Clarkson','Ava',23),
('Glover','Carolyn',42),
('Berry','Jennifer',38),
('Rampling','Phil',18),
('Henderson','Lauren',30),
('Butler','Isaac',73),
('Stewart','Elizabeth',25),
('Ince','Bernadette',48),
('Tucker','Jacob',65),
('Carr','Zoe',33),
('Peake','Penelope',30),
('Wilson','Piers',18),
('Smith','Donna',64),
('Rampling','Dorothy',79),
('Allan','Neil',81),
('Powell','Virginia',58),
('Nash','Justin',49),
('Lee','Alexandra',77),
('Roberts','Ian',46),
('Clark','Victor',56),
('Churchill','Bella',82),
('James','Jake',42),
('Short','Joshua',44),
('Butler','Emma',70),
('Henderson','Alison',28),
('Randall','Gordon',73),
('Hodges','Neil',57),
('Welch','Samantha',27),
('Quinn','Dorothy',23),
('Peake','Madeleine',60),
('Rutherford','Stephanie',52),
('Bell','Ella',68),
('Carr','Lauren',83),
('Brown','Pippa',23),
('Slater','Justin',55),
('Davidson','Brian',41),
('Gray','Benjamin',49),
('Gibson','Gabrielle',29),
('Thomson','Emily',57),
('Black','Tim',70),
('Parsons','Bella',61),
('Dyer','Sue',65),
('Murray','Bernadette',54),
('Ince','Joshua',64),
('Blake','Joan',34),
('Ferguson','Isaac',72),
('Short','Harry',36),
('Burgess','Jasmine',17),
('Wilkins','Tracey',59),
('Watson','Trevor',82),
('Mills','Jason',51),
('Vance','Benjamin',65),
('Alsop','Liam',27),
('Morrison','Peter',54),
('Vaughan','Andrew',44),
('Arnold','Connor',85),
('Springer','Sam',67),
('Mackay','Sam',49),
('Peake','Claire',40),
('Harris','Lucas',78),
('Dowd','Mary',79),
('Robertson','Penelope',31),
('Quinn','Rachel',18),
('Smith','Anne',70),
('Peters','Gavin',25),
('Tucker','Michelle',64),
('Dickens','Sonia',39),
('Mackenzie','Joanne',35),
('Underwood','Carol',52),
('Mills','Rachel',40),
('White','Mary',20),
('Nash','Victor',55),
('Turner','Nicola',75),
('Bailey','Simon',48),
('Ogden','Grace',37),
('Allan','Michelle',60),
('White','Stephanie',75),
('Ball','Richard',30),
('Howard','Mary',42),
('Blake','Jessica',28),
('Ferguson','Frank',47),
('Clark','Ian',48),
('Butler','Ian',58),
('Brown','Nathan',40),
('Metcalfe','Tim',68),
('Sharp','Caroline',46),
('Mackay','Joseph',76),
('Graham','Anne',61),
('Rees','Joanne',66),
('Russell','Sean',58),
('Mackay','Paul',65),
('Nash','Dominic',47),
('Mackenzie','Abigail',57),
('Mitchell','Piers',21),
('Jackson','Steven',76),
('Underwood','Caroline',19),
('Mathis','Justin',17),
('Forsyth','Sean',36),
('Wilson','Hannah',71),
('Davies','Brandon',62),
('Simpson','Grace',25),
('Gibson','Joan',25),
('Sutherland','Thomas',64),
('Greene','Amelia',41),
('Davidson','Deirdre',35),
('Stewart','Thomas',76),
('Greene','Julian',57),
('Sanderson','Paul',67),
('Baker','Adam',35),
('Lee','Ryan',65),
('Allan','Rebecca',31),
('Young','Oliver',32),
('Mackay','Liam',45),
('Lawrence','Alan',17),
('Harris','Chloe',37),
('Henderson','Victor',40),
('Nash','Adam',44),
('Campbell','Lily',80),
('Rampling','Ava',52),
('Brown','Diana',36),
('Young','Melanie',30),
('Underwood','Brandon',57),
('Langdon','Lucas',79),
('Buckland','Jacob',56),
('Lewis','Blake',67),
('Turner','Dorothy',59),
('Hodges','Nathan',73),
('Walker','Connor',69);