reset password
Author Message
smirand8
Posts: 8
Posted 19:27 Apr 24, 2012 |

Does anyone know how to sort the avg price results for numbers 4 and 5 on the hw?

JackStrauss
Posts: 236
Posted 19:43 Apr 24, 2012 |

What exactly do you mean by this?

 

Can you expand a little bit?

 

Have you completed the actual queries for 4 and 5 as required by the prof?

 

Oh wait, I read the query prompt and I understand what you mean.  

 

Hmmm...isn't sort a synonym for "group"?

 

Last edited by JackStrauss at 19:44 Apr 24, 2012.
smirand8
Posts: 8
Posted 19:51 Apr 24, 2012 |

Oh yeah it could be but when I group it to avg it doesn't work.

JackStrauss
Posts: 236
Posted 19:56 Apr 24, 2012 |
smirand8 wrote:

Oh yeah it could be but when I group it to avg it doesn't work.

Yeah, I just ran into the same problem trying to "sort" the information using the 'average".

 

I'm trying to research the solution to see if I can solve this.

Sorry I don't have the answer.

 

JackStrauss
Posts: 236
Posted 19:58 Apr 24, 2012 |

After a quick Google search using the keywords "w3schools sort sql",

 

I was directed to this link.

http://www.w3schools.com/sql/sql_orderby.asp

 

It seems helpful.  Take a look. 

smirand8
Posts: 8
Posted 20:28 Apr 24, 2012 |

Thanks it helped.