Heres d Question: Provide a SQL statement to create a view in Microsoft SQL Server that will return only 1 record displaying the contents of the MEETING_NUMBER field. The rules for the view are as follows: â€¢ The START_DATE field which contains the start date of the meeting record must contain a value before the current system date. â€¢The START_DATE field must be the closest date to the current system date. Here is my attempt: CREATE VIEW Meeting_View AS SELECT Meeting.MEETING_NUMBER FROM Meeting m1 WHERE START_DATE < GETDATE() AND EXISTS (SELECT MAX(START_DATE) FROM Meeting m2 WHERE m1.MEETING_NUMBER = m2.MEETING_NUMBER) Can anyone tell me where im goin wrong???