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"))