Apply best practices to your code

In this exercise you will update the code below to adhere to the best practices you learned in this chapter.

SELECT first_name, last_name, email FROM rental AS r 
-- FROM address AS a JOIN r.address_id = a.address_id
JOIN customer AS c ON r.customer_id = c.customer_id;

प्रश्न

What steps should you take here to adhere to the best practices you've learned in this chapter?

संभावित उत्तर

Avoid the common mistake of leaving in commented out code by removing it.

Make code easier to read by using new lines and indentation effectively.

Convey your intent by specifying the type of JOIN.

All of the above.