A large spreadsheet contains the following information about local restaurants. A sample portion of the spreadsheet is shown below.



A

Restaurant Name B

Price Range C

Number of

Customer Ratings D

Average

Customer Rating E

Accepts

Credit Cards

1 Joey Calzone’s Pizzeria lo 182 3.5 false

2 78th Street Bistro med 41 4.5 false

3 Seaside Taqueria med 214 4.5 true

4 Delicious Sub Shop II lo 202 4.0 false

5 Rustic Farm Tavern hi 116 4.5 true

6 ABC Downtown Diner med 0 -1.0 true

In column B, the price range represents the typical cost of a meal, where "lo" indicates under $10, "med" indicates $11 to $30, and "hi" indicates over $30.

In column D, the average customer rating is set to -1.0 for restaurants that have no customer ratings.

Question

A student wants to count the number of restaurants in the spreadsheet whose price range is $30 or less and whose average customer rating is at least 4.0. For a given row in the spreadsheet, suppose prcRange contains the price range as a string and avgRating contains the average customer rating as a decimal number.



Which of the following expressions will evaluate to true if the restaurant should be counted and evaluates to false otherwise?



Responses



(avgRating ≥ 4.0) AND ((prcRange = "lo") AND (prcRange = "med"))



(avgRating ≥ 4.0) AND ((prcRange = "lo") AND (prcRange = "med"))



(avgRating ≥ 4.0) AND ((prcRange = "lo") OR (prcRange = "med"))



(avgRating ≥ 4.0) AND ((prcRange = "lo") OR (prcRange = "med"))



(avgRating ≥ 4.0) OR ((prcRange = "lo") AND (prcRange = "med"))



(avgRating ≥ 4.0) OR ((prcRange = "lo") AND (prcRange = "med"))



(avgRating ≥ 4.0) OR ((prcRange = "lo") OR (prcRange = "med"))