21.08.2024

0

Beğenme

18

Görüntülenme

SQL Ödev 10

  • city tablosu ile country tablosunda bulunan şehir (city) ve ülke (country) isimlerini birlikte görebileceğimiz LEFT JOIN sorgusunu yazınız.
SELECT city.city, country,country FROM city LEFT JOIN country ON city.country_id = country.country_id;
  • customer tablosu ile payment tablosunda bulunan payment_id ile customer tablosundaki first_name ve last_name isimlerini birlikte görebileceğimiz RIGHT JOIN sorgusunu yazınız.
SELECT payment.payment_id, customer.first_name, customer.last_name FROM payment RIGHT JOIN customer ON payment.customer_id = customer.customer_id;
  • customer tablosu ile rental tablosunda bulunan rental_id ile customer tablosundaki first_name ve last_name isimlerini birlikte görebileceğimiz FULL JOIN sorgusunu yazınız.
SELECT rental.rental_id, customer.first_name, customer.last_name FROM rental FULL JOIN customer ON rental.customer_id = customer.customer_id;


SQL

Yorumlar

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

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.

Konum

Elazığ, TR

Eğitim

Elektrik - Elektronik Mühendisliği - Fırat Üniversitesi

İş Tecrübesi

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.