Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Figure 1 . FAA Birdstrike Data ERD A real estate company has customers fill out a registration & interests form to provide the real estate
Figure 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 # 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 PPropertyIDVPropertyID
INNER JOIN Customers C ON VCustIDCCustID
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 PPropertyIDVPropertyID
GROUP BY Neighborhood
ORDER BY Count DESC
d SELECT Neighborhood, Count
FROM CustomerInterests
WHERE Visits
GROUP BY Neighborhood
ORDER BY Count
e None of the above
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started