Merhabalar, SQlite ile oluşturduğum tabloda belli bir aralıktaki değerleri sayıp adlandırmak istiyorum. Yardımcı olabilir misiniz?
create table if not exists exam (first name text, last name text, salary integer, title text, department text, branch ıd PRIMARY KEY );
INSERT INTO exam values ('Mohammed','Serag',100000,'Manager','Admin','A005');
INSERT INTO exam values ('Amir','Sami',500000,'Executive','Admin','A001');
INSERT INTO exam values ('Menekşe','Arar',25000,'Manager','HR','A007');
INSERT INTO exam values ('Veysel','Selçuklu',300000,'Lead','HR','A002');
INSERT INTO exam values ('Nihal','Varan',80000,'Executive','Admin','B001');
INSERT INTO exam values ('Gökhan','Çam',90000,'Manager','Admin','A014');
INSERT INTO exam values ('Salih','Kumar',75000,'Asst. Manager','Account','B004');
INSERT INTO exam values ('Veysi','Duvarlı',200000,'Executive','Account','C002');
SELECT * FROM exam WHERE salary>80000;
SELECT * FROM exam WHERE department='HR';
SELECT * FROM exam WHERE salary>20000 and salary<30000;
SELECT * FROM exam WHERE title='Manager' or title='Lead';
SELECT t.*
FROM exam t
ORDER BY salary DESC
LIMIT 501