A survey was done to observe how students use transportation…

A survey was done to observe how students use transportation (if at all) to travel to and from campus. Since some people do not own cars, for the “How many days do you use your personal vehicle?” question, some students left that question blank. Now that you have access to that dataset of survey results, you encounter a lot of null values that make the dataset hard to work with. Which of these queries fills in those NULL values with non-null data?

We have done a giveaway to promote our new rewards program….

We have done a giveaway to promote our new rewards program. The giveaway was designed to give the postal code with the most activity Elite status while all other postal codes would begin as Standard. Postal code 33111 won our giveaway and we would like to now add the customer status attribute to the customers table. Which of the following queries will accomplish this goal? Note, we are assuming postal code is a character attribute.