Treehouse | Community |

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

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Jan Lundeen
6,122 Points
Issue - creating list of all fruits and vegetables starting with letters A through K (Querying Relational Databases).

Posted May 7, 2017 10:57pm by Jan Lundeen

Jan Lundeen
6,122 Points
- Databases
2 Answers
Jayson Santos
574 Points
I dont know what to code but I did was below. please help. Thanks

Posted May 7, 2017 1:39pm by Jayson Santos

Jayson Santos
574 Points
- Databases
2 Answers
jenny rodriguez
666 Points
Can't see what's Wrong?

Posted May 7, 2017 11:53am by jenny rodriguez

jenny rodriguez
666 Points
- Databases
2 Answers
Stuart Guest-Smith
5,343 Points
Not sure what's wrong? - 'Your query needs to retrieve the earliest 'Science Fiction' book from the `books` table."

Posted May 6, 2017 11:10pm by Stuart Guest-Smith

Stuart Guest-Smith
5,343 Points
- Databases
3 Answers
R.P. Arts
22,284 Points
Querying Relational Databases , Challenge Task 6 of 6

Posted May 6, 2017 9:07pm by R.P. Arts

R.P. Arts
22,284 Points
- Databases
9 Answers
jenny rodriguez
666 Points
UPDATE games SET platform = "Cross-Plaform" WHERE id = (1,4); this is incorrect. Why?

Posted May 6, 2017 8:44pm by jenny rodriguez

jenny rodriguez
666 Points
2 Answers
R.P. Arts
22,284 Points
Querying Relational Databases. Challenge Task 5 of 5 JOIN QUERIES

Posted May 6, 2017 8:09pm by R.P. Arts

R.P. Arts
22,284 Points
- Databases
3 Answers
Emil Pedersen
4,632 Points
This is bugged

Posted May 5, 2017 8:59pm by Emil Pedersen

Emil Pedersen
4,632 Points
- Databases
0 Answers
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
Database setup help.

Posted May 5, 2017 6:52pm by Brendan Whiting

Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
- Databases
- Introduction to Window Functions
1 Answer
PLUS

Nelson Govea
Courses Plus Student 1,951 Points
Reporting with SQL

Posted May 5, 2017 3:04pm by Nelson Govea

Nelson Govea
Courses Plus Student 1,951 Points
- Databases
2 Answers
Siu Chung LEUNG
742 Points
If begin; is used, why would you need a rollback function when your command is not yet committed?

Posted May 5, 2017 3:53am by Siu Chung LEUNG

Siu Chung LEUNG
742 Points
5 Answers
PLUS

Nelson Govea
Courses Plus Student 1,951 Points
Reporting w/SQL, Not able to get the right code for challenge Task 1 of 2 using the ORDER BY and WHERE with LIMIT clause

Posted May 5, 2017 2:35am by Nelson Govea

Nelson Govea
Courses Plus Student 1,951 Points
- Databases
2 Answers
Shan Liu
3,612 Points
Fruit and Vegetables

Posted May 4, 2017 10:46pm by Shan Liu

Shan Liu
3,612 Points
- Databases
1 Answer
Shan Liu
3,612 Points
Duplicates?

Posted May 4, 2017 9:31pm by Shan Liu

Shan Liu
3,612 Points
2 Answers
Rachel Aitkens
7,648 Points
Use of ASC in SQL

Posted May 4, 2017 12:47am by Rachel Aitkens

Rachel Aitkens
7,648 Points
- Databases
1 Answer
Ibrahim Aldossrie
4,150 Points
join challenge task 3 Bummer your query didn't select even I did

Posted May 3, 2017 5:50pm by Ibrahim Aldossrie

Ibrahim Aldossrie
4,150 Points
- Databases
3 Answers
John Gu
6,891 Points
Which is ONE and which is MANY? Products or Sales?

Posted May 3, 2017 11:49am by John Gu

John Gu
6,891 Points
1 Answer
PLUS

MANDEEP SINGH
Courses Plus Student 935 Points
STRFTIME function is not returning correct answer.

Posted May 3, 2017 2:14am by MANDEEP SINGH

MANDEEP SINGH
Courses Plus Student 935 Points
- Databases
3 Answers
Craig Okeeffe
1,050 Points
what is wrong with this statement SELECT MIN(rating) AS star_min, MAX(rating) AS star_max, movie_id FROM reviews WHERE m

Posted May 1, 2017 11:34am by Craig Okeeffe

Craig Okeeffe
1,050 Points
- Databases
2 Answers
Craig Okeeffe
1,050 Points
> SELECT COUNT (genre) FROM books AS scifi_book_count WHERE genre="Science Fiction"; what is wrong with this answer

Posted April 30, 2017 4:55pm by Craig Okeeffe

Craig Okeeffe
1,050 Points
- Databases
1 Answer
Sanjay Dulal
1,269 Points
We have an eCommerce database and it has a products table. It has the columns id, name, description and price.

Posted April 29, 2017 2:58pm by Sanjay Dulal

Sanjay Dulal
1,269 Points
- Databases
4 Answers
PLUS

MANDEEP SINGH
Courses Plus Student 935 Points
why do we have to use Distinct keyword when the Group by can count and report the different set of data?

Posted April 29, 2017 3:40am by MANDEEP SINGH

MANDEEP SINGH
Courses Plus Student 935 Points
- Databases
5 Answers
William J. Terrell
17,403 Points
Filling In IDs with SQL

Posted April 28, 2017 9:09pm by William J. Terrell

William J. Terrell
17,403 Points
- Databases
1 Answer
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
Kayla Flynn
7,652 Points
How to use SQL off playground

Posted April 27, 2017 8:25pm by Kayla Flynn

Kayla Flynn
7,652 Points
2 Answers
Sanjay Dulal
1,269 Points
You're missing the date of the 1st October 2015 ("2015-10-01")

Posted April 27, 2017 5:18pm by Sanjay Dulal

Sanjay Dulal
1,269 Points
- Databases
1 Answer
James Moran
7,271 Points
You have an error in your SQL syntax (trigger was unable to be created)

Posted April 27, 2017 12:47pm by James Moran

James Moran
7,271 Points
- Databases
1 Answer
Max F
9,900 Points
Question about relation between LIKE and %

Posted April 27, 2017 3:46am by Max F

Max F
9,900 Points
1 Answer
PLUS

Chris Gauthier
Courses Plus Student 6,434 Points
Reporting to SQL question

Posted April 26, 2017 10:12pm by Chris Gauthier

Chris Gauthier
Courses Plus Student 6,434 Points
- Databases
1 Answer

Prev Page 65 of 389 Next

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