Write a set of sql statements to add a fullfeepaid column


Problem

1. Modify your query to include all students, regardless of whether they registered in Adv. Pastels, starting October 1, 2013. Include, in this order, CustomerLastName, CustomerFirstName, Phone, Course, CourseDate, Fee, and AmountPaid.

2. Write a set of SQL statements to add a FullFeePaid column to ENROLLMENT and populate the column, assuming that the column is NULL. The only possible values for this column are Yes and No. (Compare COURSE.Fee to ENROLLMENT.AmountPaid to determine data values.)

The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write a set of sql statements to add a fullfeepaid column
Reference No:- TGS02112790

Expected delivery within 24 Hours