FilesExpand file tree

main

/

20-Case.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

34 lines (22 loc) · 636 Bytes

main

/

20-Case.sql

Copy path

Top

File metadata and controls

• Code
• Blame

34 lines (22 loc) · 636 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

-- QUESTION

-- Given a table of random numbers as follows:

-- numbers table schema

-- id

-- number1

-- number2

-- Your job is to return table with similar structure and headings, where if the sum of a column is odd,

-- the column shows the minimum value for that column, and when the sum is even, it shows the max value. You must use a case statement.

-- output table schema

-- number1

-- number2

-- SOLUTION

SELECT

CASE

WHEN (SUM(number1) % 2 = 0) THEN MAX(number1)

ELSE MIN(number1)

END AS number1,

CASE

WHEN (SUM(number2) % 2 = 0) THEN MAX(number2)

ELSE MIN(number2)

END AS number2

FROM numbers;