President

select CONCAT( NOW(), " Elijah Shope" );

select * from president;


select round(PI()*15*15, 2);


select last_name, first_name, state from president order by last_name limit 20;

select last_name, first_name, state from president order by state DESC, last_name;

select last_name, first_name, birth from president where birth < "1750-01-01";


select last_name, first_name, birth, death, to_days(death) - to_days(birth) from president;

select last_name, first_name, birth, death, (to_days(death) - to_days(birth))/365 from president;

select last_name, first_name, birth, death, round((to_days(death) - to_days(birth))/365) from president;


select last_name, first_name, birth, death, round((to_days(death) - to_days(birth))/365) from president order by to_days(death) - to_days(birth);