querying.main.key

 from information_schema.columns
 select column_name, data_type
 where table_name='Ai'
 ;
 from Ai
 select NTNM
 ;
 from AiWe a,Ai b
 select *
 where NTNM = FOXBAT%,a.NTNM = b.NTNM
 ;
 from Ai a,AiHi b
 select NTNM,SRVC
 where SVNM = MIG-19%,a.NTNM = b.NTNM
 ;
 from AiFuDi a,Ai b
 select avg(LGTH)
 where a.NTNM = b.NTNM
 ;
 from Ai a,AiWi b,AiWiDi c
 select *
 where SPAN > 25,a.NTNM = b.NTNM,b.NTNM = c.NTNM
 ;
 from AiFuDi a,Ai b,AiWi c,AiWiDi d
 select avg(LGTH)
 where SPAN > 25,a.NTNM = b.NTNM,b.NTNM = c.NTNM,c.NTNM = d.NTNM
 ;
 from AiCo a,Ai b
 select *
 where SVNM = MIG-21MF,a.NTNM = b.NTNM
 ;
 from AiPe a,Ai b,AiCoAr c
 select CMBR
 where WNME = ATOLL,a.NTNM = b.NTNM,b.NTNM = c.NTNM
 ;
 from Ai a,AiCoAr b
 select *
 where WNME = ACRID,CLASS = MISSILE,a.NTNM = b.NTNM
 ;
 from Ai a,AiCoAr b
 select count(*)
 where WNME = ACRID,CLASS = MISSILE,a.NTNM = b.NTNM
 ;
 from AiPeSp a,Ai b,AiCoAr c
 select max(*)
 where WNME = ACRID,CLASS = MISSILE,a.NTNM = b.NTNM,b.NTNM = c.NTNM
 ;
 from AiFuDi a,Ai b
 select min(LGTH)
 where ROLE = %I%,a.NTNM = b.NTNM
 ;
 from Ai a,AiFuDi b
 select min(LGTH)
 where ROLE = %B%,a.NTNM = b.NTNM
 ;
 from Ai a,AiCoCr b
 select count(*)
 where NMCRW = 2,a.NTNM = b.NTNM
 ;
 from Ai a,AiCoCr b
 select count(*)
 where NMCRW = 1,a.NTNM = b.NTNM
 ;