The data inside the STUDENT relation is like:
What will be the result of the following query:
SELECT STUDENT_FNAME,POWER(MARKS_MATHS-90,2) AS MARKSSQR from Student where FILED_OF_INTEREST = "Computer Science";
1
| STUDENT_FNAME | POWER(MARKS_MATHS-90,2) |
|---|---|
| Avinash | 36 |
| Divya | 49 |
| Vani | 25 |
2
| STUDENT_FNAME | MARKSQR |
|---|---|
| Kartik | 4 |
| Rohan | 4 |
| Aditya | 81 |
3
| STUDENT_FNAME | POWER(MARKS_MATHS-90,2) |
|---|---|
| Avinash | 25 |
| Divya | 36 |
| Vani | 17 |
4
| STUDENT_FNAME | MARKSSQR |
|---|---|
| Avinash | 25 |
| Divya | 36 |
| Vani | 16 |