22.08.2024
0
Like
28
Views
SELECT COUNT(*) AS count_above_average_length FROM film WHERE length > (SELECT AVG(length) FROM film);
SELECT COUNT(*) AS count_highest_rental_rate FROM film WHERE rental_rate = (SELECT MAX(rental_rate) FROM film);
SELECT * FROM film WHERE rental_rate = (SELECT MIN(rental_rate) FROM film) AND replacement_cost = (SELECT MIN(replacement_cost) FROM film);
SELECT customer, COUNT(*) AS payment_count FROM payment GROUP BY customer ORDER BY payment_count DESC;
You need to log in to be able to comment!
Kenan Ayberk Özkan
I’m looking for places where I can use my interest in software or design, improve my existing skills and myself, especially add new talents to shape my business life.
Location
Elazığ, TR
Education
Elektrik - Elektronik Mühendisliği - Fırat Üniversitesi
Job Experience
INTERN - EÜAŞ KEBAN DAM
INTERN R&D - MOSAŞ GROUP
INTERN EMBEDDED SYSTEMS - PAVOTEK