select brands.brand_id, brands.brand, flavors.flavor_id, flavors.flavor, flavors.avg_rating, count( reviews.review_id ) as 'numReviews' from brands, flavors, reviews where brands.brand_id = flavors.brand_id and avg_rating != "" and reviews.flavor_id = flavors.flavor_id group by flavors.flavor_id having numReviews >= #int(minReviews)# order by flavors.avg_rating desc, brands.brand asc, flavors.flavor asc

Energy Drink Rankings Minimum number of reviews: selected>1 selected>2 selected>3 selected>4 selected>5
#	Brand	Flavor	Reviews	Rating
#currentRow#	#brand#	#flavor#	(#numReviews#)	#getStars( avg_rating )#