SQL querys

mod alma
select distinct city from station where id%2=0;

kaçtane fazladan kayıt var onları bulur

SELECT (COUNT(city) - COUNT(DISTINCT(city))) FROM station;

belirtilen harf ilşe baslayan
SELECT DISTINCT CITY FROM STATION WHERE UPPER(SUBSTR(CITY,1,1)) IN ('A','E','I','O','U');

belirtilen harf ile biten 

SELECT DISTINCT city FROM station

WHERE LOWER( SUBSTR(city, LENGTH(city), 1) ) in ('a', 'e', 'i', 'o', 'u');


x ile başlayan x ile bile

SELECT DISTINCT city FROM station
WHERE LOWER( SUBSTR(city, LENGTH(city), 1) ) in ('a', 'e', 'i', 'o', 'u') and
LOWER( SUBSTR(city, 1, 1) ) in ('a', 'e', 'i', 'o', 'u');




select Name
from STUDENTS
where Marks > 75
order by SUBSTR(Name,LENGTH(Name)-2,3),ID