Question: COMP3710 Relational Databases l. Questions related to SQL What does SQL represent? Write the SQL statements for the following tasks based on BATable and cTable:
COMP3710 Relational Databases l. Questions related to SQL What does SQL represent? Write the SQL statements for the following tasks based on BATable and cTable: 1. Delete all the clients located in Kyle city from CTable. 2. Display all the fields of al the records from BATable. 3. List the client number, client name, amount paid, and current due of all the clients whose current due is greater than S1,000. 4. List the client number, name, amount paid, current due, and analyst number for all clients. Sort the records by analyst number in ascending order. And then sort the clients with the same analyst number by amount paid in descending order. 5 Group the records from the client table by Business Analyst Number. For each group, display business analyst number, the average of the amount paid (name it as AveAmountPaid), and the average of the current due (name it as AvecurrentDue). Finally sort the records by business analys number in ascending order
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
