Treehouse | Community | Updating Data

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

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

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

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Amelia Groen
6,144 Points
Using find() returns nothing with ObjectID

Posted May 23, 2018 2:17pm by Amelia Groen

Amelia Groen
6,144 Points
1 Answer
Ali Ahmadian
11,474 Points
what im doing wrong?please Help!

Posted May 22, 2018 8:56pm by Ali Ahmadian

Ali Ahmadian
11,474 Points
1 Answer
Troy Erby
6,332 Points
Having trouble with Reporting SQL with the REPLACE function

Posted May 22, 2018 1:29pm by Troy Erby

Troy Erby
6,332 Points
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
I tried with this query "SELECT SUBSTR(first_name, 1, 1) || " " || last_name AS initial FROM customers;" and return me "

Posted May 22, 2018 2:54am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
2 Answers
Stevan Lay
8,306 Points
What is the correct syntax here?

Posted May 21, 2018 1:42am by Stevan Lay

Stevan Lay
8,306 Points
1 Answer
Terri Valentine
23,034 Points
SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")

Posted May 20, 2018 12:40am by Terri Valentine

Terri Valentine
23,034 Points
1 Answer
Alexander Solberg
14,350 Points
Can't enter "{}" in MongoDB Shell

Posted May 19, 2018 8:23pm by Alexander Solberg

Alexander Solberg
14,350 Points
0 Answers
John Tester
3,366 Points
SQL Reporting ecommerce challenge; concatenate

Posted May 14, 2018 2:19pm by John Tester

John Tester
3,366 Points
1 Answer
Hani AMer
946 Points
Live Data Preview

Posted May 14, 2018 7:46am by Hani AMer

Hani AMer
946 Points
- Databases
1 Answer
Ahmed Mohamed Fouad
11,735 Points
My Code for this lesson using CTE

Posted May 14, 2018 5:12am by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
0 Answers
Ahmed Mohamed Fouad
11,735 Points
When Writing "Join" only, is it the inner, left, or outer one ?

Posted May 13, 2018 11:52pm by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
- Databases
- Using Multiple CTEs in a Query
1 Answer
Philip Schultz
11,437 Points
Why does UNION ALL work in this case and not just UNION

Posted May 13, 2018 1:10pm by Philip Schultz

Philip Schultz
11,437 Points
2 Answers
Jason Tabaczynski
3,177 Points
Can't create table with the CREATE TABLE command

Posted May 12, 2018 6:56pm by Jason Tabaczynski

Jason Tabaczynski
3,177 Points
1 Answer
Ahmed Mohamed Fouad
11,735 Points
SQL Playground - Set Operations Practice (second question)

Posted May 10, 2018 9:01pm by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
7 Answers
Valerie Don
1,438 Points
Not sure what I'm missing or misplacing? SELECT*FROM results WHERE away_team = "Hessle" > 18 AND away_score > 18;

Posted May 10, 2018 6:08pm by Valerie Don

Valerie Don
1,438 Points
- Databases
1 Answer
Patricia Hector
42,901 Points
Issue with DB working locally with phpmyadmin [SOLVED]

Posted May 10, 2018 1:01pm by Patricia Hector

Patricia Hector
42,901 Points
0 Answers
Christopher Phillips
10,061 Points
Query not correct, but visually, it is returning precisely what is asked. What gives?

Posted May 10, 2018 12:40pm by Christopher Phillips

Christopher Phillips
10,061 Points
- Databases
1 Answer
ABRAHAM NYONI
9,692 Points
Can someone help me on this challenge on SQL,CALCULATING DATES.

Posted May 10, 2018 10:03am by ABRAHAM NYONI

ABRAHAM NYONI
9,692 Points
8 Answers
PLUS

Gustavo Winter
Courses Plus Student 27,382 Points
What is the difference between this two Queries ? Sqlite

Posted May 10, 2018 2:40am by Gustavo Winter

Gustavo Winter
Courses Plus Student 27,382 Points
- Databases
1 Answer
John Tester
3,366 Points
longest length

Posted May 9, 2018 9:41pm by John Tester

John Tester
3,366 Points
2 Answers
Ahmed Mohamed Fouad
11,735 Points
A technical problem with the Challenge task 2 of 5

Posted May 8, 2018 9:53pm by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
3 Answers
Hatem Zreek
7,739 Points
Mistake in the Challenge!!!

Posted May 8, 2018 1:23am by Hatem Zreek

Hatem Zreek
7,739 Points
1 Answer
Earlon Perry
4,304 Points
Need help with Adding Data with SQL objectives. I can not get the objectives right.

Posted May 7, 2018 9:50pm by Earlon Perry

Earlon Perry
4,304 Points
1 Answer
Alexander Salako
360 Points
Find all users 2

Posted May 7, 2018 7:06pm by Alexander Salako

Alexander Salako
360 Points
- Databases
1 Answer
Alexander Salako
360 Points
Query

Posted May 7, 2018 1:50pm by Alexander Salako

Alexander Salako
360 Points
- Databases
1 Answer
Alexander Salako
360 Points
find all users

Posted May 7, 2018 12:59pm by Alexander Salako

Alexander Salako
360 Points
- Databases
1 Answer
Angelo Martin
6,373 Points
Get error " Did you select from the `results` table? " Not sure why...

Posted May 6, 2018 7:48pm by Angelo Martin

Angelo Martin
6,373 Points
- Databases
1 Answer
Adrian Brenton
8,110 Points
Please advise on this SQL code - thank you!

Posted May 5, 2018 6:10am by Adrian Brenton

Adrian Brenton
8,110 Points
- Databases
3 Answers
PLUS

Nancy Melucci
Courses Plus Student 36,143 Points
Join two tables with no common attributes

Posted May 4, 2018 1:46pm by Nancy Melucci

Nancy Melucci
Courses Plus Student 36,143 Points
- Databases
2 Answers
James Peach
8,019 Points
I'm not even sure what's going on here. The results are exactly what the question is asking me for but it's still wrong.

Posted May 1, 2018 5:47pm by James Peach

James Peach
8,019 Points
- Databases
1 Answer

Prev Page 42 of 388 Next

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