Treehouse | Community | Changing Cases of Strings

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

New No-Code Track! 🚀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

Kimberly Johns
909 Points
Reporting with SQL Challenge Task

Posted May 24, 2018 6:08pm by Kimberly Johns

Kimberly Johns
909 Points
2 Answers
Troy Erby
6,332 Points
Trouble inserting Primary Key

Posted May 24, 2018 5:29pm by Troy Erby

Troy Erby
6,332 Points
2 Answers
James Ramsey
15,948 Points
SHIFT + ENTER

Posted May 24, 2018 2:09pm by James Ramsey

James Ramsey
15,948 Points
2 Answers
Fathima Fas-ha
6,847 Points
Reporting with SQL

Posted May 24, 2018 9:47am by Fathima Fas-ha

Fathima Fas-ha
6,847 Points
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
Trouble with Challenge on Min Max values for Query

Posted May 24, 2018 3:15am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
1 Answer
Noel Thurau
1,021 Points
I'm having trouble with 2 of the quizzes.

Posted May 23, 2018 9:57pm by Noel Thurau

Noel Thurau
1,021 Points
1 Answer
Kareem Jeiroudi
14,984 Points
Anyone had the problem that it kept adding the values 500 and -10, even after setting `PRAGMA FOREIGN_KEYS = on;`

Posted May 23, 2018 5:51pm by Kareem Jeiroudi

Kareem Jeiroudi
14,984 Points
4 Answers
Mark Mazur Lussenburg
25,338 Points
Challenge task 2 relational databases SET OPERATIONS

Posted May 23, 2018 2:42pm by Mark Mazur Lussenburg

Mark Mazur Lussenburg
25,338 Points
2 Answers
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,902 Points
Issue with DB working locally with phpmyadmin [SOLVED]

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

Patricia Hector
42,902 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

Prev Page 42 of 389 Next

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