Question: You are given a table, Tasks, containing three columns: Task Id. Start Date and End Date. Each task requires only 1 day in order to

 You are given a table, Tasks, containing three columns: Task Id.

You are given a table, Tasks, containing three columns: Task Id. Start Date and End Date. Each task requires only 1 day in order to complete. That is, the difference between the End Date and the Start Date is equal to 1 day for each row in the table. If the Start Date of the tasks are consecutive, then they are put of the same project. The projects table. PROJECTS, was accidentally deleted. Write a query to product a summary table of the projects undertaken. The summary table should include the start and end dates of projects listed by the number of days it took to complete the project in ascending order. If there is more than one project that have the same number of completion days, then output is ordered by the start date of the project

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!