Figure $1.$ FAA Birdstrike Data ERD

A real estate company has customers fill out a "registration & interests" form to provide the real estate agent with

contact data plus information on the types of homes the customer may be interested in$.$ A customer may be interested

in multiple neighborhoods. The real estate company has different agents. Each customer is assigned an agent in the

company. The company has a collection of currently available $($for sale$)$ properties and keeps track of any property

visited by a customer as well as the visit outcome $($not interested, interested, offer made, offer not accepted, offer

accepted, under contract, closed$).$ Based on Figure #$1,$ which of the following SQL SELECT queries will provide a list of neighborhoods and the number of visits to them by customers, sorted in decreasing order of number of visits? $($choose one$)$

a$.$ SELECT Neighborhood, Visits

FROM $($Property P INNER JOIN Visits V ON P$.$PropertyID$=$V$.$PropertyID$)$

INNER JOIN Customers C ON V$.$CustID$=$C$.$CustID

ORDER BY Count$(*)$ DESC

b$.$ SELECT Neighborhood, NumberVisits

FROM Property

SORT BY NumberVisits DECREASING

c$.$ SELECT Neighborhood, Count$(*)$ as NumVisits

FROM Property P INNER JOIN Visits V ON P$.$PropertyID$=$V$.$PropertyID

GROUP BY Neighborhood

ORDER BY Count$(*)$ DESC

d$.$ SELECT Neighborhood, Count$(*)$

FROM Customer$\_$Interests

WHERE Visits $>0$

GROUP BY Neighborhood

ORDER BY Count$(*)$

e$.$ None of the above