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. 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
Get step-by-step solutions from verified subject matter experts
