A.SELECT &&col1,&&col2
FROM &table
WHERE &&condition= &&cond;

B.SELECT'&co11','&&co12'
FROM &table
WHERE'&&condition' ='&cond';

C.SELECT &col1, &col2
FROM "&table"
WHERE &condition;

D.SELECT &col1, &col2
FROM &&table
WHERE &condition;

E.SELECT&&col1, &&col2
FROM &table
WHERE &&condition;

A.LAST_DAY returns the date of the last day of the month for the date argument passed to the function.

B.LAST_DAY returns the date of the last day of the current ,month onlyu.

C.CEIL requires an argument which is a numeric data type.

D.LAST_DAY return the date of the last day the previous month only.

E.CEIL returns the largest integer less than or equal to a specified number.

F.ADD_MONTHS adds a number of calendar months to a date.

G.ADD_MONTHS works with a character string that can be implicitlyt converted to a DATE data type.

A.SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

B.SELECT member_id AS "MEMBER ID", due_date AS "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

A.SELECT SUBSTR(join date, 1, 2)- 10 FROM employees;

B.SELECT join date 11.'11 salary FROM employees;

C.SELECT join date + 20 FROM employees;

D.SELECT join date FROM employees where join date > *10-02-2018*;

E.SELECT salary + 120.50 FROM employees;

A.SELECT MAX(inv_date),MIN(cust_id)FROM invoice;

B.SELECT AVG( inv_date - SYSDATE), AVG(inv_amt)FROM invoice;

C.SELECT AVG(inv_date)FROM invoice;

D.SELECT MAX(AVG(SYSDATE -inv_date))FROM invoice;