Answered by trabi71

SELECT name,entered_office 
FROM us_senate
order by entered_office
limit 3;

Answered by jengahguy

SELECT name,entered_office 
FROM us_senate
order by entered_office
limit 3;

Answered by amkreiner

SELECT name, entered_office, TIMESTAMPDIFF(month, entered_office, CURDATE()) - 1 AS months_in_office
FROM us_senate
ORDER BY months_in_office DESC
LIMIT 3;

Answered by anonymousUser

select name, entered_office, PERIOD_DIFF(CURDATE(), STR_TO_DATE(entered_office, '%m-%d-%Y')) from us_senate order by entered_office limit 3;