LiveWire Peer Support Network

Printable Version of Topic "SQL Help"

- LiveWire Teen Forums & College Forums (http://www.golivewire.com)
-- (http://www.golivewire.com/forums/support-technical.html)
--- Programming & Application Development (http://www.golivewire.com/forums/forum-211-s-0.html)
---- SQL Help (http://www.golivewire.com/forums/peer-ptbbps-support-a.html)


-- Posted by HelloNerds 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.


-- Posted by pleaseremove at 4:50 pm on Mar. 13, 2008

We can't help you with this without knowing the structure of your database.


-- Posted by Link01 at 11:55 am on Mar. 14, 2008

you would use

SELECT From;


www.golivewire.com