Can you break this down for me please?

icon
Related questions
Question
Can you break this down for me please? Thank you
Name: table1
codl
10
12
21
33
41
8
14
11
vall
10
10
11
10
9
10
9
11
val2
5
8
6
2
6
4
15
11
R
Transcribed Image Text:Name: table1 codl 10 12 21 33 41 8 14 11 vall 10 10 11 10 9 10 9 11 val2 5 8 6 2 6 4 15 11 R
What is the result of the query below?
SELECT MIN(codl)
FROM (SELECT vall, MAX(val2) max_val2
FROM tablel
GROUP BY vall) max_table
JOIN table1
ON max_table.val1 = table1.vall
WHERE val2 = max_val2;
Transcribed Image Text:What is the result of the query below? SELECT MIN(codl) FROM (SELECT vall, MAX(val2) max_val2 FROM tablel GROUP BY vall) max_table JOIN table1 ON max_table.val1 = table1.vall WHERE val2 = max_val2;
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer