22.08.2024

0

Like

23

Views

SQL Ödev 12

  • film tablosunda film uzunluğu length sütununda gösterilmektedir. Uzunluğu ortalama film uzunluğundan fazla kaç tane film vardır?
SELECT COUNT(*) AS count_above_average_length FROM film WHERE length > (SELECT AVG(length) FROM film);
  • film tablosunda en yüksek rental_rate değerine sahip kaç tane film vardır?
SELECT COUNT(*) AS count_highest_rental_rate FROM film WHERE rental_rate = (SELECT MAX(rental_rate) FROM film);
  • film tablosunda en düşük rental_rate ve en düşük 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);
  • payment tablosunda en fazla sayıda alışveriş yapan müşterileri(customer) sıralayınız.
SELECT customer, COUNT(*) AS payment_count FROM payment GROUP BY customer ORDER BY payment_count DESC;
SQL

Comments

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

© 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.