Using USING
eSymphony wants to thank their most loyal customer by sending them a gift card. You are tasked with identifying the customer that has spent the most money at the company.
You are not sure what convention the person that will be running your query prefers, so you decide to show your SQL skills by using the USING clause as well as ON in your join.
Bu egzersiz
Introduction to Oracle SQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Select the customer first and last name, and the total amount
SELECT ___, ___, ___
-- Join the Customer and the Invoice tables
FROM Customer c ___
-- Complete the common joining column
ON ___ = ___