The picture below shows a ticket for Super Bowl 57, which was held in Glendale, Arizona, in February 2023. Identify six attributes from this ticket.  

Given the following tables: Write SQL codes to add the following data to the tables: 1) A new customer named Celine Jackson who lives in Tucson, Arizona 85641. Her customer ID is 78190. 2) A new product (Sun glasses) with 715 as product ID and $17.99 as unit price.

Given the following tables: Write a SQL code to list the customers (customer ID, first name, last name, state, and zip code) who spent at least $500 in 2022.

Examine the code below: SELECT Major,                MAX(Grade) AS FROM Student WHERE MAX(Grade) > 95GROUP BY MajorORDER BY Major; Select the right answer:

Given the following ERD of a commercial bank:   Provide the list of customers (all columns in the Customer table) of the bank branches located in Arizona and who have an account balance of at least $10,000.

Given the following tables: Write a SQL code to provide the average length of time (in days) between sale date and shipping date by state. Your report should include the state and the average length of time. Order your list from the largest to the smallest time interval.

Using the database you have created for the health clinic, write an SQL code to create a report that lists: the first name, last name, and insurance ID of patients who were seen today, as well as the first name, last name, and specialty of the physician who consulted these patients. Include an alias for every column in the table.      

Again, using the database you have created for the health clinic, write a SQL code listing the patients (Patient ID, first name, last name, and age) of patients who were less than 15 years old on December 23, 2023.  

Erving Goffman called his approach in which social life is analyzed in terms of its similarities to theatrical performance a “theater theory”.

Part 2You will have from 7-9pm to complete part 2.Use the paper packet to guide your completion of questions 2-4.Please ensure you have attached all required Excel files before submitting your exam. You will not be able make changes to your exam after submission.Question 2 requires 1 Excel file attachmentQuestion 3 requires 1 Excel file attachmentQuestion 4 requires 3 Excel file attachments