datacamp-logo
Course Outline
BETA
Exercise

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.

Instructions 1/3
XP
  • 1
  • 2
  • 3
  • Select the first and last name from the Customer table and the Total amount spent from the Invoice table.
  • Perform an inner join between Customer and Invoice using the CustomerId column.
    Take Hint (-10 XP)