Quoting Post Archived Topic: It will not be bumped to the top of the forum. Topic SQL Help Membername   Not a member? Sign Up Free (takes 20 seconds) Password   Forgotten your password? Post Font: Verdana Arial Black Georgia Comic Sans Impact   Size: Tiny Normal Big Huge   Color: Default Dark Red Red Orange Brown Green Olive Cyan Blue Dark Blue Indigo Black [ Check Spelling ] [ Post Preview ] [ LiveTags ] Quote: from [m]HelloNerds[/m] at 2:21 pm on Mar. 13, 2008[quote]I have about 20 questions to do in my SQL class and cant figure out what commands to use. The teacher usually gives an example to get us going, if anyone know the proper SQL query, could you help out? Here's the question Query 1: Return the employee id and the total number of orders that each employee processed from the orders table, sort the total from highest number to lowest. [/quote] FAQ Keyword Search: Post Options Favorites Manager Notify me of new replies to this topic by email Notify me of new replies to this topic by private message Original Post HelloNerds Posted at 2:21 pm on Mar. 13, 2008 I have about 20 questions to do in my SQL class and cant figure out what commands to use. The teacher usually gives an example to get us going, if anyone know the proper SQL query, could you help out? Here's the question Query 1: Return the employee id and the total number of orders that each employee processed from the orders table, sort the total from highest number to lowest.

Replies Link01 Posted at 11:55 am on Mar. 14, 2008 you would use SELECT From; pleaseremove Posted at 4:50 pm on Mar. 13, 2008 We can't help you with this without knowing the structure of your database. All 2 previous replies displayed.