Advanced SQL Query

已取消 已发布的 Apr 18, 2010 货到付款
已取消 货到付款

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

MySQL SQL

项目ID: #664179

关于项目

1个方案 远程项目 活跃的Apr 18, 2010