Following sample data is available:

COURSE Sample data

Course ID	Price ($)	Instructor Name	Instructor Address
S111	2850	Harry	UB
S121	3200	Polly	UB
S155	1200	Smith	Loyola
H111	500	Morton	JHU
H123	2200	David	JHU
H125	1200	Polly	UB
H221	800	Lionel	UB
H225	1450	Lionel	UB

TRAINEE sample data

Trainee ID	CourseID	Trainee Name	Date of training
A101	H111	Sam Paper	10/02/2016
A101	H123	Sam paper	10/03/2016
A110	S111	Mary Poppins	11/01/2016
B112	S111	Alex Johnson	11/01/2016
B112	S121	Alex Johnson	11/02/2016
B112	S155	Alex Johnson	11/06/2016
B222	H123	John Watt	10/03/2016
B222	H111	John Watt	10/01/2016
B222	S111	John Watt	11/06/2016
B222	S121	John Watt	11/02/2016
B222	S155	John Watt	10/05/2016
C111	H123	Jong Chu	10/03/2016
C111	H111	Jong Chu	10/02/2016
F456	S111	Jerry Long	11/08/2016
F555	S111	Willy Polk	11/08/2016
F555	S155	Willy Polk	11/06/2016
F555	H111	Willy Polk	02/11/2016
X123	H123	Shirley Dent	10/03/2016
X123	S111	Shirley Dent	11/06/2016
X123	H125	Shirley dent	02/11/2016
X123	H225	Shirley dent	10/02/2016

11. Give the total revenue generated by course H123. Hint: count number of times H123 repeats in trainee table; adds price for those occurrences for course H123 from course table. Ex: If 5 students take course S145 and price is 1200 each, the their revenue will be 1200*5 = 6000 (or 1200 added 5 times)

12. Give the total number of students taking classes in November. Hint: use between to get November count, i.e., between date 1 AND date 2 13. Give the total salary of each instructor. Ex: If an instructor taught 5 students in course H221 and 2 students in H111, then their salary would be 5*800(price of H221)+2*500(price of H111)= $5000

14. Create an Enrollment report of Dates and Overall total number of students taking classes on those dates, i.e., 10/02/2016; 10/03/2016. see the template below: