Question

Mr. Mittal created a table RECORD with following columns : NAME, CLASS, STREAM ID, STREAM_NAME He needs to display names of the student who have not been assigned any stream or have been assigned stream name that ends with "Accounta". He wrote the following command, which did not give the desired result. Help Mr. Mittal to run query by removing the error and write correct query SELECT NAME, STREAM_NAME FROM RECORD WHERE STREAM_NAME=NULL OR STREAM_NAME = "ACCOUNTS":​

Answer 1

Answer:

SELECT NAME, STREAM_NAME FROM RECORD WHERE STREAM_NAME=NULL OR STREAM_NAME = '%ACCOUNTS';​

Explanation:

Answer 2

Answer:

SELECT Name, Class FROM Students

WHERE Stream_name is NULL OR Stream_name   like "%computers" ;

Explanation:

its not '=' , while refering to unknown values using "%" like is used