Problem
a) Write and run an SQL query to list all students registered in Adv Pastels starting on October 1, 2019. Include, in this order, Course. CourseDate, Fee. CustomerlastName, CustomerFirstName, and Phone.
b) Write and run an SQL query to list all students registered in Adv Pastels starting on October 1, 2019. Include, in this order, Course, CourseDate, Customer LastName. CustomerFirstName, Phone, Fee, and Amount Paid. Use a join using JOIN ON syntax. Can this query be run using one or more subqueries? If not, why not?