
Ultimate access to all questions.
The following code snippet is intended to create a view named shares_view with two columns: price (integer) and quantity (integer). The price column should only be visible to users who are members of the auditor group but not the compliance group. Which of the following options correctly completes the code?
CREATE VIEW shares_view AS
SELECT
_______________________________________
quantity
FROM shares;__
CREATE VIEW shares_view AS
SELECT
_______________________________________
quantity
FROM shares;__
A
CASE WHEN isMember(‘auditor’) and isNotMember(‘compliance’) THEN price ELSE 0 END AS price,
B
CASE WHEN is_member(‘auditor’) and is_not_member(‘compliance’) THEN price ELSE 0 END AS price,_
C
CASE WHEN isMember(‘auditor’) and NOT isMember(‘compliance’) THEN price ELSE 0 END AS price,
D
CASE WHEN is_member(‘auditor’) and NOT is_member(‘compliance’) THEN price ELSE 0 END AS price,
E
CASE WHEN member(‘auditor’) and not_member(‘compliance’) THEN price ELSE 0 END AS price,_