CREATE TABLE Timed_Status_of_Things (thing_id VARCHAR2, Status_of_Thing_Code VARCHAR2, Date_and_Date VARCHAR2)
CREATE TABLE Things (thing_id VARCHAR2, Type_of_Thing_Code VARCHAR2)

What are the distinct id and type of the thing that has the status 'Close' or has a status record before the date '2017-06-19 02:59:21
SELECT DISTINCT T2.thing_id, T2.Type_of_Thing_Code FROM Timed_Status_of_Things AS T1 JOIN Things AS T2 ON T1.thing_id = T2.thing_id WHERE T1.Status_of_Thing_Code = 'Close' OR T1.Date_and_Date < '2017-06-19 02:59:21'
SELECT DISTINCT "T2"."thing_id", "T2"."Type_of_Thing_Code" FROM "Timed_Status_of_Things" "T1" JOIN "Things" "T2" ON "T1"."thing_id" = "T2"."thing_id" WHERE "T1"."Date_and_Date" < '2017-06-19 02:59:21' OR "T1"."Status_of_Thing_Code" = 'Close'