Database schema is Northwind on MySQL workbench Query 3: Scale…

Question Answered step-by-step Database schema is Northwind on MySQL workbench Query 3: Scale… Database schema is Northwind on MySQL workbench  Query 3:Scale issue: Recently, there have been multiple detections of 500-gram products reporting in underweight. Due to the complex packaging system, it’s hard to tell where the misreading is coming from. Develop a query that will show the production floor managers a list of 500-gram products and any relevant data to help narrow down where the issue might be coming from. (Tip: The LIKE statement might be useful)Show the Product Name, QuantityPerUnit, and any other field you deem important.SELECT *FROM Product; answer should look like this  Query 4)How many customers does Northwinds have in each Country?Show the Country and number of customers, pick an appropriate alias name.Sort by the country with the most customers firstLabel the query as Query 4Select *From Customer, answer should look like this  Query 5) This last query expands on the previous lessons query you did to find the profit of each product. This time a request needs to know the average profit for each category but only if the average is greater than $10.00Round the average profit to two decimalsLabel the query as Query 5I’m not sure how to do 5 at all or where to take it from. But here is how it’s supposed to look.Select *From Category  Computer Science Engineering & Technology MYSQL BUS 782 Share QuestionEmailCopy link Comments (0)