Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a new function called vowel_cnt which will take multiple NAME values as input and count the number of vowels (only count A, a,

 

Create a new function called vowel_cnt which will take multiple NAME values as input and count the number of vowels (only count "A", "a", "E", "e", "1", "1", "O", "o", "U", "u"). This is a multi-row function. The function needs to be called on the NAME column or JOB column - for instance: SELECT vowel_cnt(NAME) from STAFF-or- SELECT vowel_cnt(JOB) from STAFF. WHAT TO HAND IN: A copy of your function code-and-output showing a couple of examples of the function working on each of the columns. Make sure to test when there are no rows in the result set - you can use the WHERE clause for this.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

heres an example of how you could create the vowelcnt function in SQL ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Regression Analysis And Other Multivariable Methods

Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg

5th Edition

1285051084, 978-1285963754, 128596375X, 978-1285051086

More Books

Students also viewed these Databases questions