Treehouse | Community | Changing Cases of Strings

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

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

🌟 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

Shain Jones
1,315 Points
Reporting with SQL

Posted October 17, 2018 5:34pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Shain Jones
1,315 Points
Concatenation of name and email, where have I went wrong?

Posted October 16, 2018 1:45pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Sandeep Padda
2,781 Points
please help!

Posted October 16, 2018 1:42am by Sandeep Padda

Sandeep Padda
2,781 Points
4 Answers
Sandeep Padda
2,781 Points
Help with this question?

Posted October 16, 2018 12:53am by Sandeep Padda

Sandeep Padda
2,781 Points
1 Answer
Fairooz Adams
2,704 Points
What to do here?

Posted October 14, 2018 8:07pm by Fairooz Adams

Fairooz Adams
2,704 Points
2 Answers
Fairooz Adams
2,704 Points
Unable to solve...

Posted October 14, 2018 3:54am by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
Fairooz Adams
2,704 Points
Can't solve, stuck:

Posted October 14, 2018 3:36am by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
Loy Yee Ko
5,814 Points
SELECT * FROM books WHERE genre ORDER BY first_published ASC LIMIT 5; fail to return any result

Posted October 13, 2018 4:47pm by Loy Yee Ko

Loy Yee Ko
5,814 Points
1 Answer
Jamie Sims
4,317 Points
I'm not sure how I should treat my SQL Statement.

Posted October 9, 2018 6:03pm by Jamie Sims

Jamie Sims
4,317 Points
1 Answer
Ross O'Neill
2,884 Points
stuck on this challenge

Posted October 9, 2018 12:07pm by Ross O'Neill

Ross O'Neill
2,884 Points
0 Answers
Marinko Klac
1,165 Points
Getting the right result, but program doesn't approve it.

Posted October 8, 2018 4:04pm by Marinko Klac

Marinko Klac
1,165 Points
2 Answers
Raymond Moore
Full Stack JavaScript Techdegree Student 11,174 Points
SQL Query ?

Posted October 6, 2018 11:01pm by Raymond Moore

Raymond Moore
Full Stack JavaScript Techdegree Student 11,174 Points
1 Answer
Shain Jones
1,315 Points
Unsure how to fix the code as the ORDERED BY is there. How can I fix this? Thanks in advance.

Posted October 5, 2018 8:00pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Karen Shumate
13,579 Points
Count the total number of orders that were ordered yesterday and have the status of 'shipped'. Alias it to ordered_yeste

Posted September 30, 2018 8:21pm by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
tomd
16,701 Points
I've tried maybe 10 variations, and I still can't pass.

Posted September 30, 2018 12:02pm by tomd

tomd
16,701 Points
1 Answer
Karen Shumate
13,579 Points
Write a query that will retrieve all email addresses but will replace the @ symbol with <at> so they all look like andre

Posted September 29, 2018 10:31pm by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
Karen Shumate
13,579 Points
Concatenate the street, city, state, zip and country in the following format. Street, City, State Zip. Country e.g. 34 N

Posted September 29, 2018 2:39pm by Karen Shumate

Karen Shumate
13,579 Points
0 Answers
tonderayi masiyandima
5,673 Points
Challenge Task 1 of 1 We're in a movie database.

Posted September 29, 2018 1:21pm by tonderayi masiyandima

tonderayi masiyandima
5,673 Points
2 Answers
Karen Shumate
13,579 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_publishedcolumn.

Posted September 29, 2018 1:35am by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
Damian Toczek
4,471 Points
How should i count it then?

Posted September 29, 2018 12:38am by Damian Toczek

Damian Toczek
4,471 Points
1 Answer
Sonia Cabon
1,173 Points
bummer: you're missing the where cause

Posted September 24, 2018 9:47am by Sonia Cabon

Sonia Cabon
1,173 Points
3 Answers
Kevin May
1,435 Points
When asked "Write a query to count all the unique genres in the books table. Alias it as total_genres." get wrong count?

Posted September 19, 2018 2:04pm by Kevin May

Kevin May
1,435 Points
2 Answers
Courage Tafadzwa Chesa
5,308 Points
Does this code work lol im now stuck

Posted September 17, 2018 1:29pm by Courage Tafadzwa Chesa

Courage Tafadzwa Chesa
5,308 Points
1 Answer
Kevin Matter
2,507 Points
Question Bug

Posted September 16, 2018 3:26pm by Kevin Matter

Kevin Matter
2,507 Points
2 Answers
Sam Beattie
2,413 Points
I don't know what I'm missing on this challenge in the Reporting with SQL track. I need to "Alias it to to_field."

Posted September 11, 2018 8:13pm by Sam Beattie

Sam Beattie
2,413 Points
3 Answers
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Retrieving Data - SELECT, LIMIT, OFFSET

Posted September 7, 2018 7:20pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
2 Answers
Daniel Sparks
2,695 Points
I am having trouble with the following prompt:

Posted September 4, 2018 7:50pm by Daniel Sparks

Daniel Sparks
2,695 Points
1 Answer
PLUS

ct7
Courses Plus Student 964 Points
Challenge task 1 of 2

Posted September 1, 2018 7:29pm by ct7

ct7
Courses Plus Student 964 Points
2 Answers
Daniel Sparks
2,695 Points
Stuck on a training challenge...

Posted August 31, 2018 5:56pm by Daniel Sparks

Daniel Sparks
2,695 Points
1 Answer
Domenic Crump
2,707 Points
How do you concatenate 3 columns?? I'm so confused, it's Challenge Question 1 Reporting w/ SQL

Posted August 31, 2018 5:55pm by Domenic Crump

Domenic Crump
2,707 Points
2 Answers

Prev Page 13 of 18 Next

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