Hello Experts, I am an Uni Student (Still learning SQL) and need your help to write a Pivot table sql script to help in my exam.
Company XYZ sells products. Company measures their performance by checking how long does it take to complete the entire order. Each order goes through multiple status (Example : Open, Pending, Close)
They count days for each status to know how many days an order was on a particular status. the days are calculated in two different ways, Working Days and Calendar Days
(Please refer to the below table)
How to turn this table into a pivot table shown in below picture? also how to add to additional columns which is total of each Working and business day status.
asked Nov 05, 2015 at 10:11 AM in Default
You could play arround with the following query. Dont have ddl statements, so trying on the fly with limited data:-
answered Nov 05, 2015 at 02:37 PM