>> sqlite3 advanced.db SQLite version 3.3.13 Enter ".help" for instructions sqlite> create table addresses ...> (lastname varchar(20), firstname varchar(16), address varchar(30), email varchar(30), phone number(10), status varchar(10)); sqlite> insert into addresses ...> values ('Lee', 'Raymond', '1029 Washington Blvd', 'rayisthechosenone@gmail.com', 7035241067, 'friend'); sqlite> insert into addresses ...> values ('Jobs', 'Steven', '1 Infinite Loop', 'sjobs@apple.com', 2108338640', 'work'); sqlite> insert into addresses ...> values ('Wales', 'Jimbo', '121 Wikiland', 'jimmy@wikipedia.org', 1920129320, 'friend'); sqlite> select max(phone), status ...> from addresses ...> group by status; 7035241067|friend sqlite> select min(phone), status ...> from addresses ...> group by status; 1920129320|friend sqlite> select status, min(lastname) ...> from addresses ...> group by lastname; friend|Lee friend|Wales sqlite>