####Ders 1####
select ((12+65)*65/3)%3;
select (12>56) or (65>=65);
select 35 BETWEEN 20 and 90;
select * from notlar where basariNotu BETWEEN 40 and 70;
select basariNotu BETWEEN 40 and 70 from notlar;
select * from notlar where ad="ZEHRA";
select id,ad="ZEHRA" from notlar;

####Ders 2####
select * from ogrenciler where altbirim is null;
select * from ogrenciler where altbirim is not null;
select 1 is true;
select 0 is not FALSE;
select * from ogrenciler where id in (34,76,6765454,98,32,78);
select kisiler.* from kisiler,basvurular WHERE kisiler.id=basvurular.kisiID;
SELECT * from kisiler where id in (select kisiID from basvurular);

####Ders 3####
select GREATEST(567,76,24354,98,3,5687);
select ad,soyad,GREATEST(vize,final) from notlar;
select max(vize) from notlar;
select LEAST(567,76,24354,98,3,5687);
select ad, soyad, LEAST(vize,final) from notlar;
select min(final) from notlar;
select 3<>5;
select * from ogrenciler where ad like "A%";
select * from ogrenciler where ad like "C%_N";

####Ders 4####
select ascii("A");
select bin(135);
select length("Ahmet");
select ad, length(ad) from ogrenciler;
select insert("Araba",6,2,"cı")
select insert("dolap",1,0,"Gar")
select insert("Salon",4,2,"kım")
update kisiler set tcKimlikNo=insert(tcKimlikNo,1,0,"o");
update kisiler set tcKimlikNo=insert(tcKimlikNo,1,1,"");

####Ders 5####
select lower("MEHMET");
select lower(ad),lower(soyad) from ogrenciler where notOrtalamasi<70;
select upper("Mehmet");
select upper(adres) from basvuru_iletisim_bilgileri;
update basvuru_iletisim_bilgileri set adres=upper(adres);
select left("Mehmet",3);
select lower(ad),upper(soyad),no,18-left(no,2) from ogrenciler where left(no,2)<=18;
select lower(ad),upper(soyad),no,2018-insert(left(no,2),1,0,"19") from ogrenciler where left(no,2)>18;
select right("Mehmet",3);
select left(lower(right(soyad,4)),2) from kisiler;
select ltrim("            Ahmet                 ");
select rtrim("            Ahmet                 ");
select trim("       Ahmet Çakır       ");
select substr("Mehmet",3,4);
select substring(ad,2,5) from kisiler;
select repeat("ahmet",3);
select locate("t","Ahmet");
select locate("@gmail.com","serbest.ziyanak@gmail.com");

####Ders 6####
select reverse("Mehmet");
select left("Ahmet Çakır",5);
select substr("Mustafa Çakır",1,5);
select locate(" ","Ahmet Çakır")-1;
select locate(" ","Mustafa Çakır")-1;
select left("Ahmet Çakır",locate(" ","Ahmet Çakır")-1);
select substr("Mustafa Çakır",1,locate(" ","Mustafa Çakır")-1);
select left(adsoyad,locate(" ",adsoyad)-1) from deneme;
update deneme set ad=left(adsoyad,locate(" ",adsoyad)-1);
select right(adsoyad,5) from deneme;
select length(adsoyad)-locate(" ",adsoyad) from deneme;
select right(adsoyad, (length(adsoyad)-locate(" ",adsoyad)) ) from deneme;
update deneme set soyad=right(adsoyad, (length(adsoyad)-locate(" ",adsoyad)) );
select insert(no,1,0,"o") ,lower(ad),upper(soyad) from ogrenciler;
select replace("Yüzüncü Yıl Üniversitesi Van Meslek Yüksek Okulu","Van","Başkale");
select ad,soyad,REPLACE(mezunDurum,"1","Mezun") from ogrenciler;
select replace(email,"hotmail.com","yyu.edu.tr") from basvuru_iletisim_bilgileri;
select concat("Van ","Yüzüncü ","Yıl ","Üniversitesi");
select concat(ad," ",soyad) from ogrenciler;
select length(email) from basvuru_iletisim_bilgileri;
select locate("@",email) from basvuru_iletisim_bilgileri;
select length(email)-locate("@",email) from basvuru_iletisim_bilgileri;
select distinct(right(email,length(email)-locate("@",email))) from basvuru_iletisim_bilgileri;

####Ders 7####
select now();
select curdate();
select adddate("2005-09-03 15:12:56",interval -2 week);
select date_add(now(),interval 3 year);
select date_format(now(),"%d/%m/%Y %h-%i-%s");
select date_format(now(),"%Y-%h");
select DATE_FORMAT(now(),"%T");
select datediff("2010-06-08","1920-04-23");
select datediff(curdate(),"1920-04-23");
select dayname(now());
select monthname(now());
select dayofweek(now());
select dayofyear(now());
select from_days(1000000);