Given the following two statements about SQL
(a) An SQL query can contain HAVING clause only if it has GROUP BY clause.
(b) In an SQL query “SELECT_FROM_WHERE_GROUP BY_HAVING”, HAVING is executed before WHERE.
Which of the following is correct?
1
(a) and (b) are true
2
(a) is true, (b) is false
3
(a) is false, (b) is true
4
(a) and (b) both are false