SQL:

Here I have what I am having to write in SQL to get the results are shown.

This is what I have. But it wont give me any results. I have determined that it might be something wrong with my WHERE query statement. Please HELP.

MY QUERY:

SELECT courseid, sectionid, To_Char(sectionstartdate, 'YYYY-MM-DD HH:MI AM') AS sectionstarttime, professorid, capacity FROM sections WHERE To_Char(sectionstartdate, 'YYYY-MM-DD HH:MI AM') = '2019-09-11' ORDER BY sectionstartdate DESC, courseid;

3. List the course ID, section ID, section start date as shown, professor ID and capacity for all sections with a section start date of Sept 11 2019. Arrange the list by start date in reverse order then course ID. Format date and time as shown