<code>number Created_Date Closed_Date Close_Notes
T1 8/10/2024 null null
T1 8/10/2024 8/11/2024 Completed Successfully
T2 8/11/2024 null null
T2 8/11/2024 8/13/2024 null
T2 8/11/2024 8/13/2024 Completed Successfully
</code>
<code>number Created_Date Closed_Date Close_Notes
T1 8/10/2024 null null
T1 8/10/2024 8/11/2024 Completed Successfully
T2 8/11/2024 null null
T2 8/11/2024 8/13/2024 null
T2 8/11/2024 8/13/2024 Completed Successfully
</code>
number Created_Date Closed_Date Close_Notes
T1 8/10/2024 null null
T1 8/10/2024 8/11/2024 Completed Successfully
T2 8/11/2024 null null
T2 8/11/2024 8/13/2024 null
T2 8/11/2024 8/13/2024 Completed Successfully
It is time series data. We need output as below,
<code>Expected output:
number Created_Date Closed_Date Close_Notes
T1 8/10/2024 8/11/2024 Completed Successfully
T2 8/11/2024 8/13/2024 Completed Successfully
</code>
<code>Expected output:
number Created_Date Closed_Date Close_Notes
T1 8/10/2024 8/11/2024 Completed Successfully
T2 8/11/2024 8/13/2024 Completed Successfully
</code>
Expected output:
number Created_Date Closed_Date Close_Notes
T1 8/10/2024 8/11/2024 Completed Successfully
T2 8/11/2024 8/13/2024 Completed Successfully
Query i tried,
<code>SELECT
Number,
Close_Notes,
min(Created_Date),
max(Closed_Date)
FROM
SN_Change_Request group by Number
</code>
<code>SELECT
Number,
Close_Notes,
min(Created_Date),
max(Closed_Date)
FROM
SN_Change_Request group by Number
</code>
SELECT
Number,
Close_Notes,
min(Created_Date),
max(Closed_Date)
FROM
SN_Change_Request group by Number
7