Treehouse | Community | Practice Session

⚡ CYBER NOVEMBER SALE ⚡ 50% off any plan for 6 months, exclusive to new subscribers.

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Chamundeshwari Vadamalai
2,204 Points
How to format the dates?

Posted April 2, 2019 11:46am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer
adam woolf
1,181 Points
select SUM(rating) AS starman_total_ratings From reviews WHERE movie_id="Starman" it says i did not sum correctly

Posted April 2, 2019 4:39am by adam woolf

adam woolf
1,181 Points
1 Answer
Ilya Kotlyar
2,258 Points
Is there a track on online databases?

Posted March 31, 2019 1:18am by Ilya Kotlyar

Ilya Kotlyar
2,258 Points
- Databases
1 Answer
Apoorva Seeram
790 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted March 28, 2019 8:09pm by Apoorva Seeram

Apoorva Seeram
790 Points
2 Answers
Yelson Yang
3,983 Points
How to select all row with missing values?

Posted March 28, 2019 3:48pm by Yelson Yang

Yelson Yang
3,983 Points
- Databases
1 Answer
Gia Hoang Nguyen
4,137 Points
How to find the discrepancy between the current grade 7 students and the future grade 6 students who move to grade 7?

Posted March 27, 2019 3:28am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
1 Answer
Michael Nanni
7,358 Points
Does grade level matter to find which subject is least popular?

Posted March 26, 2019 12:49pm by Michael Nanni

Michael Nanni
7,358 Points
- Databases
1 Answer
taherkhan
4,327 Points
Query regarding calculating average

Posted March 24, 2019 9:46am by taherkhan

taherkhan
4,327 Points
1 Answer
Michael Nanni
7,358 Points
My answer to the challenge. Let me know what you think.

Posted March 23, 2019 9:20pm by Michael Nanni

Michael Nanni
7,358 Points
- Databases
1 Answer
Brian Poirier
7,678 Points
select fruit and vegetables. what's wrong with this? SELECT * FROM fruit UNION SELECT * FROM vegetable

Posted March 22, 2019 2:25am by Brian Poirier

Brian Poirier
7,678 Points
1 Answer
Robert Hecht
6,797 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

Posted March 20, 2019 2:54pm by Robert Hecht

Robert Hecht
6,797 Points
1 Answer
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

Prev Page 26 of 389 Next

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