Exercise 4

This exercise will test your knowledge of aggregate functions.

We'll cover the following

Problem statement

Write a SQL query to fetch the second-highest salary in the SALARY table.

HINT: You will need to nest one query inside another to solve this problem.

Input

The following tables are available to you as inputs:

Get hands-on with 1200+ tech skills courses.