Question 12

Select all valid EJB-QL queries listed below.

a. SELECT OBJECT(inv) FROM Invoice inv WHERE inv.amount > 1000

b. SELECT OBJECT(inv) WHERE Invoice inv, inv.quantity <= 10

c. SELECT OBJECT(inv.amount) FROM Invoice inv WHERE inv.quantity >= 10

d. Select object(INV) fRoM Invoice inv WheRE inv.quantity =< 10

e. SELECT DISTINCT(inv) FROM Invoice inv WHERE inv.amount >= 10000