Below are the queries that were done in the data warehouse meetings.
October meeting
Query for October meetingΜύ°Ϊ.±θ»ε΄Ϊ±Υ
Query for October meeting Toad [.pdf]
Query for October meeting using Crystal [.pdf]
November meeting
Query for November meeting [.pdf]
Query for November meeting using Toad [.pdf]
Query for November meeting using Crystal [.pdf]
Creating a PivotTAbleΜύ°Ϊ.±θ»ε΄Ϊ±Υ