Total number of requests per day of the week
I'm trying to determine if I can calculate the total number of trouble tickets that occur for each day of the week and for the entire year. I'm not sure how to write this query or if it can be done. I'm on 8.1.6 and running Windows 2000. Please excuse my lack of knowledge because I'm very new to Oracle and PL/SQL. The column I need totals from is named open_dt(date data type 1/18/2000 1:16:00 PM). What I'd like to determine is the busiest day of the week for trouble ticket creation throughout the entire year. This will allow us to get a better idea of staffing needs. Thanks for your help.