How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Chris Baxter Your Own Question

Chris Baxter
Chris Baxter, Programming Tutor
Category: Programming
Satisfied Customers: 246
Experience:  Completed BSIT concentration Software Engineering, tutored other students and classmates in Java and VB.net, C++, and Obj C.
68869132
Type Your Programming Question Here...
Chris Baxter is online now
A new question is answered every 9 seconds

Just learning SQL....doing homework....hitting a error 00920

Customer Question

Just learning SQL....doing homework....hitting a error 00920 for invalid relational operator. I've looked and researched everywhere but cant find the problem. The code really seems to look good.
JA: What programs and versions are you using?
Customer: Oracle
JA: What is your ideal outcome? How can we solve this for you?
Customer: I'd like to show you six lines of code and see if you see the problem.
JA: Anything else you want the programmer to know before I connect you?
Customer: No, that's it.
Submitted: 3 months ago.
Category: Programming
Expert:  Kevin T replied 3 months ago.

How's it going.
Let me read of your question. Give me a minute.

Expert:  Kevin T replied 3 months ago.

Could I see the code please?

Customer: replied 3 months ago.
SELECT Part_Num, Avg(Job_Qty_Produced) AS "AVERAGE PRODUCED"
FROM JOB LEFT OUTER JOIN PART ON Part_Num
WHERE Job.Job_StartTime > '10.10.2016'
GROUP BY Part.Part_Num
HAVING (Count(Part_Num)>3)
ORDER BY "AVERAGE PRODUCED" DESC;
Expert:  Kevin T replied 3 months ago.

SELECT Part_Num, Avg(Job_Qty_Produced) AS "AVERAGE PRODUCED"
FROM JOB LEFT OUTER JOIN PART ON Part_Num
WHERE Job.Job_StartTime > "10.10.2016"
GROUP BY Part.Part_Num
HAVING (Count(Part_Num)>3)
ORDER BY "AVERAGE PRODUCED" DESC;

Expert:  Kevin T replied 3 months ago.

Try that

Customer: replied 3 months ago.
It's still giving me the same error.
Expert:  Kevin T replied 3 months ago.

SELECT Part_Num, Avg(Job_Qty_Produced) AS "AVERAGE PRODUCED"FROM JOB LEFT OUTER JOIN PART ON Part_NumWHERE Job.Job_StartTime > "10.10.2016"GROUP BY Part.Part_NumHAVING (Count(Part_Num) > 3)ORDER BY "AVERAGE PRODUCED" DESC;

Customer: replied 3 months ago.
I don't see where you made a change
Expert:  Kevin T replied 3 months ago.

THe operator needs a space

> 3

Please rate me above

Customer: replied 3 months ago.
That didn't change error either.
Expert:  Chris Baxter replied 3 months ago.

Hello!

There are a few things here I am seeing, the first and main thing being

WHERE Job.Job_StartTime > "10.10.2016"

I can assume "Job_StartTime" is going to be a time? In this case you are comparing a string containing your date to a time delimited object that would be expecting 8:00pm instead of 10.10.2016, and your Select and order by here as string containing average produced, is not containing the actual average, but the words 'average produced' it is a different kind of error all together, but may affect your operands and throw the same error.