Suppose two queries are available as follows: 1. foodCategory contains FoodID, FoodName, Cost, SalePrice, and foodCategory 2. salesAndCostsByFoodID contains FoodID, SumOfCost, and SumOfSalePrice To determine gross margins, how should the queries be joined?

Question options:

	join (inner) foodCategory and salesAndCostsByFoodID on FoodID
	join (left outer) foodCategory and salesAndCostsByFoodID on FoodID
	join (right outer) foodCategory and salesAndCostsByFoodID on FoodID
	join (Cartesian product) foodCategory and salesAndCostsByFoodID

If EatFresh wanted to increases its gross margin on sales, it could sell more:

Question options:

	appetizers
	side dishes
	meat and seafood
	desserts

In addition to FoodWaste, the tables needed to determine waste with its description by food category by store by week are:

Question options:

	FoodItem, WasteCode
	ConversionCost, WasteCode,
	ConversionCost, FoodItem
	ConversionCost, FoodItem, WasteCode

Your assistant said the following: I can get the gross margins by food category, but when I try to compute the overall margin, I get syntax errors. You tell your assistant to:

Question options:

	remove some attributes from a query
	include more attributes in a query
	add criteria to some of the attributes
	remove criteria from some attributes