SELECT AuthorFirst,AuthorLast FROM (book NATURAL join wrote NATURAL join inventory NATURAL join branch NATURAL join author)
where type = "MYS" and BranchName = "Henry Brentwood" 
GROUP BY AuthorFirst

/* Natural joining multiple tables to get all the data needed, then only selecting the ones of type MYS,
/* with the branchname being Henry Brentwood. selecting only the first and last name, and grouping by first name