1.

2.

3.

4.

5.

6.

For the following questions, use the below TCSS 445 Inc. database and complete the answer requirement for each question in the space provided. CUSTOMER AGENT Assume AG_CODE and CUS_CODE columns in CUSTOMER as well as AGENT_CODE, AGENT_AREACODE in AGENT can only accept INT values. In the space provided below, what is the output result after executing the following SQL query on the TCSS 445 Inc. database. SELECT CUST_CODE FROM CUSTOMER WHERE AG_CODE =502; You may write your answer in tabular format, if any. To do so, use the Rich Text Editor feature located on the top-right corner of the answer text-box to complete your answer. In the space provided below, write an appropriate SQL query that retrieves the last and first name of all customers whose last name ends with 'th'. How many records will be retrieved when the following SQL query is executed on the TCSS 445 Inc. database? SELECT CUS_LNAME, CUS_FNAME, AGENT_CODE, AGENT_NAME FROM CUSTOMER, AGENT; In the space provided below, write an appropriate SQL query that retrieves the first and last name of all customers who have the same agent as Alfred Ramas. In the space provided below, write an appropriate SQL query that computes the average agent yearly to date sales (column agent_ytd_sales). Display the resulting column as Agent_Sales. Complete the following SQL query which identifies the total number of agents. SELECT ____ (AGENT_CODE) as NumAgents FROM AGENT