Treehouse | Community | Searching Tables with 'WHERE'

🤑 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

pra saw
233 Points
stuck

Posted March 20, 2019 11:29am by pra saw

pra saw
233 Points
1 Answer
Sharon Watmai
1,451 Points
Modifying sql data

Posted March 20, 2019 10:11am by Sharon Watmai

Sharon Watmai
1,451 Points
1 Answer
David Wells
13,270 Points
In the second question of the library/full name question, how do I write the concatenation SQL statement?

Posted March 19, 2019 5:54pm by David Wells

David Wells
13,270 Points
2 Answers
Michael Nanni
7,358 Points
Am I on the right track? Counting non-returned loans for all library patrons.

Posted March 18, 2019 5:50pm by Michael Nanni

Michael Nanni
7,358 Points
- Databases
4 Answers
Ker Sing Tan
10,573 Points
solve missing where cause error

Posted March 17, 2019 7:42am by Ker Sing Tan

Ker Sing Tan
10,573 Points
1 Answer
Michael Venner
351 Points
What is wrong with my SQL code ``` SELECT * FROM results WHERE away_team = Hessle AND away_score > 18; ```

Posted March 15, 2019 9:36pm by Michael Venner

Michael Venner
351 Points
1 Answer
Michael Nanni
7,358 Points
How do I filter query results between a range of starting letters?

Posted March 15, 2019 2:12am by Michael Nanni

Michael Nanni
7,358 Points
1 Answer
Ker Sing Tan
10,573 Points
Challenge 2 of 3 error

Posted March 13, 2019 10:38am by Ker Sing Tan

Ker Sing Tan
10,573 Points
3 Answers
sulaiman abouabdah
5,314 Points
Error when inserting my own table on my command line message ERROR 1064 (42000): You have an error in your SQL syntax;

Posted March 12, 2019 9:15pm by sulaiman abouabdah

sulaiman abouabdah
5,314 Points
1 Answer
Ker Sing Tan
10,573 Points
Code Challenge: Task 1 of 1

Posted March 12, 2019 3:28pm by Ker Sing Tan

Ker Sing Tan
10,573 Points
3 Answers
sulaiman abouabdah
5,314 Points
Download Link for the databases

Posted March 12, 2019 1:22pm by sulaiman abouabdah

sulaiman abouabdah
5,314 Points
3 Answers
Zoe Dadian
177 Points
im not sure what Im doing wrong here

Posted March 11, 2019 3:17am by Zoe Dadian

Zoe Dadian
177 Points
1 Answer
Michael Cook
Full Stack JavaScript Techdegree Graduate 28,975 Points
How to return all names in a table, and truncate only names greater than 10 characters?

Posted March 9, 2019 4:00pm by Michael Cook

Michael Cook
Full Stack JavaScript Techdegree Graduate 28,975 Points
- Databases
1 Answer
Hans Eisenman
1,315 Points
Having a little trouble with this derived table query. Error I'm getting is just "Bummer: try again!" :-\

Posted March 7, 2019 4:57pm by Hans Eisenman

Hans Eisenman
1,315 Points
1 Answer
Shahrukh Siddiqui
2,698 Points
UNABLE TO WRITE THE QUERY

Posted March 6, 2019 5:51am by Shahrukh Siddiqui

Shahrukh Siddiqui
2,698 Points
1 Answer
Gia Hoang Nguyen
4,137 Points
How to reset the MakeID with the correct order ID?

Posted March 5, 2019 6:21am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
2 Answers
Alexandros Panayi
1,771 Points
Scaling result horizontally for books

Posted March 4, 2019 7:47pm by Alexandros Panayi

Alexandros Panayi
1,771 Points
- Databases
1 Answer
Eniola Tijani
3,440 Points
sql query

Posted March 1, 2019 1:06pm by Eniola Tijani

Eniola Tijani
3,440 Points
- Databases
1 Answer
Satyam garhewal
326 Points
Why my query is not working, can you please help me out?

Posted March 1, 2019 5:46am by Satyam garhewal

Satyam garhewal
326 Points
2 Answers
Øystein Kallset
11,044 Points
What is wrong with this SQL-statement: SELECT REPLACE(email,"@","<at>") FROM customers

Posted February 28, 2019 7:43am by Øystein Kallset

Øystein Kallset
11,044 Points
1 Answer
lucas caldeira
1,592 Points
Is there a better way to do this ? this doesn't feel right !

Posted February 26, 2019 5:08pm by lucas caldeira

lucas caldeira
1,592 Points
- Databases
1 Answer
Kyle St Jean St Jean
220 Points
i have the " FROM results " typed in for this challenge and it's giving me a prompt that I'm not selecting from results

Posted February 24, 2019 2:14am by Kyle St Jean St Jean

Kyle St Jean St Jean
220 Points
1 Answer
PLUS

Patrick Maxwell
Courses Plus Student 6,249 Points
trouble understanding declaring SELECT * FORM comments!!?

Posted February 24, 2019 1:47am by Patrick Maxwell

Patrick Maxwell
Courses Plus Student 6,249 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 4:03pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 12:59am by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
Namazbek Bekarysuly
882 Points
SELECT first_name || " " || last_name " " || "<" || email || ">" AS "to_field" FROM patrons;

Posted February 22, 2019 11:14pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
2 Answers
PLUS

Sharina Jones
Courses Plus Student 18,771 Points
Combining the results of subqueries

Posted February 20, 2019 10:10pm by Sharina Jones

Sharina Jones
Courses Plus Student 18,771 Points
1 Answer
PLUS

Sharina Jones
Courses Plus Student 18,771 Points
Query producing incorrect results

Posted February 20, 2019 7:55pm by Sharina Jones

Sharina Jones
Courses Plus Student 18,771 Points
2 Answers
seth aruby
10,111 Points
Making query account for unknown PERIODS count

Posted February 20, 2019 7:25pm by seth aruby

seth aruby
10,111 Points
1 Answer
Chamundeshwari Vadamalai
2,204 Points
what do I do?

Posted February 20, 2019 9:08am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer

Prev Page 26 of 388 Next

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