A question about databases

[FlatAssembler]

In 2018, on a test about databases (which I have failed multiple times) at my university, they had this task:

Napisati T-SQL funkciju koja prima 3 realna broja, te kao rezultat vraća onaj broj koji ima najveću apsolutnu vrijednost. Ako slučajno istu najveću apsolutnu vrijednost imaju dva ili tri broja potrebno je vratiti zbroj tih brojeva.

That is:

Write a T-SQL function that accepts 3 real numbers, and as a result it returns the number that has the biggest absolute value. If accidentally the same biggest absolute value is had by two or three numbers it is necessary to return the sum of those numbers.

How would you solve that?
Here is my attempt, I do not know if it is correct nor how to actually test it on my computer:

Code:

CREATE FUNCTION max_abs3(@x, @y, @z DECIMAL) RETURNS DECIMAL
BEGIN
    IF ABS(@x)=ABS(@y) AND ABS(@y)=ABS(@z)
    BEGIN
        RETURN @x+@y+@z;
    END;
    IF ABS(@x)=ABS(@y) AND ABS(@x)>ABS(@z)
    BEGIN
        RETURN @x+@y;
    END;
    IF ABS(@x)=ABS(@z) AND ABS(@x)>ABS(@y)
    BEGIN
        RETURN @x+@z;
    END;
    IF ABS(@y)=ABS(@z) AND ABS(@y)>ABS(@x)
    BEGIN
        RETURN @y+@z;
    END;
    IF ABS(@x)>ABS(@y) AND ABS(@x)>ABS(@z)
    BEGIN
        RETURN @x;
    END;
    IF ABS(@y)>ABS(@z) AND ABS(@y)>ABS(@x)
        RETURN @y;
    END;
    RETURN @z;
END;

I have only managed to install SQLite on my computer, and it apparently does not support custom SQL functions.

[FlatAssembler]

I have asked this question on a forum about SQL Server: https://www.reddit.com/r/SQLServer/comme...ium=mweb3x

[BrianSoddingBoru4]

Check with a linguist.

Boru

[Jehanne]

My consulting rate is $50/hr, prepaid with a 3-hr minimum. All sales are final. No refunds.

[arewethereyet]

I have asked this question on a forum about SQL Server: https://www.reddit.com/r/SQLServer/comme...ium=mweb3x

Thank you for that update.

Keep us posted.

[Angrboda]

The answer is moops.

[LadyForCamus]

Check with a linguist.

Boru

*snort*

[The Valkyrie]

If you re-write the equation in Sumerian cuneiform (NOT Babylonian cuneiform as most do), then put it through a Hebrew translator into Greek (Macedonian, of course), then run it through Auto-Correct, you'll get it right.*






*or possibly wrong. 50/50 chance.

[FlatAssembler]

Check with a linguist.

Boru

I do not understand. What does this have to do with linguistics?

[BrianSoddingBoru4]

Check with a linguist.

Boru

I do not understand. What does this have to do with linguistics?

Well, you submitted a linguistics idea to a mathematician, didn’t you?

Boru