Extracting data and using it as information is important in making decisions. It is important to understand how to extract the data needed for processing into information. There are some information technology careers that are based on querying data for reporting. In this assignment, you are given a set of fields that are defined in a sample table or definition of data. You are required to write SQL statements using SQL, just standard SQL, to satisfy specific criteria for extracting data. The statements/requirements are below with the associated criteria. You can simply record you answers in a document and submit the document using this assignment link for grading. You should read this weeks reading assignment before you attempt to complete the assignment. Each correct answer is worth 4 points for a total of 20 points.

Sample table or definition of data: Customer Information, table name = customerinfo

ci_account_num, integer

ci_first_name, varchar(50)

ci_last_name, varchar(50)

ci_address_1, varchar(50)

ci_address_2, varchar(50)

ci_city, varchar(50)

ci_state, varchar(2)

ci_zip, varchar(9)

ci_telephone, varchar(10)

ci_email_address, varchar(65)

Remember to use the correct syntax for each of the required SQL statements to satisfy the criteria.

1. Use CREATE for the creation of a table, customerinfo, using the definition of data above.

2. Use INSERT to add a record to the customerinfo table. You determine the actual data within each field to be added. Insure that each field has some data to be entered into the record.

3. Use SELECT to extract information using the fields, ci_account_num, ci_first_name, and ci_last_name for all customers with an Indiana address.

4. Use SELECT to extract information using the fields, ci_first_name, ci_last_name, ci_telephone, and ci_email_address for all customers that have an e-mail address. If the customer does not have an e-mail address listed, they should be included in the extracted data.

5. Use SELECT to extract information using the fields, ci_first_name, ci_last_name, and ci_telephone where the first three digits of the telephone number are 317.