FAQ: Multiple Tables - Introduction

This community-built FAQ covers the “Introduction” exercise from the lesson “Multiple Tables”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Web Development
Data Science

Learn SQL

FAQs on the exercise Introduction

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

Is there a way to group the select statement rather than simply typing out select * from … 3 times? Something along the lines of select * from (table1, table2, table3) limit 5;?

I tried it but the checkbox doesn’t like it and I don’t know if it’s because my syntax is off (but still got results) or whether it is validating only against the statement it wants you to simply copy paste.

4 Likes

Hello Codecademy Forum.

I was wondering if it is possible to give each table a header? I tried using the AS alias on “FROM table_foo” with no joy for my desired output.

Thanks if anybody can understand what I’m asking for.

Martin

1 Like

I get weird results when filtering the querie to only give subscriptions greaten than 10 or 6 months
For example this is an example:

SELECT DISTINCT subscription_length
, customer_name
FROM subscriptions
CROSS JOIN customers cu
WHERE subscription_length > 10 --It should only give the 12 months subs but instead I get everything 3,6 and 12 months
Could you explain why please?

Why is the date format of the purchase_date column mm-dd-yyyy, instead of the standard yyyy-mm-dd?