Treehouse | Community |

💥 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

Sanjay Dulal
1,269 Points
What's the missing ?

Posted April 28, 2017 6:22pm by Sanjay Dulal

Sanjay Dulal
1,269 Points
- Databases
1 Answer
Igor Amidzic
3,052 Points
Reporting with SQL: task 1/2

Posted April 28, 2017 5:54pm by Igor Amidzic

Igor Amidzic
3,052 Points
- Databases
1 Answer
renhe
10,282 Points
Loans, books and patrons

Posted April 21, 2017 1:14am by renhe

renhe
10,282 Points
- Databases
1 Answer
Kiran Khan
1,949 Points
this is my sql: UPDATe phone_book SET first_name='Mystery' AND last_name='Person'. But it doest work. can you help?

Posted April 20, 2017 7:01am by Kiran Khan

Kiran Khan
1,949 Points
- Databases
2 Answers
Brian Harness
7,259 Points
We're using a different database now. Did you know mobile phones have databases? -- Please help

Posted April 15, 2017 5:57pm by Brian Harness

Brian Harness
7,259 Points
- Databases
4 Answers
Andi Muskaj
1,665 Points
Is there a way to combine the three names using "LIKE IN"?

Posted April 15, 2017 4:07pm by Andi Muskaj

Andi Muskaj
1,665 Points
2 Answers
Yingzi Huang
3,216 Points
Task #1: How to count number of outstanding books each patron has and add this "COUNT" to a third column in same query?

Posted April 12, 2017 8:34pm by Yingzi Huang

Yingzi Huang
3,216 Points
1 Answer
Jan Lundeen
6,201 Points
On SQL Playground, Stage 3, Practice, how do I calculate the average movie rating and round it to 1 decimal place?

Posted March 21, 2017 11:51pm by Jan Lundeen

Jan Lundeen
6,201 Points
3 Answers
Andrew Dunn
994 Points
How do I put <> around the email in SQL it is seeing them as a operator rather than text.

Posted March 5, 2017 11:28pm by Andrew Dunn

Andrew Dunn
994 Points
- Databases
1 Answer
Tim Tyslyuk
12,106 Points
Why is my calculation wrong?

Posted March 3, 2017 6:26am by Tim Tyslyuk

Tim Tyslyuk
12,106 Points
- Databases
4 Answers
Cinthia Beltran
1,434 Points
I don't understand what is wrong with my query

Posted March 1, 2017 5:27am by Cinthia Beltran

Cinthia Beltran
1,434 Points
- Databases
1 Answer
Javier Alvarado
16,060 Points
What are the benefits of storing name as one object?

Posted February 28, 2017 12:11am by Javier Alvarado

Javier Alvarado
16,060 Points
2 Answers
Derek Lin
1,563 Points
About Transacations BEgin, Commit, Auto-commit.

Posted February 27, 2017 5:16pm by Derek Lin

Derek Lin
1,563 Points
- Databases
1 Answer
arthropod
2,792 Points
SELECT title AS "title", LENGTH(title) AS "longest length" FROM books ORDER BY title DESC LIMIT 1;

Posted February 23, 2017 10:29pm by arthropod

arthropod
2,792 Points
- Databases
2 Answers
Tyler McDougal
2,549 Points
I Need help trying to solve this:

Posted February 23, 2017 9:35am by Tyler McDougal

Tyler McDougal
2,549 Points
- Databases
2 Answers
Allan Oloo
8,054 Points
Advanced subqueries

Posted February 14, 2017 3:29pm by Allan Oloo

Allan Oloo
8,054 Points
5 Answers
arthropod
2,792 Points
"> SELECT * FROM books ORDER BY first_published DSC;" looks OK. What am I missing?

Posted February 13, 2017 8:44pm by arthropod

arthropod
2,792 Points
- Databases
2 Answers
William Van Pelt
651 Points
How do I update fields for several IDs at once?

Posted February 13, 2017 12:50am by William Van Pelt

William Van Pelt
651 Points
1 Answer
Michael Lawinger
33,581 Points
Add Index Column

Posted February 8, 2017 11:04pm by Michael Lawinger

Michael Lawinger
33,581 Points
- Databases
1 Answer
Michael Lawinger
33,581 Points
Getting the 101st Column

Posted February 8, 2017 9:36pm by Michael Lawinger

Michael Lawinger
33,581 Points
- Databases
2 Answers
Fahri Can
9,921 Points
Why is my DATE() function not working?

Posted February 7, 2017 1:00pm by Fahri Can

Fahri Can
9,921 Points
- Databases
2 Answers
Guy Sudai
8,358 Points
No error in my answer but still tells me i get a wrong answer

Posted February 5, 2017 8:04pm by Guy Sudai

Guy Sudai
8,358 Points
- Databases
4 Answers
Abdus Samad
2,307 Points
Upper Case problem, want went wrong with my code?

Posted January 12, 2017 9:08am by Abdus Samad

Abdus Samad
2,307 Points
- Databases
2 Answers
Saravanan Nagaraj
3,147 Points
Bummer! Your UNION queries didn't bring back a union of fruits and veggies!

Posted November 13, 2016 7:43pm by Saravanan Nagaraj

Saravanan Nagaraj
3,147 Points
- Databases
7 Answers
Khaled Pendleton
20,430 Points
How to handle a MongoDB crash?

Posted November 1, 2016 9:27pm by Khaled Pendleton

Khaled Pendleton
20,430 Points
- Databases
1 Answer
tedjoliman
31,285 Points
please helf me, UNION + BEETWEN query

Posted September 26, 2016 2:16am by tedjoliman

tedjoliman
31,285 Points
- Databases
3 Answers
Anand Suman
307 Points
Not getting the meaning of the mention question exactly , Need help

Posted September 20, 2016 7:52pm by Anand Suman

Anand Suman
307 Points
- Databases
2 Answers
Derek Derek
8,744 Points
load('seed.js') gives an error

Posted May 6, 2016 3:55pm by Derek Derek

Derek Derek
8,744 Points
3 Answers
Sobin Sebastian
5,348 Points
We're using library database again. There's a books table. There's a title, author, genre and first_published column.

Posted March 1, 2016 6:50am by Sobin Sebastian

Sobin Sebastian
5,348 Points
- Databases
5 Answers
Ramon Carvalho
2,910 Points
Can't see where the code is wrong

Posted February 11, 2016 1:51am by Ramon Carvalho

Ramon Carvalho
2,910 Points
- Databases
7 Answers

Prev Page 348 of 389 Next

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