Find the names of all reviewers who have ratings with a NULL value for the date.
CREATE TABLE Rating (rID VARCHAR); CREATE TABLE Reviewer (rID VARCHAR)
SELECT DISTINCT name FROM Reviewer AS T1 JOIN Rating AS T2 ON T1.rID = T2.rID WHERE ratingDate = "null"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Rating (rID VARCHAR); CREATE TABLE Reviewer (rID VARCHAR) Question: Find the names of all reviewers who have ratings with a NULL value for the date. [/INST] SELECT DISTINCT name FROM Reviewer AS T1 JOIN Rating AS T2 ON T1.rID = T2.rID WHERE ratingDate = "null" </s>