Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started