Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Querying Relational Databases Subqueries Review and Practice

Posted by James Kruk
James Kruk
1,600 Points

Is there a way to access solutions for the 'Review and Practice' challenges in the 'Launch SQL Playgrounds'?

I am having a tough time completing these challenges and I think having access to the solutions will definitely help me learn faster.

2 Answers

Steven Parker
Steven Parker
231,269 Points
Steven Parker
Steven Parker
231,269 Points

For just a few of these, the solutions are shown in the video. The rest are just provided as practice exercises.

There is no "answer key", plus there's often more than one possible correct solution.

Carlos Reyes
Carlos Reyes
30,056 Points
Carlos Reyes
Carlos Reyes
30,056 Points

I was about to give up, a picture of the final report would be nice.

I could count the 30 books in both locations, and also the 18 unique titles.

It was hard to make the report in the form of two columns, one with title and the next with the count of the title.

What helped to finished it, was to understand the alias needed in the reports we create, after from, create a report(like usual) and don't forget the alias.

Or first create a report and copy/paste it after the from + alias.