State the product name, product line, rating and the selling price of product with the lowest rating.
Product with the lowest rating refers to the rating
given by the
reviewer where Rating = 1
SELECT T1.Name, T1.ProductLine, T2.Rating, T1.ListPrice FROM Product AS T1 INNER JOIN ProductReview AS T2 ON T1.ProductID = T2.ProductID ORDER BY T2.Rating ASC LIMIT 1