Find Second Highest Order

Medium

Unlock detailed company stats for this questionUpgrade

You are given the following tables:

orders table:

order_id	customer_id	order_date	order_amount	department_id
integer	integer	date	integer	integer

departments table:

department_id	department_name
integer	string

customers table:

customer_id	first_name	last_name
integer	string	string

Find the 2nd highest order amount in the fashion department. Your output should have the following column: order_amount