Examine thestructure 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?

Question

Exhibit

Options

• ASELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM
• BSELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM
• CSELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE
• DSELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE

• A
  13% (5)
• B
  3% (1)
• C
  77% (30)
• D
  8% (3)

No community discussion yet for this question.