(Not) Basic Command

Dari perintah perintah dasar yang telah dijelaskan sebelumnya, dapat dikembangkan dan digabungkan dengan berbagai operasi untuk membuat perintah perintah yang lebih lanjut. Pada umumnya, perintah yang sering digunakan adalah SELECT.

SELECT dari tipe data TEXT:

SELECT * FROM movies WHERE imdb_rating > 8;

SELECT * FROM movies WHERE name LIKE ‘se_en’;
SELECT * FROM movies WHERE name LIKE ‘a%’;

SELECT * FROM movies WHERE name BETWEEN 'A' AND 'J';
SELECT * FROM movies WHERE year BETWEEN 1990 AND 2000;
SELECT * FROM movies WHERE year BETWEEN 1990 AND 2000 AND genre = 'comedy';
SELECT * FROM movies WHERE year BETWEEN 1990 AND 2000 OR genre = 'comedy';

SELECT * FROM movies ORDER BY imdb_rating DESC;
SELECT * FROM movies ORDER BY imdb_rating ASC LIMIT 3;

SELECT dari tipe data INTEGER:

SELECT COUNT(*) FROM fake_apps;
SELECT COUNT(*) FROM fake_apps WHERE price = 0;

SELECT price, COUNT(*) FROM fake_apps GROUP BY price;
SELECT price, COUNT(*) FROM fake_apps WHERE downloads > 20000 GROUP BY price;

SELECT SUM(downloads) FROM fake_apps;
SELECT category, SUM(downloads) FROM fake_apps GROUP BY category;

SELECT MAX(downloads) FROM fake_apps;
SELECT MIN(downloads) FROM fake_apps;
SELECT AVG(downloads) FROM fake_apps;

SELECT name, MAX(downloads) FROM fake_apps GROUP BY category;
SELECT price, ROUND(AVG(downloads),2) FROM fake_apps GROUP BY price;