Write SQL query to find all students from BTech CSE who has not submitted the fees
Asked in the Online test stage. Single SQL question alongside basic MCQs. Use the students and fee_submissions tables.
student_id, student_name, program, and semester.student_id ascending.| Column | Type | Description |
|---|---|---|
| student_idPK | INT | Unique student identifier |
| student_name | VARCHAR(100) | Student's full name |
| program | VARCHAR(50) | Academic program |
| semester | INT | Current semester number |
| Column | Type | Description |
|---|---|---|
| submission_idPK | INT | Unique fee submission identifier |
| student_id | INT | Student associated with the fee submission |
| amount_paid | DECIMAL(10,2) | Amount recorded for the submission |
| payment_reference | VARCHAR(40) | Payment reference supplied by the payment system |