Ameu waty

 

34. Fo sai aluno nain  5 (nre, naran, disciplina, valor) nebe hetan valor kiik liu iha semestre Impar no tinan akademiku 2016;

     mysql> select a.nre,naran_aluno,valor melhor from valor v, disc d, aluno a where v.nre=a.nre and v.nu_disc=d.nu_disc and tipo_smtr='Impar' and ano_akademiku=2016 order by valor ASC limit 5; 

35. Fo sai kreditu hira mak aluno sira (nre,naran,kreditu) foti iha semestre Impar no tinan akademiku 2016;

    mysql> select a.nre,naran_aluno,sum(kreditu) as total_kreditu from valor v, disc d, aluno a where v.nre=a.nre and v.nu_disc=d.nu_disc and tipo_smtr='Impar' and ano_akademiku=2016 group by v.nre;
 
------------------------------------------------------------------------------------------------------------ 

36. Konta tinan husi Cristalina B. do Rego Freitas (tinan hira);

    mysql> select naran_aluno,year(curdate())year(data_moris) as tinan from aluno where nre='20130204015';  

37. Fo sai nre,naran,tinan husi aluno hotu;

    mysql> select naran_aluno,year(curdate())year(data_moris) as tinan from aluno;
 
38. Fo sai nre,naran,durasaun husi aluno sira durante estuda iha informatica;

    mysql> select naran_aluno,year(curdate())-ano as durasaun_estudu from aluno;
 
39. Fo sai loron moris husi Cristalina B. do Rego Freitas;

    mysql> select naran_aluno,dayname(data_moris) as loron_moris from aluno where nre='20130204015';
 
40. Fo sai data moris husi Cristalina B. do Rego Freitas;

  mysql> select naran_aluno,day(data_moris) as loron_moris from aluno where nre='20130204015'; 

41. Fo sai fulan (naran fulan) moris husi Cristalina B. do Rego Freitas; 

    mysql> select naran_aluno,monthname(data_moris) as loron_moris from aluno where nre='20130204015';
 
42. Fo sai tinan moris husi Cristalina B. do Rego Freitas; 

    mysql> select naran_aluno,year(data_moris) as loron_moris from aluno where nre='20130204015'; 

43. Fo sai naran, loron moris, data moris, fulan moris, tinan moris husi Cristalina B. do Rego Freitas; 

mysql> select naran_aluno,dayname(data_moris) as loron,day(data_moris) as data,monthname(data_moris) fulan, year(data_moris) as loron_moris from aluno where nre='20130204015'; 

44. Fo sai naran, loron moris, data moris, fulan moris, tinan moris husi aluno hotu;

  mysql> select naran_aluno,dayname(data_moris) as loron,day(data_moris) as data,monthname(data_moris) fulan, year(data_moris) as loron_moris from aluno;
 
45. Cristalina B. do Rego Freitas agora tinan hira, fulan hira no loron hira;

   mysql> select naran_aluno,curdate()-data_moris as tinan from aluno where nre='20130204015';