Back

Answered by Waytan

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

Answered by jonalexander

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

Answered by gurneet kaur

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

Answered by charlie1404

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

Answered by retr0sushi.04

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

Answered by Pfwd44

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

Answered by aklagoo@gmail.com

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

Answered by abhi

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

Answered by anthony_calek

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

Answered by tymp

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

Answered by bocalettirocco

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

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;