Plz this is the question what is missing

3. Create a query using the D_Events table to display the Description in capital letters with the column name "Remarks", Create a new column with the name "NewEvent" by combining of the column Name by replacing letter 'e' with '#' and 4 characters of Description from 3rd position, Size of Name with the column name "NMLength". Restrict the output to whose Venue_id is more than 100 and size of the Name is more than 8. [6 Marks]