Quiz: Transforming Data and Functions
Test your knowledge of the database functions.
We'll cover the following...
We'll cover the following...
Transforming data and functions
1.
What is the output of the following code?
SELECT COUNT(Customer) AS TotalIDs
FROM Cust.Customers
A.
The code outputs the number of columns with the TotalIDs alias.
B.
The code outputs the records in the Cust.Customers table including NULL with the TotalIDs alias.
C.
The code outputs the number of records in the Cust.Customers table excluding NULL values with the TotalIDs alias.
D.
The code outputs all the rows in the Cust.Customers table with the TotalIDs alias.
1 / 7
...