Answered You can hire a professional tutor to get the answer.

QUESTION

Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements:

Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements: Include the customer last name in all upper case characters, city, and the age of the customer for customers in the North and South region. Use an alias for the last name column and the age column. Order the results in descending order of age.

tblCustomer:

CustID (PK)

LastNameFirstNamePhoneCityRegionOverdue Status*PreferredIncomeNumOrdersBalanceBirthdate10

SmithBob123-4567OrlandoNorthPaid

Y1000051001/1/197812RamirezJose422-1234ApexSouthPaidY50000166002/8/197013WashingtonTerrell951-1234SujourEast[null]Y20000257003/5/198515JonesBill963-7894AxeCrossingWestUnpaidY16900250012/1/199017MoralesSandy951-1234OrlandoNorthPaidN85000904008/3/198621PrincipeMichelle963-4561ApexSouthPaidN94000853007/2/197423MavisJohn147-4561SujourEastUnpaidY25000266003/5/1989

*Overdue Status indicates customers with a balance that is 30 or more days overdue

Part 1: Write the complete SQL statement needed to return the rows that meet these requirements.

Part 2: What rows will be returned from this query? List the CustID of each row that will be selected. Your output does not have to be in the required order.

Part 3: What date function did you use? Justify your reasons for using this particular function. How else can this function be used?

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question