Reference no: EM132178533
Anwer the following business questions:
relation schema below to answer following questions
credit (credit-number, branch name, balance, max credit) borrower credit-number)
a" write an SQL statement to show all the customer names, credit balance are less than $500 away from the whose maximium credit line, that is max 500.
b. Write a relational algera expression that will do exactly same asthe soL above.
2. Consider the following relational schema
Wha Student (ID GPA) ID is a key Players (ID, sport) KID, sport is the primary key
Where ID is student identification number in both schemas, sport is the name of the sport (like baseball, football etc.)
Write a SQL query using aggregate functions to find out the average GPA for each sport. (3 points)