Treehouse | Community | Changing Cases of Strings

💥 2026 New Year's Sale 💥 Take 50% off your first 6 months! (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Brian Ross
11,209 Points
Getting a weird error: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001".

Posted August 26, 2018 11:04pm by Brian Ross

Brian Ross
11,209 Points
5 Answers
jon snow
1,774 Points
which database treehouse playground uses?

Posted August 26, 2018 1:18am by jon snow

jon snow
1,774 Points
2 Answers
Emily V
8,553 Points
Finished SQL courses and loved it. Any book/resource recommendations?

Posted August 24, 2018 8:46pm by Emily V

Emily V
8,553 Points
- Databases
1 Answer
Shain Jones
1,315 Points
the code challenge is asking if I "selected results as my table." My code is SELECT * FROM results WHERE away_team<10;

Posted August 16, 2018 7:04pm by Shain Jones

Shain Jones
1,315 Points
3 Answers
kelvinvockins
6,906 Points
Reporting with sql, 2nd code challenge COUNT BY GROUP incorrect code

Posted August 16, 2018 6:48pm by kelvinvockins

kelvinvockins
6,906 Points
2 Answers
Amy Hsieh
6,023 Points
To generate a count of certain column. I can't see what's wrong with my SQL code

Posted August 14, 2018 11:30am by Amy Hsieh

Amy Hsieh
6,023 Points
1 Answer
Amy Hsieh
6,023 Points
Q: The page can display 20 entries, I am asked to display the 3rd page of results.

Posted August 12, 2018 7:21am by Amy Hsieh

Amy Hsieh
6,023 Points
1 Answer
victorvillaplana
11,582 Points
Problem with task 2 of 6

Posted August 5, 2018 4:03pm by victorvillaplana

victorvillaplana
11,582 Points
2 Answers
Robbie Thomas
31,093 Points
Getting the length of a string

Posted August 2, 2018 3:13pm by Robbie Thomas

Robbie Thomas
31,093 Points
1 Answer
PLUS

Tony Tomczeszyn
Courses Plus Student 2,919 Points
Databases

Posted July 26, 2018 3:55pm by Tony Tomczeszyn

Tony Tomczeszyn
Courses Plus Student 2,919 Points
- Databases
3 Answers
MUSTAFA TAHA
5,150 Points
why when I write this come I get error what is the wrong? SELECT * FROM results WHERE home_team > 12;

Posted July 25, 2018 8:05pm by MUSTAFA TAHA

MUSTAFA TAHA
5,150 Points
2 Answers
PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
SQL Challenge task issue

Posted July 16, 2018 10:33am by Takyi Akwah

Takyi Akwah
Courses Plus Student 1,049 Points
3 Answers
tonyhan
31,188 Points
CREATE TABLE ROCKS (ID PRIMARY KEY, NAME, TYPE, COLOR) doesn't seem to work, it just return's SQL Error

Posted July 12, 2018 3:07am by tonyhan

tonyhan
31,188 Points
2 Answers
Brandyn Lordi
17,778 Points
Solved but... Are these challenges possible without derived tables?

Posted July 11, 2018 4:15am by Brandyn Lordi

Brandyn Lordi
17,778 Points
- Databases
1 Answer
Olga Ivancic
8,137 Points
Double or single quotes? And What is the difference between INTEGER and INT?

Posted July 6, 2018 11:24am by Olga Ivancic

Olga Ivancic
8,137 Points
- Databases
2 Answers
Hakim Rachidi
38,491 Points
Sql Transactions?

Posted July 2, 2018 9:06am by Hakim Rachidi

Hakim Rachidi
38,491 Points
1 Answer
Hanna Han
4,105 Points
Type of relationships among three different table in Tack #3

Posted June 27, 2018 6:21am by Hanna Han

Hanna Han
4,105 Points
1 Answer
Christopher Parke
21,978 Points
Movie Ratings Question Confusing

Posted June 21, 2018 4:15pm by Christopher Parke

Christopher Parke
21,978 Points
2 Answers
joshua inyang
948 Points
Hello I'm a not understanding this can someone assist I thought this was saying to concatenate first, last, email?

Posted June 19, 2018 4:58pm by joshua inyang

joshua inyang
948 Points
3 Answers
Christopher Parke
21,978 Points
No error, but error?

Posted June 18, 2018 5:04pm by Christopher Parke

Christopher Parke
21,978 Points
3 Answers
Hanna Han
4,105 Points
Does length count in white space in syntax?

Posted June 13, 2018 12:28pm by Hanna Han

Hanna Han
4,105 Points
1 Answer
Lisa Simpson
33,351 Points
Concatination

Posted June 12, 2018 10:05am by Lisa Simpson

Lisa Simpson
33,351 Points
1 Answer
Martin Coutts
18,154 Points
Connect failed

Posted June 6, 2018 7:00am by Martin Coutts

Martin Coutts
18,154 Points
3 Answers
doesitmatter
12,885 Points
SELECT COUNT(platform) FROM games

Posted May 28, 2018 9:07am by doesitmatter

doesitmatter
12,885 Points
1 Answer
Kimberly Johns
909 Points
Reporting with SQL Challenge Task

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

Kimberly Johns
909 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
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
Ailun Shen
4,874 Points
I tried LIKE '[a-k]%' I tried where Name >= 'A' and Name <= 'K' I give up

Posted December 12, 2017 10:03pm by Ailun Shen

Ailun Shen
4,874 Points
- Databases
3 Answers
dierkpolzin
7,380 Points
Create a list of all fruits and vegetables starting with the letters A through K . SQL Fails

Posted September 23, 2016 6:00pm by dierkpolzin

dierkpolzin
7,380 Points
- Databases
3 Answers

Prev Page 337 of 389 Next

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