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

media pointerfileservicefile7mu3p6kKLoAUmzhqoWvsiG Question ... View full answer

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

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

How would you go about attempting to come up with the probability of a super- event or the probability of a unique- event? What factors would you consider?

Sherman Company reported the following financial statements for 2013 and 2014: Compute the following investing cash flows: a. Purchases of plant assets (all were for cash). There were no sales of...

Investor X is investing $100 in a savings account today. Which one of the following terms refers to the total value of this investment one year from now? Multiple Choice Future value Present value...

Scenario: A Multi-national Corporation called The Globe has created a subsidiary called Thirst in an under-developed country called non-potable waters. This hosting country suffers from a severe...

Cognitive ability tests seem to be the most valid selection devices available for hiring employees, yet they also have adverse impact against blacks and Hispanics. Given the validity and adverse...

Health and safety legislation shows no sign of abating. Debate whether you consider that excessive legislation merely creates confusion and bureaucracy and makes it more diffi cult for businesses to...

In focus on research 11.4, what evidence is there for the convergence of Western and Japanese cultures? Discuss what implications any convergence may have for other HRM practices in Japan.