Using OFFSET (Q2)

Hard

Using the same table employees as the prior question, write a SQL query to find the next 5 employees who were hired after the first 10 in the 'Marketing' department, but only those who were hired in 2020.

Hint: In order to get all users that got hired in 2020, you will use EXTRACT(YEAR from hire_date) = 2020.

Example Output:

name
Alice
Bob
Charlie
David
Eve

Using OFFSET (Q2)

SQL+1

Hard

Hint: In order to get all users that got hired in 2020, you will use EXTRACT(YEAR from hire_date) = 2020.

Example Output:

name
Alice
Bob
Charlie
David
Eve

Modules

Using OFFSET (Q2)

Example Output:

Using OFFSET (Q2)

Example Output: