Question

2. Define queries in SQL to obtain the following information: (a) The names of all products manufactured by 'Samsung', in ascending ordered by price. (b) The names of all products

that had at least one rating of 3 or more stars. No duplicate names should be returned. (c) For all products, their name, average star rating, and most recentrating date. The results should be in descending order of averagestar rating. (d) For all cases in which the same customer rated the same productmore than once, and in some point in time gave it a lower rating2

Fig: 1

Fig: 2

Fig: 3

Fig: 4

Fig: 5