\! echo 1
use rocket;
\! echo
\! echo 2
show tables;
\! echo
\! echo 3
describe vehicle;
describe launch;
\! echo
\! echo 4

\! echo
\!echo 5
select COUNT(*) from launch;
select COUNT(*) from site;
select COUNT(*) from vehicle;

\!echo
\!echo 6
select count(distinct manufacturer) from vehicle;
\! echo
\! echo 7
select * from site order by TimeStart asc limit 1;
\! echo
\! echo 8
select launchsite,date from launch order by date asc limit 1;

\!echo
\! echo 9
select * from site where (year(timestart)>1900 and year(timeend)>1900 and (year(timeend)-year(timestart))>30) or (year(timeend)=1900 and year(timestart)<1990 and year(timestart)>1900);

\!echo
\!echo 10
select * from launch where year(date)=1999 order by apogee desc; 

\! echo
\! echo 11
select count(vehicle) as cc, vehicle from launch group by vehicle order by cc desc limit 10;

\! echo
\! echo 12
select * from launch where date between '1988-03-01' and '1988-09-17';


\! echo 13
select vehicle from launch where year(date)=2018 group by vehicle order by COUNT(vehicle) desc limit 1;

\! echo
\! echo 14
select launchsite, COUNT(launchsite) from launch where year(date) = 2016; 

\! echo
\!echo 15
with jjj as (select count(vehicle) as c, vehicle as v from launch group by vehicle) select jjj.c, jjj.v from jjj where jjj.c>500;