Question#$5$:

$($Select the correct answer$)$

Which code sample$($s$)$ properly display all records that have a balance over $$500$ and sorted by balance:

I

a$)$ SELECT $*$ FROM cust ORDER BY balance, balance $>500$;

b$)$ SELECT $*$ FROM cust ORDER BY balance $>500$;

c$)$ SELECT $*$ FROM cust WHERE balance $>500$ ORDER BY balance;

d$)$ SELECT $*$ FROM cust ORDER BY balance AND balance $>500$;