Some rows of a User table are shown below:

User

ucode

name

ranking

rate

$7$

Alex

$3$

$0\mathrm{.}2$

$8$

Tony

$2$

$0\mathrm{.}3$

$9$

Charles

$1$

$0\mathrm{.}8$

$11$

Mary

$3$

$0\mathrm{.}7$

Which of the following queries retrieves the rows where the ranking is less than $3$ and the rate is greater than $0\mathrm{.}4.$

$$

Group of answer choices

SELECT $*$ FROM User WHERE ranking $<3$ OR rate $>0\mathrm{.}4$

SELECT $*$ FROM User WHERE ranking $<=2$ AND rate $>=0\mathrm{.}4$

SELECT $*$ FROM User WHERE ranking $<3$ AND rate $>0\mathrm{.}4$

SELECT $*$ FROM User WHERE rate $>0\mathrm{.}4$