20.08.2024

0

Like

27

Views

SQL Ödev 1

  • film tablosunda bulunan title ve description sütunlarındaki verileri sıralayınız:
SELECT title, description FROM film ORDER BY title, description;
  • film tablosunda bulunan tüm sütunlardaki verileri film uzunluğu (length) 60 dan büyük VE 75 ten küçük olma koşullarıyla sıralayınız.
SELECT * FROM film WHERE length > 60 AND length < 75;
  • film tablosunda bulunan tüm sütunlardaki verileri rental_rate 0.99 VE replacement_cost 12.99 VEYA 28.99 olma koşullarıyla sıralayınız.
SELECT * FROM film WHERE rental_rate = 0.99 AND (replacement_cost = 12.99 OR replacement_cost = 28.99);
  • customer tablosunda bulunan first_name sütunundaki değeri 'Mary' olan müşterinin last_name sütunundaki değeri nedir?
SELECT last_name FROM customer WHERE first_name = 'Mary';
  • film tablosundaki uzunluğu(length) 50 ten büyük OLMAYIP aynı zamanda rental_rate değeri 2.99 veya 4.99 OLMAYAN verileri sıralayınız.
SELECT * FROM film WHERE length <= 50 AND rental_rate NOT IN (2.99, 4.99);
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.