Fix SQL Error in Grading App
Budget: $10 – $30 USD
I need help with error resolution in my grading system app. The error arises from a SQL query and reads as follows:
DB Execute Failed. ERROR: syntax error at or near ")" LINE 4: AND MARKING_PERIOD_ID IN () ^
Failure Notice
SELECT STUDENT_ID,GRADE_PERCENT,MARKING_PERIOD_ID,EXAM
FROM STUDENT_REPORT_CARD_GRADES
WHERE COURSE_PERIOD_ID='3139'
AND MARKING_PERIOD_ID IN ()
SQL query
The grading system app is built on PostgreSQL and is hosted on a cloud server. Users access the app through a web browser. I need a freelancer who can resolve this issue quickly and effectively. If your quote is reasonable and you deliver results, we can discuss more work in the future.
DB Execute Failed. ERROR: syntax error at or near ")" LINE 4: AND MARKING_PERIOD_ID IN () ^
Failure Notice
SELECT STUDENT_ID,GRADE_PERCENT,MARKING_PERIOD_ID,EXAM
FROM STUDENT_REPORT_CARD_GRADES
WHERE COURSE_PERIOD_ID='3139'
AND MARKING_PERIOD_ID IN ()
SQL query
The grading system app is built on PostgreSQL and is hosted on a cloud server. Users access the app through a web browser. I need a freelancer who can resolve this issue quickly and effectively. If your quote is reasonable and you deliver results, we can discuss more work in the future.