Introduction to SQL
How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE '%r%';
SELECT * FROM student WHERE name LIKE '_r%';
SELECT * FROM student WHERE name LIKE 'r%';
SELECT * FROM student WHERE name LIKE '%r';

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

The order of occurrence determines the order of evaluation.
NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

ANSWER DOWNLOAD EXAMIANS APP