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


#1

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.


#2

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.


#3

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