NEW
Font size
WorksheetsSQL SAKILA Gruop by
Total questions: 8
Worksheet time: 9mins
Koks SQL sakinys naudojamas duomenims iš lentelės ištraukti?
SELECT
INSERT
UPDATE
DELETE
Kaip iš lentelės film pasirinkti tik unikalius filmų pavadinimus?
SELECT UNIQUE title FROM film;
SELECT title FROM film;
SELECT DISTINCT title FROM film;
SELECT DIFFERENT title FROM film;
Kuri funkcija SQL naudojama tekstui paversti didžiosiomis raidėmis?
CAPITALIZE()
UPPER()
TEXT_UPPER()
TO_UPPER()
Kaip gauti brangiausiai kainuojančio filmo nuomos kainą (rental_rate) iš film lentelės?
SELECT HIGHEST(rental_rate) FROM film;
SELECT BIGGEST(rental_rate) FROM film;
SELECT MAX(rental_rate) FROM film;
SELECT rental_rate FROM film ORDER BY rental_rate DESC LIMIT 1;
Kuris sakinys yra teisingas norint sugrupuoti filmus pagal rating ir suskaičiuoti kiek filmų turi kiekvienas reitingas?
SELECT rating, COUNT(*) FROM film SORT BY rating;
SELECT rating, COUNT(*) FROM film GROUP BY rating;
SELECT rating, COUNT(*) FROM film ORDER BY rating;
SELECT rating FROM film GROUP COUNT;
Kaip surūšiuoti customer lentelės klientus pagal pavardę (last_name) abėcėlės tvarka?
SELECT * FROM customer SORT BY last_name;
SELECT * FROM customer ORDER BY last_name ASC;
SELECT * FROM customer GROUP BY last_name;
SELECT * FROM customer ORDER last_name;
Kokia užklausa ištraukia visus filmus su nuomos kaina (rental_rate) tarp 2 ir 5?
SELECT * FROM film WHERE rental_rate = (2 TO 5);
SELECT * FROM film WHERE rental_rate BETWEEN 2 AND 5;
SELECT * FROM film WHERE rental_rate >= 2 AND rental_rate <= 5;
SELECT * FROM film HAVING rental_rate >= 2 AND rental_rate <= 5;
Kokia užklausa parodytų visų klientų, kurie darė užsakymus, skaičių?
SELECT COUNT(*) FROM customer WHERE EXISTS (SELECT * FROM rental);
SELECT COUNT(DISTINCT customer_id) FROM customer;
SELECT COUNT(DISTINCT customer_id) FROM rental;
SELECT customer_id FROM rental GROUP BY customer_id;
