sql function related question! Hi, I need to create a function that accepts officer_id and returns the keyword Active or Inactive. If officer_id exists in the system it finds the status of either A or I. (nested if) if the officer is active(a) then based on the last digit of badge number, if last digit is between 0-5 it returns 'ACTIVE ON DESK'. else if the last digit of badge number is greater than 5, it returns 'ACTIVE ON DUTY' If officer is inactive(I ), it returns Inactive. If officer_id does not exist, it returns 'not existing officer' Please help me with this!

sql function related question! Hi, I need to create a function that accepts officer_id and returns the keyword Active or Inactive. If officer_id exists in the system it finds the status of either A or I. (nested if) if the officer is active(a) then based on the last digit of badge number, if last digit is between 0-5 it returns 'ACTIVE ON DESK'. else if the last digit of badge number is greater than 5, it returns 'ACTIVE ON DUTY' If officer is inactive(I ), it returns Inactive. If officer_id does not exist, it returns 'not existing officer' Please help me with this!

Related questions

Q: Question 4 of 9 Which keyword is before the function's variable declarations? O RETURN O DEFINE O…

A: Variables. A variable is a named storage location in a computer's memory that stores a value, such…

Q: def find_bridges_in_radius(bridges: List[list], lat: float, lon: float, radius: int, exclusions:…

A: Solved one part of the questing asking to find_bridges_in_radius def…

Q: Remember that, as stated in the Code Style Guidelines, all functions in all assignments must have a…

A: I have given an answer in step 2.

Q: It would be helpful if you could document all the cases when the intended result will be the…

A: Inline functions are functions that are expanded in place at the point of call, rather than being…

Q: Give an example of how calling an inline function is different from calling a normal function in the…

A: Hello student Greetings In programming, inline functions and normal functions serve…

Q: how to make and use friend functions, as well as when it makes sense to do so.

A: Friend Function: It is a class which is allowed to access private and confidentiality members of…

Q: The Challenge: You must build a pointer to a function that accepts an integer input and returns an…

A: Algorithm: Define a function make_array_of_function_pointers that takes an integer n as input and…

Q: If we had 100 parts, coding them would be very inefficient. Write a function called PrintInv() that…

A: Please find the answer below :

Q: List all cases when inline functions have the opposite effect.

A: The inline keyword does not issue a command but rather only a request to the compiler. The compiler…

Q: Write a main function that must call your other functions so that your program runs all required…

A: Given requirement, Write a main function that must call your other functions so that your program…

Q: 2. Write a function void decrement (int* a) to decrease the value of the argument in the main…

A: As per our guidelines we are allowed to answer 1 question at a time. If you want a answer of some…

Q: Using Clojure Write a procedure, called compose, that takes two one-place functions f and g as…

A: public class Compose { // Java doesn't have function type so we define an interface // of…

Q: Finish the function definition for interpret(), that interprets the number of profile views on a…

A: Here, we need to call interpret function with linkedin vector and facebook vector. This can be done…

Q: There are a lot of benefits that come with using pure functions.

A: The advantages of pure functions: The absence of side effects from pure works is a crucial…

Q: Please write a stored function named which will take two inputs (type, keyword). The keyword is a…

A: In addressing this task, we are tasked with the development of a stored function tailored to search…

Question

sql function related question!

Hi, I need to create a function that accepts officer_id and returns the keyword Active or Inactive.

If officer_id exists in the system it finds the status of either A or I.
(nested if) if the officer is active(a) then based on the last digit of badge number, if last digit is between 0-5 it returns 'ACTIVE ON DESK'. else if the last digit of badge number is greater than 5, it returns 'ACTIVE ON DUTY'

If officer is inactive(I ), it returns Inactive.

If officer_id does not exist, it returns 'not existing officer'
Please help me with this!

OFFICER_ID LAST
111112 Shocks
111113 Busey
111114 Gants
111115 Hart
111116 Sands
FIRST
Pam
Gerry
Dale
Leigh
Ben
PREC BADGE
OCVW E5546A33
GHNT E5577D48
SBCH E5536N02
WAVE E5511J40
OCVW E5588R00
PHONE
S
SI
7574446767 A
7574446767 A
7574446767 A
7574446767 A
7574446767 I

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

Step 2: SQL function

Step 3: Screenshot

Solution

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Hi thank you for the explanation!

BTW, can you use oracle sql structure? Not MySQL.
It's a bit hard to understand

Solution

by Bartleby Expert

SEE SOLUTION

Similar questions

Question 8 Study the following definition of function "Secret" and answer the question below. int Secret (int numl, int num2) if (numl > 0) for (int i = 1; i 0) for (int i - 0; i <= num2; i++) numl numl +i; return num1; return C; What is the output of the following code segment? cout<
What do you understand by local and global scope of variables? How can you access a global variable inside the function, if function has a variable with same name.
Is there a limit to the number of ways functions may interact with one another?Using relevant examples, explain what you're saying.
There are a lot of benefits that come with using pure functions.
Please execute the following statements. Write down the return value for each statement and explain what each of the functions cons, append, and list ; Scheme interprets everything to the right of a semicolon (;) as a comment. You should always start your file with comment lines that include your name, W#, and assignment title (cons 3 '(1 2)) (cons '(1 5) '(2 3)) (list 3 '(1 2)) (list '(1 5) '(2 3)) (append '(1) '(2 3)) (append '(1 5) '(2 3)) (cons 'x '(1 2)) (list 1 2 3 '(4 5)) (cons '1 '2 '3 '(4 5))
4. Which function calls would provide the most helpful test of this function? Remember: With tests, you are attempting to figure out all the possible ways the function could be broken. function findMin(num1, num2){ if(num1 < num2){ return num1; } else { return num2; } } function findMin (num1 num2 if( numl < num2 ) return numl } else ( return num2 O A. findMin(-1, 0) findMin(2,4) findMin(5,10) Ов. findMin(5,3) findMin(7,2) findMin(5,1) O C. findMin(1,1) findMin(-2,2) findMin(0,3) O D. findMin(-1,1) findMin(1,-1) findMin(1,1)
Refactor the following code using the concept of functions. a = 2 b = 3 C= 4 d = 5 a = 2 b = 3 C= 4 d = 5
Describe all the cases when using inline functions won't provide the expected results.
Write the function data_tuple_from_line(line_str) that takes a line of input (with value separated by commas) and returns a tuple containing install_id, install_date, size, cost, subsidy, zip code, city, state. In the result tuple: The install_id, install_date, zip code, city, and state should all be strings. The size, cost, and subsidy should all be floats. The city should be in title case.
in the C++ version please suppose to have a score corresponding with probabilities at the end and do not use the count[] function. Please explain the detail when coding. DO NOT USE ARRAY. The game of Pig The game of Pig is a dice game with simple rules: Two players race to reach 100 points. Each turn, a player repeatedly rolls a die until either a 1 ("pig") is rolled or the player holds and scores the sum of the rolls (i.e. the turn total). At any time during a player's turn, the player is faced with two decisions: roll - if the player rolls 1: the player scores nothing and it becomes the opponents turn. 2 - 6: the number is added to the player's turn total and the player's turn continues. hold - The turn total is added to the player's score and it becomes the opponent's turn. This game is a game of probability. Players can use their knowledge of probabilities to make an educated game decision. Assignment specifications Hold-at-20 means that the player will choose to roll…
In this article, we'll talk about how to make and use friend functions, as well as when it makes sense to do so.One way to learn, for example, is to do things.
In this article, we'll talk about how to make and use friend functions, as well as when it's appropriate to do so.For example, one way to learn is by doing.