There is an inactive patient report which based on the last treatment date lists the patients who have not had treatment for a period of time SQL is:- select per.id ....