Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle General >> General Oracle questions >> it keeps coming up missing expression in line 1
        
(Message started by: Pete Finnigan on Oct 28^th, 2006, 12:50am)

Title: it keeps coming up missing expression in line 1
Post by Pete Finnigan on Oct 28^th, 2006, 12:50am

Here is the question: Provide a SQL statement that displays each SHIPSTATE along with the number of orders shipped to each state. Include only those states that more than 3 orders were shipped to.

here is my answer:
SELECT <shipstate>, <order_to_state>
FROM <tablename>
GROUP BY <state>
HAVING COUNT(<order_to_state>)>3

???