select flightnumber, date, destination, boarded + transferred + nonrevenue as Total from marchflights where total < 100; What will happen when this query is submitted ?

  1. Error: as mathematical computation is not allowed while using proc sql.

  2. ERROR: The following columns were not found in the contributing tables: total.

  3. Warning : the type of the variable total is not declared(character or numeric).But due to automatic conversion, some unexpected value is being populated in variable total.

  4. Error: variable total nor recognized(because there are two spelling - Total and total)


Correct Option: B

Find more quizzes: