SQL

1. Create a new table called: BillingInformation
   • Your new table should contain the following columns with this exact naming convention. Make the user ID a Primary Key. Use appropriate datatypes Addresses should be VARCHAR(24), user ID should use the same datatype as it is in the user table, all other fields can be INT:
     • UID,StreetAddress1,Address 2,phone,Transitno,InstitutionNo,AccountNO

2. Write the insert statement(s) to add yourself to the BillingInform Table. Use your college Information and valid made-up test data where appropriate. Your AccountNo should be 000000. Take a screenshot of yourself in the required table(s) after you have been inserted to attach to the word template.

3. Write a query that will update the Comments table, and change Show to false (0) if the number of downvotes is greater than: 102