Treehouse | Community | Getting the Length of a String

🤑 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

Taylor Han
2,406 Points
Length reporting with SQL

Posted April 15, 2020 7:49pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
vona goodpaster
1,719 Points
need help

Posted April 15, 2020 1:54am by vona goodpaster

vona goodpaster
1,719 Points
2 Answers
Taylor Han
2,406 Points
Finding the length with SQL reporting

Posted April 14, 2020 4:49pm by Taylor Han

Taylor Han
2,406 Points
2 Answers
Caleb Newell
12,562 Points
Write a query to count all the unique genres in the books table. Alias it as total_genres.

Posted April 9, 2020 1:26pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
pratyush raj
7,097 Points
i am doing everything correct still i am not getting the answer

Posted April 8, 2020 12:40pm by pratyush raj

pratyush raj
7,097 Points
1 Answer
walter fernandez
4,992 Points
can some one please give me the solution?

Posted April 3, 2020 10:40pm by walter fernandez

walter fernandez
4,992 Points
1 Answer
Balazs Ferencz
4,993 Points
Getting a "Your query didn't retrieve the emails in the correct format." error message and I don`t understand why.

Posted April 3, 2020 7:07am by Balazs Ferencz

Balazs Ferencz
4,993 Points
2 Answers
Taylor Han
2,406 Points
SQL concatenation

Posted April 2, 2020 4:17pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Taylor Han
2,406 Points
SQL concatenation question

Posted April 1, 2020 10:58pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Freddie Kuhle
8,036 Points
SQL - How can I add a column from one table to my results from another table?

Posted March 30, 2020 10:31am by Freddie Kuhle

Freddie Kuhle
8,036 Points
1 Answer
fairest
Full Stack JavaScript Techdegree Graduate 19,303 Points
SQL Function VS JS Function?

Posted March 27, 2020 11:34pm by fairest

fairest
Full Stack JavaScript Techdegree Graduate 19,303 Points
1 Answer
Caleb Newell
12,562 Points
sql as tables

Posted March 27, 2020 12:03pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
Tafari Carnegie
2,679 Points
select genre,count(distinct genre) as total_genres from books group by genre

Posted March 25, 2020 10:15pm by Tafari Carnegie

Tafari Carnegie
2,679 Points
1 Answer
Tafari Carnegie
2,679 Points
Hi, I believe my code is correct but for some reason, it is saying it isn't. I have done what the question has asked me.

Posted March 19, 2020 2:12am by Tafari Carnegie

Tafari Carnegie
2,679 Points
1 Answer
Caleb Newell
12,562 Points
Help with this SQL query

Posted March 18, 2020 7:43pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
Caleb Newell
12,562 Points
SQL limit

Posted March 11, 2020 1:56pm by Caleb Newell

Caleb Newell
12,562 Points
3 Answers
Marina Toto
1,479 Points
Im getting the tip of putting angle brackets for an email - but I dont know how to do it

Posted March 9, 2020 7:08pm by Marina Toto

Marina Toto
1,479 Points
2 Answers
PLUS

Ân Nguyễn Hoàng
Courses Plus Student 3,980 Points
is this a bug ?

Posted March 7, 2020 11:27pm by Ân Nguyễn Hoàng

Ân Nguyễn Hoàng
Courses Plus Student 3,980 Points
1 Answer
Kalif Yusuf
4,056 Points
Not sure, what is wrong with the away I answered the question

Posted February 29, 2020 7:04pm by Kalif Yusuf

Kalif Yusuf
4,056 Points
1 Answer
Claire Brehm
9,098 Points
Having trouble getting the correct answer for task 2 here in the changing cases of strings task

Posted February 26, 2020 10:35pm by Claire Brehm

Claire Brehm
9,098 Points
0 Answers
Diadie Camara
1,842 Points
select first_name|| " " || UPPER(last_name) AS Full_name, library_id from patrons

Posted February 25, 2020 9:36pm by Diadie Camara

Diadie Camara
1,842 Points
2 Answers
Mayo Toyota
2,121 Points
genre = "Science Fiction"

Posted February 15, 2020 9:17pm by Mayo Toyota

Mayo Toyota
2,121 Points
1 Answer
Zachary keller
3,178 Points
Cant understand the question, mainly the end part

Posted February 12, 2020 5:41pm by Zachary keller

Zachary keller
3,178 Points
3 Answers
Zachary keller
3,178 Points
The way the question is worded confuses me.

Posted February 11, 2020 8:29pm by Zachary keller

Zachary keller
3,178 Points
2 Answers
Timothy Hong
2,949 Points
What am I doing wrong here?

Posted January 30, 2020 1:22pm by Timothy Hong

Timothy Hong
2,949 Points
1 Answer
Daniil Kalinkin
853 Points
I would type in ______ at the end of an`ORDER BY` clause to order in descending order. What should I write here?

Posted January 30, 2020 12:24am by Daniil Kalinkin

Daniil Kalinkin
853 Points
1 Answer
Arush Sharma
2,513 Points
This is the error message when I try to execute my query - " Your query retrieve the dates in the correct format (%m/%Y)

Posted January 22, 2020 12:43pm by Arush Sharma

Arush Sharma
2,513 Points
0 Answers
Arush Sharma
2,513 Points
I don't understand what is wrong in my query, How should I move to next question or see the solution of this one ?

Posted January 22, 2020 6:08am by Arush Sharma

Arush Sharma
2,513 Points
1 Answer
Mohd Aamir Mir
3,281 Points
select title,STRFTIME(%m%y,date_released) as month_year_released from movies;

Posted January 20, 2020 7:18am by Mohd Aamir Mir

Mohd Aamir Mir
3,281 Points
1 Answer
PLUS

youssef b10ta
Courses Plus Student 2,755 Points
how im supposed t understand this ? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted January 16, 2020 10:09am by youssef b10ta

youssef b10ta
Courses Plus Student 2,755 Points
2 Answers

Prev Page 7 of 18 Next

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