This is incorrect. You're getting the most recent tag, which happened at a different time from the most recent status. The correct status didn't have a tag. You didn't need to access the tags table at all for this question. The following query would have worked:

SELECT status, created_at FROM statuses WHERE created_at IN (SELECT MAX(created_at) FROM statuses);