Crowdly
Add to Chrome
How many records does the following SQL statement generate? SELECT * FROM EXAM...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
How many records does the following SQL statement generate?SELECT * FROM EXAM_RESULTS WHERE LAST_NAME LIKE '%N%' AND EXAM_SCORE > 88;
Table EXAM_RESULTS
| STUDENT_ID | FIRST_NAME | LAST_NAME | EXAM_ID | EXAM_SCORE |
| 10 | LAURA | LYNCH | 1 | 90 |
| 10 | LAURA | LYNCH | 2 | 85 |
| 11 | GRACE | BROWN | 1 | 78 |
| 11 | GRACE | BROWN | 2 | 72 |
| 12 | JAY | JACKSON | 1 | 95 |
| 12 | JAY | JACKSON | 2 | 92 |
| 13 | WILLIAM | BISHOP | 1 | 70 |
| 13 | WILLIAM | BISHOP | 2 | 100 |
| 14 | CHARLES | PRADA | 2 | 85 |
0%
0%
0%
0%