Treehouse | Community |

💫 Take our 2024 Developer Survey and enter to win a FREE Techdegree! 🏆

Join our Live Career-Building Workshop: How to Master the Job Hunt! ⭐ Register here!

🏛️ Access Treehouse at your local library for free! Check out Treehouse Near Me.

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

Join our free community Discord server here!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Muhittin Palamutçu
1,890 Points
I need some help for my Sql Query

Posted April 11, 2019 8:57pm by Muhittin Palamutçu

Muhittin Palamutçu
1,890 Points
- Databases
2 Answers
sj sh
122 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted April 11, 2019 8:37am by sj sh

sj sh
122 Points
0 Answers
Aaron Howarth
169 Points
What am I missing here with my syntax?

Posted April 10, 2019 6:53pm by Aaron Howarth

Aaron Howarth
169 Points
1 Answer
Ikechukwu Arum
5,337 Points
ERROR: NO SUCH COLUMN

Posted April 9, 2019 6:41pm by Ikechukwu Arum

Ikechukwu Arum
5,337 Points
3 Answers
PLUS

kevin hudson
Courses Plus Student 11,987 Points
No Help needed but want to share Code with mistakes

Posted April 9, 2019 3:58pm by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
0 Answers
PLUS

kevin hudson
Courses Plus Student 11,987 Points
Is it a bad approach to use subqueries over CTE and JOINING?

Posted April 8, 2019 6:20pm by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
2 Answers
PLUS

kevin hudson
Courses Plus Student 11,987 Points
What is penultimate?

Posted April 8, 2019 3:51pm by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
1 Answer
PLUS

kevin hudson
Courses Plus Student 11,987 Points
The first challenge should include GROUP BY

Posted April 8, 2019 2:51pm by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
5 Answers
Luitzen Hietkamp
7,593 Points
Actor table too large

Posted April 7, 2019 2:15pm by Luitzen Hietkamp

Luitzen Hietkamp
7,593 Points
- Databases
0 Answers
Marat Guysin
1,601 Points
Cannot get the right SQL statement

Posted April 6, 2019 11:28pm by Marat Guysin

Marat Guysin
1,601 Points
1 Answer
PLUS

kevin hudson
Courses Plus Student 11,987 Points
Is there an advanced SQL track to follow later on after the beginner's track?

Posted April 5, 2019 1:29am by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
1 Answer
Ikechukwu Arum
5,337 Points
related to the subquery challenge using the "IN" Keyword

Posted April 4, 2019 6:40pm by Ikechukwu Arum

Ikechukwu Arum
5,337 Points
1 Answer
Francesco Sollitto
2,454 Points
I HAVE ADDED THE PRIMARY KEY ON ID, WHY YOU KEEP REPEATING THE SAME BUMMER????

Posted April 4, 2019 9:03am by Francesco Sollitto

Francesco Sollitto
2,454 Points
1 Answer
Luke Rohm
4,679 Points
SQL error for selecting all data from customer_address

Posted April 4, 2019 2:54am by Luke Rohm

Luke Rohm
4,679 Points
1 Answer
Elise Glynn
529 Points
Why and when would we need to use aliases?

Posted April 2, 2019 3:36pm by Elise Glynn

Elise Glynn
529 Points
1 Answer
Abdullah Salman
6,461 Points
Quiz - Modifying Data with SQL

Posted April 2, 2019 12:38pm by Abdullah Salman

Abdullah Salman
6,461 Points
1 Answer
Chamundeshwari Vadamalai
2,204 Points
How to format the dates?

Posted April 2, 2019 11:46am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer
adam woolf
1,181 Points
select SUM(rating) AS starman_total_ratings From reviews WHERE movie_id="Starman" it says i did not sum correctly

Posted April 2, 2019 4:39am by adam woolf

adam woolf
1,181 Points
1 Answer
Ilya Kotlyar
2,258 Points
Is there a track on online databases?

Posted March 31, 2019 1:18am by Ilya Kotlyar

Ilya Kotlyar
2,258 Points
- Databases
1 Answer
Apoorva Seeram
790 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted March 28, 2019 8:09pm by Apoorva Seeram

Apoorva Seeram
790 Points
2 Answers
Yelson Yang
3,983 Points
How to select all row with missing values?

Posted March 28, 2019 3:48pm by Yelson Yang

Yelson Yang
3,983 Points
- Databases
1 Answer
Gia Hoang Nguyen
4,137 Points
How to find the discrepancy between the current grade 7 students and the future grade 6 students who move to grade 7?

Posted March 27, 2019 3:28am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
1 Answer
Michael Nanni
7,358 Points
Does grade level matter to find which subject is least popular?

Posted March 26, 2019 12:49pm by Michael Nanni

Michael Nanni
7,358 Points
- Databases
1 Answer
taherkhan
4,327 Points
Query regarding calculating average

Posted March 24, 2019 9:46am by taherkhan

taherkhan
4,327 Points
1 Answer
Michael Nanni
7,358 Points
My answer to the challenge. Let me know what you think.

Posted March 23, 2019 9:20pm by Michael Nanni

Michael Nanni
7,358 Points
- Databases
1 Answer
Brian Poirier
7,678 Points
select fruit and vegetables. what's wrong with this? SELECT * FROM fruit UNION SELECT * FROM vegetable

Posted March 22, 2019 2:25am by Brian Poirier

Brian Poirier
7,678 Points
1 Answer
Robert Hecht
6,797 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

Posted March 20, 2019 2:54pm by Robert Hecht

Robert Hecht
6,797 Points
1 Answer
pra saw
233 Points
stuck

Posted March 20, 2019 11:29am by pra saw

pra saw
233 Points
1 Answer
Sharon Watmai
1,451 Points
Modifying sql data

Posted March 20, 2019 10:11am by Sharon Watmai

Sharon Watmai
1,451 Points
1 Answer
David Wells
13,270 Points
In the second question of the library/full name question, how do I write the concatenation SQL statement?

Posted March 19, 2019 5:54pm by David Wells

David Wells
13,270 Points
2 Answers

Prev Page 25 of 388 Next

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