Treehouse | Community | The Solutions

🏛️ Access Treehouse at your local library for free! Check out Treehouse Near Me.

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

⭐Get support and network on our Discord server! ⭐

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Teacher Russell
16,873 Points
Checking for dates in a query.

Posted February 20, 2018 6:51pm by Teacher Russell

Teacher Russell
16,873 Points
- Databases
- The Solutions
2 Answers
Jasper Peijer
45,009 Points
Isn't it smarter to use GROUP BY TEACHERS.ID so you don't have to show the ID in the result?

Posted February 19, 2018 1:05pm by Jasper Peijer

Jasper Peijer
45,009 Points
- Databases
0 Answers
Juan Emmanuel Afable
18,531 Points
I recommend changing the question to say: "count the total number of orders that was shipped and was ordered today.

Posted February 18, 2018 10:15pm by Juan Emmanuel Afable

Juan Emmanuel Afable
18,531 Points
1 Answer
MANOJ MANN
1,793 Points
How to use a sub query along with IN to list all the Model Names with a Sticker Price greater than $30000

Posted February 17, 2018 2:46am by MANOJ MANN

MANOJ MANN
1,793 Points
- Databases
4 Answers
Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
Yeah, Wii U's didn't sell that well...

Posted February 16, 2018 7:41pm by Neil Bircumshaw

Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
4 Answers
PLUS

Nivesh Sharma
Courses Plus Student 1,941 Points
Query Error!

Posted February 16, 2018 2:19pm by Nivesh Sharma

Nivesh Sharma
Courses Plus Student 1,941 Points
- Databases
1 Answer
Charlie Harcourt
8,046 Points
[SOLVED IT IS A BUG] PRIMARY KEY not working think it's a bug.

Posted February 16, 2018 12:35pm by Charlie Harcourt

Charlie Harcourt
8,046 Points
- Databases
1 Answer
Brian Patterson
19,588 Points
Cant create database with Sequel Pro

Posted February 15, 2018 6:22pm by Brian Patterson

Brian Patterson
19,588 Points
- Databases
1 Answer
Charlie Harcourt
8,046 Points
Joining teachers name onto student schedule

Posted February 15, 2018 4:15pm by Charlie Harcourt

Charlie Harcourt
8,046 Points
3 Answers
Adam Tatusko
16,589 Points
CONCERT ID

Posted February 14, 2018 8:42pm by Adam Tatusko

Adam Tatusko
16,589 Points
1 Answer
MANOJ MANN
1,793 Points
How to perform Union between 2 tables

Posted February 14, 2018 4:38pm by MANOJ MANN

MANOJ MANN
1,793 Points
- Databases
2 Answers
Anthony Diorio
14,642 Points
Taking SQL course on TreeHouse to learn MySQL

Posted February 13, 2018 10:37pm by Anthony Diorio

Anthony Diorio
14,642 Points
- Databases
1 Answer
cho man tsang
6,142 Points
DONT FORGET TO ADD CONSTRAINTS.....

Posted February 13, 2018 1:06pm by cho man tsang

cho man tsang
6,142 Points
- Databases
1 Answer
Ben Sang
436 Points
Database schema issue

Posted February 13, 2018 9:19am by Ben Sang

Ben Sang
436 Points
- Databases
2 Answers
PLUS

Jaco Kotzee
Courses Plus Student 20,157 Points
Are there a good beginner course about Database Design and Data Flow on treehouse?

Posted February 12, 2018 10:20am by Jaco Kotzee

Jaco Kotzee
Courses Plus Student 20,157 Points
- Databases
1 Answer
Timothy Van Cauwenberge
8,958 Points
I dont see anything wrong with the code

Posted February 9, 2018 1:28am by Timothy Van Cauwenberge

Timothy Van Cauwenberge
8,958 Points
- Databases
1 Answer
Abdullah Jassim
4,551 Points
Once the two functions: Fifth and Seventh are created, instead of using inner join, why cant we use Union ALL?

Posted February 7, 2018 7:03pm by Abdullah Jassim

Abdullah Jassim
4,551 Points
1 Answer
nicolabell
18,212 Points
whats wrong with this sql

Posted February 7, 2018 5:57pm by nicolabell

nicolabell
18,212 Points
- Databases
1 Answer
codegritty
5,749 Points
Help please. I have tried everything from the || to concat function, added quotes, spaced them out, and nothing!

Posted February 7, 2018 1:59pm by codegritty

codegritty
5,749 Points
- Databases
1 Answer
Abdullah Jassim
4,551 Points
Why does the GROUP BY Function in SQL add more names. It isnt just suppose to cluster together rows together?

Posted February 6, 2018 6:37am by Abdullah Jassim

Abdullah Jassim
4,551 Points
1 Answer
Tauan Flores
Front End Web Development Techdegree Student 5,277 Points
About ORM

Posted February 5, 2018 11:35pm by Tauan Flores

Tauan Flores
Front End Web Development Techdegree Student 5,277 Points
- Databases
1 Answer
Charlie Harcourt
8,046 Points
Why does this code work in SQL?

Posted February 5, 2018 12:48pm by Charlie Harcourt

Charlie Harcourt
8,046 Points
- Databases
1 Answer
Mehiret Abdissa
415 Points
https://teamtreehouse.com/library/querying-relational-databases/subqueries/subqueries

Posted February 5, 2018 2:00am by Mehiret Abdissa

Mehiret Abdissa
415 Points
- Databases
1 Answer
Mehiret Abdissa
415 Points
https://teamtreehouse.com/library/querying-relational-databases/subqueries/subqueries\

Posted February 5, 2018 12:42am by Mehiret Abdissa

Mehiret Abdissa
415 Points
- Databases
1 Answer
MANOJ MANN
1,793 Points
How to use group by to get no. of record in two columns

Posted February 4, 2018 8:40am by MANOJ MANN

MANOJ MANN
1,793 Points
- Databases
1 Answer
MANOJ MANN
1,793 Points
how to get no of all unique genre from table book

Posted February 3, 2018 9:40pm by MANOJ MANN

MANOJ MANN
1,793 Points
- Databases
1 Answer
luis meza
1,826 Points
why

Posted February 3, 2018 4:43am by luis meza

luis meza
1,826 Points
- Databases
1 Answer
Bergomy Legendre
1,026 Points
Find all users with either the last name Hinkley or Pettit SELECT * FROM users WHERE last_name = "Hinkley" OR "Pettit"

Posted February 2, 2018 5:01pm by Bergomy Legendre

Bergomy Legendre
1,026 Points
- Databases
2 Answers
MANOJ MANN
1,793 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 February 1, 2018 2:59pm by MANOJ MANN

MANOJ MANN
1,793 Points
- Databases
2 Answers
Abdullah Jassim
4,551 Points
I want to make sure my answer is right for these three questions. (SQL PLAYGROUND - PATRONS WITH OUTSTANDING LOANS

Posted February 1, 2018 2:07pm by Abdullah Jassim

Abdullah Jassim
4,551 Points
- Databases
2 Answers

Prev Page 46 of 388 Next

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