We need a person who understands sql 2008 to help us with a project.
Please answer this test to show your sql knowledge. the first person to answer will be chosen and given the rest of the details
TEST
We have two tables
Table1: Property
Columns: ID, Bedroom, Bathroom, Date1, Date2
Table2: Image
Columns: ID, Property_ID, Image Path
Note that for each property, there is 1-10 different Images
Here's the test
We need a VIEW that selects all properties but only the first image so the return should be all properties with only the top image for each.
Also in the view for each row (property), there should be a calculated column that calculates the difference between Date2-Date1
So the final result of view will have the same number of rows as the property table