List all occurrences of Adv. Pastels. Include all associated fields for each occurrence of the class
The following questions refer to the Art Course database. You can obtain a copy of this data in the Access database, located on Canvas the course Web site listed below under this assignment or you could simply download it by clicking the file name here Art_Course_Database.accdb download). The database contains data shown in Figure 1-10. CUSTOMER (CustomerNumber, CustomerName, Phone) COURSE (CourseNumber, Course, CourseDate, Fee) ENROLLMENT (CustomerNumber, CourseNumber, AmountPaid) where CustomerNumber in ENROLLMENT must exist in CustomerNumber in CUSTOMER CourseNumber in ENROLLMENT must exist in CourseNumber in COURSE Write SQL queries to produce the following results. For submission, include your SQL queries (code) in a Word document. The returned results (screenshots) are optional. 1) List all occurrences of Adv. Pastels. Include all associated fields for each occurrence of the class. 2) List the minimum, maximum, and average full fee amount pa