Based on the pizza database you imported, complete the sql statement below to add the column vip to the customers table. the customer will either be gold, silver, bronze level vip. there is a blank in the query, and you should enter the required text in the box below. when completing the statement, ensure you use the same naming conventions as other columns in the database and choose the most appropriate datatype. your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces. alter table customers add [a]

The answer is: ALTER TABLE Customers ADD vip text;

Explanation:

The basic syntax for the ALTER TABLE command in SQL for adding a new column is:

ALTER TABLE tableName ADD columnName dataType;

In this case, the following replacements must be made:

tableName = Customers

columnName = vip

dataType = text

Notice that the Pizza database referenced, is not included in the question, so the following assumptions were made:

nope i prefer two because it is simpler, i don't like all the powers you get

explanation:

but that's my opinion

i don't think so. although it would be nice. i am pretty sure that was an option an update or two ago. i guess they want you to stay 14 forever. haha.