Treehouse | Community |

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

Join our free workshop and get a Treehouse discount code! 💼 Register here!

New No-Code Track! 🚀 New videos dropping every week—start learning today!

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
Michael Nanni
7,358 Points
Am I on the right track? Counting non-returned loans for all library patrons.

Posted March 18, 2019 5:50pm by Michael Nanni

Michael Nanni
7,358 Points
- Databases
4 Answers
Ker Sing Tan
10,573 Points
solve missing where cause error

Posted March 17, 2019 7:42am by Ker Sing Tan

Ker Sing Tan
10,573 Points
1 Answer
Michael Venner
351 Points
What is wrong with my SQL code ``` SELECT * FROM results WHERE away_team = Hessle AND away_score > 18; ```

Posted March 15, 2019 9:36pm by Michael Venner

Michael Venner
351 Points
1 Answer
Michael Nanni
7,358 Points
How do I filter query results between a range of starting letters?

Posted March 15, 2019 2:12am by Michael Nanni

Michael Nanni
7,358 Points
1 Answer
Ker Sing Tan
10,573 Points
Challenge 2 of 3 error

Posted March 13, 2019 10:38am by Ker Sing Tan

Ker Sing Tan
10,573 Points
3 Answers
sulaiman abouabdah
5,314 Points
Error when inserting my own table on my command line message ERROR 1064 (42000): You have an error in your SQL syntax;

Posted March 12, 2019 9:15pm by sulaiman abouabdah

sulaiman abouabdah
5,314 Points
1 Answer
Ker Sing Tan
10,573 Points
Code Challenge: Task 1 of 1

Posted March 12, 2019 3:28pm by Ker Sing Tan

Ker Sing Tan
10,573 Points
3 Answers
sulaiman abouabdah
5,314 Points
Download Link for the databases

Posted March 12, 2019 1:22pm by sulaiman abouabdah

sulaiman abouabdah
5,314 Points
3 Answers
Zoe Dadian
177 Points
im not sure what Im doing wrong here

Posted March 11, 2019 3:17am by Zoe Dadian

Zoe Dadian
177 Points
1 Answer
Michael Cook
Full Stack JavaScript Techdegree Graduate 28,975 Points
How to return all names in a table, and truncate only names greater than 10 characters?

Posted March 9, 2019 4:00pm by Michael Cook

Michael Cook
Full Stack JavaScript Techdegree Graduate 28,975 Points
- Databases
1 Answer
Hans Eisenman
1,315 Points
Having a little trouble with this derived table query. Error I'm getting is just "Bummer: try again!" :-\

Posted March 7, 2019 4:57pm by Hans Eisenman

Hans Eisenman
1,315 Points
1 Answer
Shahrukh Siddiqui
2,698 Points
UNABLE TO WRITE THE QUERY

Posted March 6, 2019 5:51am by Shahrukh Siddiqui

Shahrukh Siddiqui
2,698 Points
1 Answer
Gia Hoang Nguyen
4,137 Points
How to reset the MakeID with the correct order ID?

Posted March 5, 2019 6:21am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
2 Answers
Alexandros Panayi
1,771 Points
Scaling result horizontally for books

Posted March 4, 2019 7:47pm by Alexandros Panayi

Alexandros Panayi
1,771 Points
- Databases
1 Answer
Eniola Tijani
3,440 Points
sql query

Posted March 1, 2019 1:06pm by Eniola Tijani

Eniola Tijani
3,440 Points
- Databases
1 Answer
Satyam garhewal
326 Points
Why my query is not working, can you please help me out?

Posted March 1, 2019 5:46am by Satyam garhewal

Satyam garhewal
326 Points
2 Answers
Øystein Kallset
11,044 Points
What is wrong with this SQL-statement: SELECT REPLACE(email,"@","<at>") FROM customers

Posted February 28, 2019 7:43am by Øystein Kallset

Øystein Kallset
11,044 Points
1 Answer
lucas caldeira
1,592 Points
Is there a better way to do this ? this doesn't feel right !

Posted February 26, 2019 5:08pm by lucas caldeira

lucas caldeira
1,592 Points
- Databases
1 Answer
Kyle St Jean St Jean
220 Points
i have the " FROM results " typed in for this challenge and it's giving me a prompt that I'm not selecting from results

Posted February 24, 2019 2:14am by Kyle St Jean St Jean

Kyle St Jean St Jean
220 Points
1 Answer
PLUS

Patrick Maxwell
Courses Plus Student 6,249 Points
trouble understanding declaring SELECT * FORM comments!!?

Posted February 24, 2019 1:47am by Patrick Maxwell

Patrick Maxwell
Courses Plus Student 6,249 Points
1 Answer

Prev Page 26 of 389 Next

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