Which option is true about the SQL query given below?SELECT firstName, lastName FROM Employee WHERE lastName BETWEEN 'A%' AND 'D%';

• A. It will display all the employees having last names starting with the alphabets 'A' till 'D' inclusive of A and exclusive of D.
• B. It will throw an error as BETWEEN can only be used for Numbers and not strings.
• C. It will display all the employees having last names starting from 'A' and ending with 'D'.
• D. It will display all the employees having last names in the range of starting alphabets as 'A' and 'D' excluding the names starting with 'A' and 'D'.