You come across the following query when working in PostgreSQL.
SELECT a FROM b UNION SELECT x FROM y LIMIT 10
Which of these choices correctly depicts how this query is evaluated?
Options
- It is evaluated as (SELECT a FROM b UNION SELECT x FROM y) LIMIT 10
- It is evaluated as SELECT a FROM b UNION (SELECT x FROM y LIMIT 10)
- It throws a syntax error
- It throws a runtime error