Advanced SQL Query

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