Learn SQL - Manipulation, exercise 2/10. what to do in this exercise?

Using the tables displayed, what is the description of the magazine ordered in order 1?

Type your answer on line 1 of the code editor. Be sure to capitalize it the same as in the table

https://www.codecademy.com/courses/learn-sql-multiple-tables/lessons/multiple-tables/exercises/what-is-join?action=resume_content_item&course_redirect=learn-sql

Please, help me.
Alena.

1 Like

Examine the orders table and look up order_id for 1 then look down that row for the subscription_id. Now examine the subscriptions table and look up the row with that subscription id. In that row, copy the name in the description column for that id.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.