Please consider offering answers and suggestions to help other students!
And if you fix a problem by following a suggestion here,
it would be great if other interested students could see a short
"Great, fixed it!" followup message.
I have constructed a query which when entering into SQLite3 correctly returns the output displayed in the expected results.
However when I enter my answer into the lab submission page it gives me some error involving parenthesis.
Could there be an issue with the automatic checking system?
I encountered the same problem, I was thinking to UNION first and EXCEPT the descr which INTERSECT both by using subquery, but it keeps showing unnecessary parenthesis, am I doing something wrong?
I thought that I had it with this hint from
https://stackoverflow.com/questions/58451528/parenthesis-in-sqlite-when-combining-union-and-except-statements
However; even with reformatting using what is mentioned in that post, and performing an intersection on a selection from (a union of exceptions), despite it running fine in my terminal - I'm getting the same 'you've used parenthesis incorrectly' error on moodle.
I'm assuming this one may be because of the union within brackets, again...
Sadly it didn't solve it for me, but feels like it's getting closer anyway (assuming the moodle checker is correctly operating), but hopefully it helps someone else get theirs over the mark.
Hello,
Still am getting the same error with "unexpected parentheses around UNION, INTERSECT or EXCEPT statements"
Everything I've tried has worked with sqlite3 and is giving the right output, however the moodle submission just returns this error.
Am I doing something wrong? Some guidance would be greatly appreciated.
