Treehouse | Community | Making Changes to a Database

💥 2026 New Year's Sale 💥 Take $20.26 off your first month on a monthly Courses or Courses Plus plan (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Dharmesh Nayee
1,090 Points
Why does my foreign key constrant not work?

Posted August 30, 2019 7:13pm by Dharmesh Nayee

Dharmesh Nayee
1,090 Points
3 Answers
Dharmesh Nayee
1,090 Points
I get the Bummer message saying that i need to add the 4 columns. What is wrong with my code?

Posted August 29, 2019 9:00pm by Dharmesh Nayee

Dharmesh Nayee
1,090 Points
3 Answers
Sung-Fu Han
3,890 Points
why the query won't work in task 2 of 3? SELECT * FROM　products WHERE price != 9.99;

Posted August 29, 2019 9:27am by Sung-Fu Han

Sung-Fu Han
3,890 Points
2 Answers
sevdiye ozlutas
1,453 Points
what should be the code for challenge 1 for finding the length of TEXT, I have tried different methods

Posted August 26, 2019 1:43pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the SQL code for challenge one? I have tried different ways but it keeps giving me an error

Posted August 26, 2019 12:52pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
3 Answers
sevdiye ozlutas
1,453 Points
I am struggling to write a query for this question. What is should be?

Posted August 26, 2019 11:09am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the code for this one? I have entered SELECT * FROM books ORDER BY first_published DSC;

Posted August 26, 2019 10:18am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
Paul Brubaker
14,290 Points
Forgot about HAVING keyword and came up with this monstrosity.

Posted August 26, 2019 3:37am by Paul Brubaker

Paul Brubaker
14,290 Points
3 Answers
Marcus Yang
7,476 Points
I don't know what's wrong with my SQL statement. Pls help!

Posted August 24, 2019 1:57pm by Marcus Yang

Marcus Yang
7,476 Points
2 Answers
Yung Kazi
6,997 Points
Keyword OFFSET I am actually confused about what OFFSET is doing. [SOLVED]

Posted August 24, 2019 5:35am by Yung Kazi

Yung Kazi
6,997 Points
2 Answers
Tommy Gebru
30,164 Points
Treehouse workspaces SQL playground

Posted August 23, 2019 4:08pm by Tommy Gebru

Tommy Gebru
30,164 Points
- Databases
0 Answers
Tommy Gebru
30,164 Points
Challenge Task 4 of 4 Bummer: SQL Error: near "SELECT": syntax error

Posted August 22, 2019 10:12pm by Tommy Gebru

Tommy Gebru
30,164 Points
2 Answers
shiny peanut
5,113 Points
AS Keyword in SQL

Posted August 18, 2019 4:02pm by shiny peanut

shiny peanut
5,113 Points
3 Answers
Yusuf Balogun
1,829 Points
In our e-commerce database we have a users table with the columns id, username, password, first_name and last_name.

Posted August 17, 2019 11:24pm by Yusuf Balogun

Yusuf Balogun
1,829 Points
1 Answer
sevdiye ozlutas
1,453 Points
What is the SQL code should be for question 5 about the results in Rugby Match?

Posted August 17, 2019 12:15pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
oliverchou
20,886 Points
Am I getting this right?

Posted August 15, 2019 12:04pm by oliverchou

oliverchou
20,886 Points
3 Answers
Gurveer Singh
11,382 Points
i can't understand this question

Posted August 15, 2019 3:04am by Gurveer Singh

Gurveer Singh
11,382 Points
2 Answers
Spencer Koss
1,404 Points
Capitalizing One Character in a variable from a Database

Posted August 12, 2019 7:50pm by Spencer Koss

Spencer Koss
1,404 Points
1 Answer
Cosmin Iuga
2,352 Points
Stuck here. Here's my answer so far.

Posted August 12, 2019 5:49pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
2 Answers
hassan oladini
1,579 Points
Challenge task

Posted August 11, 2019 3:58pm by hassan oladini

hassan oladini
1,579 Points
1 Answer
bright chibuike
3,245 Points
matching patter

Posted August 11, 2019 12:41am by bright chibuike

bright chibuike
3,245 Points
4 Answers
Erin DeSpain
6,763 Points
Question with Reporting with SQL Challenge 1/1 appears broken

Posted August 10, 2019 8:10pm by Erin DeSpain

Erin DeSpain
6,763 Points
2 Answers
Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
Join works in this example without specifying the columns to join

Posted August 8, 2019 12:07am by Jesse Dispoto

Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
0 Answers
Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
Replace question on SQL practice

Posted August 3, 2019 10:32pm by Jesse Dispoto

Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
4 Answers
Luis Garcia
Full Stack JavaScript Techdegree Graduate 22,338 Points
Reporting with SQL - Challenge question

Posted August 2, 2019 3:32pm by Luis Garcia

Luis Garcia
Full Stack JavaScript Techdegree Graduate 22,338 Points
- Databases
1 Answer
Emily Novakovich
175 Points
How can I code SQL in excel?

Posted August 1, 2019 8:47pm by Emily Novakovich

Emily Novakovich
175 Points
3 Answers
RYAN Anthony HARRIS
6,498 Points
This section made almost no sense and did not help me understand CTEs in the slightest.

Posted August 1, 2019 12:21am by RYAN Anthony HARRIS

RYAN Anthony HARRIS
6,498 Points
- Databases
- Using Multiple CTEs in a Query
4 Answers
Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
Is "committing" a statement different then executing or running a statement?

Posted July 31, 2019 9:55pm by Jesse Dispoto

Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
1 Answer
gerardo keys
14,292 Points
I don't really understand these two routes.

Posted July 31, 2019 12:58am by gerardo keys

gerardo keys
14,292 Points
- Databases
- Updating Entries in a Table
1 Answer
Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
Select all columns with missing data? Help

Posted July 29, 2019 8:40pm by Jesse Dispoto

Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
1 Answer

Prev Page 22 of 389 Next

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