What is the latest date that orders were sent by supplier id 4? | Did you mean date of supplied from or to? | Supplied to.
SELECT date_supplied_to FROM Product_Suppliers where supplier_id  =  4 order by date_supplied_to desc limit 1
latest date = MAX(date); supplied to refers to date_supplied_to; supplier id 4 refers to supplier_id = 4;