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

💥 2026 New Year's Sale 💥 Take 50% off your first 6 months! (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

PLUS

sir a
Courses Plus Student 3,692 Points
Bug when quering with derived tables

Posted June 18, 2017 10:42am by sir a

sir a
Courses Plus Student 3,692 Points
2 Answers
Kristen Wolff
9,550 Points
Counting shipped data from Yesterday

Posted June 17, 2017 3:19pm by Kristen Wolff

Kristen Wolff
9,550 Points
- Databases
0 Answers
Krishna Pratap Chouhan
15,203 Points
Are the Spaces before the SQL-query invalid?

Posted May 31, 2017 2:34pm by Krishna Pratap Chouhan

Krishna Pratap Chouhan
15,203 Points
- Databases
1 Answer
sumit garg
30 Points
Stuck in the problem

Posted May 23, 2017 1:22pm by sumit garg

sumit garg
30 Points
- Databases
0 Answers
leefaragher
Python Development Techdegree Student 18,868 Points
What's going wrong with my query?

Posted May 16, 2017 8:43pm by leefaragher

leefaragher
Python Development Techdegree Student 18,868 Points
- Databases
4 Answers
Jessica Carey
690 Points
SQL command error

Posted May 16, 2017 8:15pm by Jessica Carey

Jessica Carey
690 Points
- Databases
2 Answers
Stuart Guest-Smith
5,343 Points
Not sure what's wrong? - 'Your query needs to retrieve the earliest 'Science Fiction' book from the `books` table."

Posted May 6, 2017 11:10pm by Stuart Guest-Smith

Stuart Guest-Smith
5,343 Points
- Databases
3 Answers
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
Database setup help.

Posted May 5, 2017 6:52pm by Brendan Whiting

Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
- Databases
- Introduction to Window Functions
1 Answer
Sanjay Dulal
1,269 Points
We have an eCommerce database and it has a products table. It has the columns id, name, description and price.

Posted April 29, 2017 2:58pm by Sanjay Dulal

Sanjay Dulal
1,269 Points
- Databases
4 Answers
Igor Amidzic
3,052 Points
Reporting with SQL: task 1/2

Posted April 28, 2017 5:54pm by Igor Amidzic

Igor Amidzic
3,052 Points
- Databases
1 Answer
Dulsie fadzai Mudekwa
8,656 Points
We're using a database on a smartphone again. We have a phone_book table. In here there's an id, first_name, last_name a

Posted April 25, 2017 9:39am by Dulsie fadzai Mudekwa

Dulsie fadzai Mudekwa
8,656 Points
- Databases
0 Answers
Shailesh Kulkarni
314 Points
why is this code incorrect ?

Posted April 25, 2017 12:15am by Shailesh Kulkarni

Shailesh Kulkarni
314 Points
- Databases
1 Answer
Paul Ownby
23,414 Points
I cannot get a correct answer for Task #4 on the last Challenge for Querying Relational Databases. What's wrong?

Posted April 24, 2017 11:15pm by Paul Ownby

Paul Ownby
23,414 Points
- Databases
2 Answers
Matthew Francis
6,967 Points
How can I create an API using my SQL database?

Posted April 17, 2017 2:41am by Matthew Francis

Matthew Francis
6,967 Points
- Databases
2 Answers
Adriano De Oliveira
5,653 Points
select name from vegetable except fruit order by name asc;

Posted April 16, 2017 8:31pm by Adriano De Oliveira

Adriano De Oliveira
5,653 Points
- Databases
0 Answers
Adriano De Oliveira
5,653 Points
I am a bit confused, if there's some help in the community to solve this challenge I would be grateful. Thanks

Posted April 16, 2017 1:24pm by Adriano De Oliveira

Adriano De Oliveira
5,653 Points
- Databases
0 Answers
Adriano De Oliveira
5,653 Points
Hello ! I would like some help in this challange. thanks

Posted April 16, 2017 11:45am by Adriano De Oliveira

Adriano De Oliveira
5,653 Points
- Databases
3 Answers
Na Liu
2,753 Points
JOINing table challenge Task 1 of I, joining three tables??

Posted April 13, 2017 8:05pm by Na Liu

Na Liu
2,753 Points
- Databases
1 Answer
Joshua Hardy
17,317 Points
Assistance with code error.

Posted April 10, 2017 12:41am by Joshua Hardy

Joshua Hardy
17,317 Points
- Databases
1 Answer
Adriano De Oliveira
5,653 Points
i would like some help topic database paging through results!!!!!!!!!!!!!!!!

Posted March 30, 2017 3:01pm by Adriano De Oliveira

Adriano De Oliveira
5,653 Points
- Databases
2 Answers
Sean Loke
14,659 Points
STAGE 3: PRACTICE MOVIES BEGINNING WITH ALIEN AND WILL OF ACTORS

Posted March 29, 2017 4:17am by Sean Loke

Sean Loke
14,659 Points
- Databases
2 Answers
Joel McCracken Jr
3,142 Points
Relational Database Challenge Task 2 of 5: Bummer ambiguous column name Car.VIN

Posted March 24, 2017 6:44pm by Joel McCracken Jr

Joel McCracken Jr
3,142 Points
- Databases
3 Answers
PLUS

tonypitkin2
Courses Plus Student 1,950 Points
Can you combine a Substring and Replace function inside one another?

Posted March 22, 2017 12:10am by tonypitkin2

tonypitkin2
Courses Plus Student 1,950 Points
2 Answers
Jan Lundeen
6,201 Points
On SQL Playground, Stage 3, Practice, how do I calculate the average movie rating and round it to 1 decimal place?

Posted March 21, 2017 11:51pm by Jan Lundeen

Jan Lundeen
6,201 Points
3 Answers
Wiley Conte
9,618 Points
Looks like I've got it correct. What am I missing?

Posted March 16, 2017 11:43pm by Wiley Conte

Wiley Conte
9,618 Points
- Databases
0 Answers
Ginger Williams
6,409 Points
All databases listed are 0.000GB

Posted November 30, 2016 10:52pm by Ginger Williams

Ginger Williams
6,409 Points
2 Answers
Kristian Woods
23,414 Points
I don't fully understand how GROUB BY works...

Posted October 9, 2016 5:20pm by Kristian Woods

Kristian Woods
23,414 Points
4 Answers
Kristian Woods
23,414 Points
I don't understand the SQL REPLACE() function

Posted October 6, 2016 12:48pm by Kristian Woods

Kristian Woods
23,414 Points
7 Answers
Andreas Frost Nordstrøm-Hansen
2,443 Points
Need help on the SQL Playground. Movies with any missing data

Posted September 6, 2016 1:42pm by Andreas Frost Nordstrøm-Hansen

Andreas Frost Nordstrøm-Hansen
2,443 Points
5 Answers

Prev Page 321 of 389 Next

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