Treehouse | Community | Using a Subquery to Create a Temporary Table (Part 1)

⚡ CYBER NOVEMBER SALE ⚡ 50% off any plan for 6 months, exclusive to new subscribers.

Join the Treehouse affiliate program and earn 25% recurring commission!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

John Munger
Data Analysis Techdegree Graduate 9,736 Points
dead link

Posted December 13, 2023 1:00am by John Munger

John Munger
Data Analysis Techdegree Graduate 9,736 Points
2 Answers
Mit Sengupta
13,823 Points
What am I doing wrong?

Posted March 10, 2016 4:13am by Mit Sengupta

Mit Sengupta
13,823 Points
- Databases
1 Answer
MOD

Jonathan Grieve
Treehouse Moderator 91,254 Points
Final Question of the Playground Practice

Posted March 4, 2016 5:40pm by Jonathan Grieve

Jonathan Grieve
Treehouse Moderator 91,254 Points
20 Answers
jason chan
31,009 Points
Count all the books in each genre. Include the genre column first and the genre_count as the second column of informatio

Posted March 2, 2016 10:50pm by jason chan

jason chan
31,009 Points
- Databases
1 Answer
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
How do we know what date the order was shipped on?

Posted March 1, 2016 12:19am by Brendan Whiting

Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
- Databases
13 Answers
filipepacheco
Full Stack JavaScript Techdegree Student 21,416 Points
Error Code: 1006. Can't create database

Posted February 29, 2016 10:52pm by filipepacheco

filipepacheco
Full Stack JavaScript Techdegree Student 21,416 Points
- Databases
3 Answers
Josh Overly
6,720 Points
Why doesn't this work?

Posted February 29, 2016 5:22am by Josh Overly

Josh Overly
6,720 Points
- Databases
1 Answer
james white
78,399 Points
SQL Error: no such column: first_name [RESOLVED]

Posted February 26, 2016 4:59pm by james white

james white
78,399 Points
- Databases
7 Answers
Bill Ertle
9,286 Points
MySQL

Posted February 26, 2016 2:46am by Bill Ertle

Bill Ertle
9,286 Points
- Databases
2 Answers
jcorum
71,830 Points
Reporting With SQL Challenge Task 2 of 2

Posted February 25, 2016 11:51pm by jcorum

jcorum
71,830 Points
- Databases
2 Answers
Bill Ertle
9,286 Points
mySQL

Posted February 25, 2016 12:37am by Bill Ertle

Bill Ertle
9,286 Points
- Databases
3 Answers
Deepak Rohan Sekar
9,634 Points
Add foreign key and constraints Databases

Posted February 20, 2016 11:01pm by Deepak Rohan Sekar

Deepak Rohan Sekar
9,634 Points
- Databases
1 Answer
Bill Ertle
9,286 Points
using an inner join in database foundations

Posted February 20, 2016 4:02am by Bill Ertle

Bill Ertle
9,286 Points
- Databases
5 Answers
Abhishek Bhardwaj
3,316 Points
window installation

Posted February 18, 2016 1:25pm by Abhishek Bhardwaj

Abhishek Bhardwaj
3,316 Points
3 Answers
Robert Close
3,383 Points
Noticed something odd

Posted February 16, 2016 4:16pm by Robert Close

Robert Close
3,383 Points
2 Answers
Ramon Carvalho
2,910 Points
Can't see where the code is wrong

Posted February 11, 2016 1:51am by Ramon Carvalho

Ramon Carvalho
2,910 Points
- Databases
7 Answers
MOD

Jonathan Grieve
Treehouse Moderator 91,254 Points
I've selected all the columns required but the task won't pass.

Posted February 9, 2016 5:36pm by Jonathan Grieve

Jonathan Grieve
Treehouse Moderator 91,254 Points
- Databases
1 Answer
Tomas Barazza
6,554 Points
the challenge is unclear

Posted February 8, 2016 11:28pm by Tomas Barazza

Tomas Barazza
6,554 Points
- Databases
2 Answers
PLUS

Rasbin Rijal
Courses Plus Student 10,864 Points
Concatenate first_name and last_name in mysql

Posted February 7, 2016 8:40pm by Rasbin Rijal

Rasbin Rijal
Courses Plus Student 10,864 Points
- Databases
1 Answer
Adiv Abramson
6,919 Points
I don't know why the parser says my query has a problem

Posted February 4, 2016 4:14am by Adiv Abramson

Adiv Abramson
6,919 Points
- Databases
1 Answer
Edgar Mantes
9,499 Points
Why doesn't the question specify where to move the file? I feel like there is not enough info to answer the question

Posted February 1, 2016 8:25pm by Edgar Mantes

Edgar Mantes
9,499 Points
- Databases
1 Answer
Andrew Lenti
Front End Web Development Techdegree Student 7,193 Points
Strategy in becoming a dynamic web based software programmer

Posted January 29, 2016 9:16am by Andrew Lenti

Andrew Lenti
Front End Web Development Techdegree Student 7,193 Points
- Databases
1 Answer
MOD

Iain Simmons
Treehouse Moderator 32,305 Points
BETWEEN is inclusive

Posted January 27, 2016 1:58am by Iain Simmons

Iain Simmons
Treehouse Moderator 32,305 Points
2 Answers
furkan ozcan
204 Points
how to get 2 columns instead of 5 columns when using SELECT and FROM keywords to get data from database?(resolved)

Posted January 22, 2016 6:43pm by furkan ozcan

furkan ozcan
204 Points
- Databases
2 Answers
Borislav Parov
626 Points
Challenge Task 1. Need help with the SQL query

Posted December 17, 2015 5:17am by Borislav Parov

Borislav Parov
626 Points
- Databases
6 Answers
Daniel Malek
20,140 Points
FOREIGN KEY

Posted December 7, 2015 9:52pm by Daniel Malek

Daniel Malek
20,140 Points
- Databases
1 Answer

Prev Page 107 of 389 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.