SQL++ - Merchant - Big ticket orders

Sonia now wants to find out which of the orders in the month of April exceeded the unit price of $500. The query on the right uses UNNEST and JOIN clauses to get the desired results.

To run this example, click the button in the top right corner of the code editor.

Code Editor

Output