Hi,
I have a table of enrolments. Each row is a single enrolments by a Learner on a course in a Curriculum Area. A Curriculum Area can have a number of different types of courses eg. CurrArea Languages offers French, German and Italian and a Learner could join one or more courses in any or all of the languages offered.
I need to query:
Thanks,
Ambre
I have a table of enrolments. Each row is a single enrolments by a Learner on a course in a Curriculum Area. A Curriculum Area can have a number of different types of courses eg. CurrArea Languages offers French, German and Italian and a Learner could join one or more courses in any or all of the languages offered.
I need to query:
- How many enrolemnts in CurrArea Languages.
- How many unique Learners in CurrArea Languages.
- How many enrolemnts in French.
- How many unique Learners are studying French.
Thanks,
Ambre