Mr. Mittal is using a table with following columns : Name, Class, Stream_ld, Stream_name

Q. Mr. Mittal is using a table with following columns:

         Name, Class, Stream_ld, Stream_name

He needs to display names of students who have not been assigned any stream or have been assigned stream_name that ends with "computers".

He wrote the following command, which did not give the desired result.

SELECT Name, Class FROM Students

WHERE Stream_name = NULL OR Stream_name = "%computers" ;

Help Mr. Mittal to run the query by removing the error and write correct query.

Answer =

SELECT Name, Class FROM Students
WHERE Stream_name is NULL OR Stream_name   like "%computers" ;