Regent University Oracle Apex Database Command Line MySQL Coding Task Code an SQL statement to create a view named CourseFeeOwedView that shows CourseNumbe

Regent University Oracle Apex Database Command Line MySQL Coding Task Code an SQL statement to create a view named CourseFeeOwedView that shows CourseNumber, Course, CourseDate, CustomerNumber, CustomerLastName, CustomerFirstName, Phone, Fee, AmountPaid, and the calculated column (Fee – AmountPaid), renamed as AmountOwed.
Code an SQL statement that displays the data in CourseFeeOwedView, sorted alphabetically by CustomerLastName.
Code an SQL statement that displays the data in CourseFeeOwedView, sorted alphabetically by CustomerLastName for any customer who still owes money for a course fee.
Write a user-defined function named FirstNameFirst that concatenates the CustomerLastName and CustomerFirstName into a single value named CustomerName and displays, in order, the CustomerFirstName, space, and the CustomerOwnerLastName (Hint: Johnson and Ariel would be combined to read Ariel Johnson).

Your function should take in the CustomerFirstName and CustomerLastName as parameters and a return a VARCHAR field those combined together with a space. Hint: Use the || operator to combine the strings

Code an SQL statement to create a view named CourseEnrollmentFirstNameFirstView that shows CourseNumber, Course, CourseDate, CustomerNumber, CustomerLastName and CustomerFirstName concatenated using the FirstNameFirst user-defined function and displayed as CustomerName, and Phone.
Code an SQL statement that displays the data in CourseEnrollmentLastNameFirstView, sorted alphabetically by CustomerName and CourseNumber.

Tables

CUSTOMER (CustomerNumber (PK), CustomerLastName, CustomerFirstName, Phone)

COURSE (CourseNumber (PK), Course, CourseDate, Fee)

ENROLLMENT (CustomerNumber (PK,FK), CourseNumber(PK,FK), AmountPaid)