04.07.2025

0

Beğenme

1

Görüntülenme

SQL Kursu Ödev 12

Aşağıdaki sorgu senaryolarını dvdrental örnek veri tabanı üzerinden gerçekleştiriniz.


1- film tablosunda film uzunluğu length sütununda gösterilmektedir. Uzunluğu ortalama film uzunluğundan fazla kaç tane film vardır?


SELECT COUNT(length) FROM film

WHERE length >

(

SELECT AVG(length) FROM film

);


2- film tablosunda en yüksek rental_rate değerine sahip kaç tane film vardır?


SELECT COUNT(rental_rate) FROM film

WHERE rental_rate = 

(

SELECT MAX(rental_rate) FROM film

);


3- film tablosunda en düşük rental_rate ve en düşün replacement_cost değerlerine sahip filmleri sıralayınız.


SELECT * FROM film

WHERE rental_rate = (SELECT MIN(rental_rate) FROM film) AND replacement_cost = (SELECT MIN(replacement_cost) FROM film);


4- payment tablosunda en fazla sayıda alışveriş yapan müşterileri(customer) sıralayınız.


SELECT payment.customer_id, customer.first_name, customer.last_name, COUNT(*) AS transaction_count

FROM payment

JOIN customer ON payment.customer_id = customer.customer_id

GROUP BY payment.customer_id, customer.first_name, customer.last_name

ORDER BY transaction_count DESC;

SQL

Yorumlar

Kullanıcı yorumlarını görüntüleyebilmek için kayıt olmalısınız!

Şen Ekin

SELECT meaning FROM life WHERE language = 'Python'; | def bio(): return "SQL lover. Python powered."

Konum

DE

© 2021 Patika Dev

facebook
twitter
instagram
youtube
linkedin

Disclaimer: The information /programs / events provided on https://patika.dev and https://risein.com are strictly for upskilling and networking purposes related to the technical infrastructure of blockchain platforms. We do not provide financial or investment advice and do not make any representations regarding the value, profitability, or future price of any blockchain or cryptocurrency. Users are encouraged to conduct their own research and consult with licensed financial professionals before engaging in any investment activities. https://patika.dev and https://risein.com disclaim any responsibility for financial decisions made by users based on information provided here.