Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

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...

3. Create a query using the F_Staffs table to display the Staff_Type in capital letters with the column name "SType", Create a new column with the name "SType" by combining of the column First_Name...

1. Create a query using the Departments and Job_History tables to display manager_id and the startdate in the form of "TWENTY-FOURTH of Mar, 1998, TUE with the column name Born Date and by extracting...

PYTHON, question. You are a volunteer worker for a not-for-profit organization called Southeast Helping Hands (SHH). SHH serves as a central clearinghouse for temporary shelter information and...

Please find the solution: Section A: Query Design [50 Marks] 1. Create a query using the Job_History and Departments tables to display the start_date in the form of September, Nineteen Eighty-Nine,...

1. Create a query using the F_Staffs and Locations tables to display state_province and the birthdate in the form of Mon NINETEENTH of March, 1979 with the column name BirthDate and by substituting...

Case Problem 1 Data File needed for this Case Problem: Schoolaccdb Great Giraffe Jeremiah Garver is the operations manager at Great Giraffe, a career school in Denver, Colorado. Great Giraffe offers...

Your boss asks to see an overview of the total sales for the year grouped by store and categd 8. Save the workbook Yearly and Quarterly Totals under the name Overview. 9. Edit the query and rename it...

just needed these questions done pls LE_CAP_HW_Instruction Protected ViewSaved to this PC- Stock cel Prview View Help Unless you need to do it's safe to stay in Protected View Enable Editing...

What is the relationship between fair value and deprival value?

Constructing a distribution of demand during reorder lead time is complicated if the lead time itself is variable. Consider the following distribution for a reorder point inventory system. a. What is...

In 2 0 1 0 , Duncan purchased 2 , 0 0 0 shares of stock for $ 5 0 , 0 0 0 in a midsize local company with gross assets of $ 1 5 , 0 0 0 , 0 0 0 . In 2 0 2 4 , Duncan sold the stock for $ 8 0 , 0 0 0...

Calculate the minimum and maximum takt time for the given

What advice would you provide to Jennifer?

What are the risk management exposures revealed in the case? And, how might these be addressed?

What are the issues of concern for each of the affected parties?