Advanced SQL Query

In Progress Posted Apr 18, 2010 Paid on delivery
In Progress Paid on delivery

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

.NET MySQL SQL

Project ID: #664205

About the project

2 proposals Remote project Active Apr 18, 2010

2 freelancers are bidding on average $30 for this job

ruimaxwell

Hi, Please check PM. Thanks

$30 USD in 1 day
(31 Reviews)
5.4
sukung34

my answer in PM.

$30 USD in 1 day
(3 Reviews)
1.8