I have something I can't figure out. I had a lab that was due on Sunday and they were several I couldn't figure out. here is one. Code (SQL): SELECT oi.orderid, b.retail FROM Order_items oi INNER JOIN books b ON oi.bookid = b.bookid GROUP BY oi.bookid HAVING SUM(retail) = ( SELECT MAX(SUM(retail)) FROM books GROUP BY bookid ); that was my starting point,but I had no luck. We were suppose to nest the function.