ICT Nov 2012 problem

[Mitch Planko]

Hello,

I have a problem in step 39 in Nov 2012 paper 2

the question is:

Find only the MicroEco cars that have been sold in Madrid
Using this selection produce a new report which:
• shows only the Sales_person, Model and Price
• calculates the total value of these sales for each Sales_person
• counts the number of these cars sold by each Sales_person

the problem is that I can't make all the names of sales person in only one name

example: if in records Marcos, Marcos, Marcos

I want them to be only one Marcos

 

[Loodynagy]

Hello,

I have a problem in step 39 in Nov 2012 paper 2

the question is:

Find only the MicroEco cars that have been sold in Madrid
Using this selection produce a new report which:
• shows only the Sales_person, Model and Price
• calculates the total value of these sales for each Sales_person
• counts the number of these cars sold by each Sales_person

the problem is that I can't make all the names of sales person in only one name

example: if in records Marcos, Marcos, Marcos

I want them to be only one Marcos

And since it has been almost 2 years, have you come up with a solution?

 

[haryyy9900]

And since it has been almost 2 years, have you come up with a solution?

Group by the sales_person in the query