In my illustration you'll see I have a table and the expect query results. In order to accomplish this in not one query, as opposed to writing two or three queries to get the expect result, I expect I probably need to utilize the MIN and MAX functions and write a sub query in the select statement...