CREATE TABLE persons $($

id INTEGER PRIMARY KEY AUTOINCREMENT,

fullname TEXT,

age INTEGER$)$;

INSERT INTO persons $($fullname$,$ age$)$ VALUES $("$Bobby McBobbyFace", $"12")$;

INSERT INTO persons $($fullname$,$ age$)$ VALUES $("$Lucy BoBucie", $"25")$;

INSERT INTO persons $($fullname$,$ age$)$ VALUES $("$Banana FoFanna", $"14")$;

INSERT INTO persons $($fullname$,$ age$)$ VALUES $("$Shish Kabob", $"20")$;

INSERT INTO persons $($fullname$,$ age$)$ VALUES $("$Fluffy Sparkles", $"8")$;

CREATE table hobbies $($

id INTEGER PRIMARY KEY AUTOINCREMENT,

person$\_$id INTEGER,

name TEXT$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(1,$ "drawing"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(1,$ "coding"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(2,$ "dancing"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(2,$ "coding"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(3,$ "skating"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(3,$ "rowing"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(3,$ "drawing"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(4,$ "coding"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(4,$ "dilly$-$dallying"$)$;

INSERT INTO hobbies $($person$\_$id$,$ name$)$ VALUES $(4,$ "meowing"$)$;

CREATE table friends $($

id INTEGER PRIMARY KEY AUTOINCREMENT,

person$1\_$id INTEGER,

person$2\_$id INTEGER$)$;

INSERT INTO friends $($person$1\_$id$,$ person$2\_$id$)$

VALUES $(1,4)$;

INSERT INTO friends $($ person$1\_$id$,$ person$2\_$id$)$

VALUES $(2,3)$; Now, use another SELECT with a JOIN to show the names of each pair of friends, based on the data in the friends table.