mysql - where clause in COUNT function and joining two queries -

I have a table that I am trying to calculate the number of courses passed, as well as passing I also list the modules made. / P>

My first problem is to put it in the variable, so that it is not specific to the customer (I can use the question below for a particular customer and a special course), but I It is a wide query where the results will be different in the case of a user like

and below

  select first name, last name, CourseTitle, Noofmodules, CountTextle (Coursecompleted) as EStudentsprogress From where are coursescompleted = 'modulescompleted 1' EmailAddress = 'scascsc@e.co.uk' and 'CourseTitle =' Microsoft MOS 2010 First, Last Name, Excel, Group by CourseTitle, Noofmodules, I can do this. The list is as above, under which I do not specify the email address or the course title (trying to get results for all customers)  
 In addition to this, I have a quote which has passed the courses passed by the customer. Lists the list, I have the column above Prefer with the list of courses included in the new results, but as a column for each course.  
  FirstName, Last name, CourseTitle, EmailAddress, CourseModule as the coursepassed from EStudentsprogress, where coursecompleted = 1  
 
 Cheers 
 

Text after "

You can add not only selected areas and email address and curriculum title areas for GROUP BY clauses.

In addition, you can use group_concat to bring an area containing all curriculum. Something like this: -

  First, last name, CourseTitle, Noofmodules, EmailAddress, CourseTitlecount, COUNT (Coursecompleted) modulescompleted, group_concat (CourseModule) as modulescompletednames ), Where the course ends with the progress of progressive progression = '1' Group Firstname, Last Name, Cortite, Nomfodules, Email Address, CortiteTack;