Examine the structure of the BOOKS_TRANSACTIONS table: 

You want to display the member IDs, due date, and late fee as $2 for all transactions. Which SQL statement must you execute? 

Answer options:

A. SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;
B. SELECT member_id `MEMBER ID`, due_date `DUE DATE`, `$2 AS LATE FEE` FROM BOOKS_TRANSACTIONS;
C. SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", `$2` AS "LATE FEE" FROM BOOKS_TRANSACTIONS;
D. SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

C