Treehouse | Community |

⚡ 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

Joel McCracken Jr
3,142 Points
Relational Database Challenge Task 2 of 5: Bummer ambiguous column name Car.VIN

Posted March 24, 2017 6:44pm by Joel McCracken Jr

Joel McCracken Jr
3,142 Points
- Databases
3 Answers
Inbar Shimshon
2,286 Points
Hi, not sure what is wrong with my code: https://www.screencast.com/t/uUNfukYrxbv I am using an Insert statement...

Posted March 22, 2017 9:44am by Inbar Shimshon

Inbar Shimshon
2,286 Points
- Databases
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
Matt Caminiti
3,466 Points
Only showing first result from "WHERE" clause.

Posted March 20, 2017 10:24pm by Matt Caminiti

Matt Caminiti
3,466 Points
- Databases
2 Answers
hamilton katsvairo
6,306 Points
Reporting with SQL,Challenge task 2 of 2

Posted March 20, 2017 6:07am by hamilton katsvairo

hamilton katsvairo
6,306 Points
- Databases
2 Answers
Jan Lundeen
6,201 Points
Need help with REPLACE function question (challenge task 1 of 1) in Reporting with SQL course.

Posted March 13, 2017 3:23am by Jan Lundeen

Jan Lundeen
6,201 Points
- Databases
1 Answer
Brian Jemison
3,832 Points
Issues with subquery challenge task.

Posted March 10, 2017 5:02am by Brian Jemison

Brian Jemison
3,832 Points
- Databases
1 Answer
Eric Johansen
1,685 Points
SELECT * FROM phone_book ORDER BY last_name ASC, first_name ASC; LIMIT 40, 20;

Posted March 6, 2017 8:43pm by Eric Johansen

Eric Johansen
1,685 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
PLUS

Mayur Pande
Courses Plus Student 11,711 Points
mysql cannot create foreign key

Posted February 28, 2017 11:54am by Mayur Pande

Mayur Pande
Courses Plus Student 11,711 Points
- Databases
1 Answer
Unsubscribed User
2,111 Points
It says that my query didn't select the `ModelName' and 'Vin' correctly and I have no clue what CORRECTLY is indicating

Posted February 27, 2017 9:24am by Unsubscribed User

Unsubscribed User
2,111 Points
- Databases
0 Answers
Jan Lundeen
6,201 Points
Only finding one name when I write the SQL query for Challenge Task 1 of 3.

Posted February 24, 2017 3:46am by Jan Lundeen

Jan Lundeen
6,201 Points
- Databases
2 Answers
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
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
Larry Singleton
18,947 Points
Modifying Data and SQL, Help needed.

Posted February 13, 2017 6:07pm by Larry Singleton

Larry Singleton
18,947 Points
- Databases
6 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
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
What's the problem with my command, The subquery didn't return all CustomerIDs for people who identify as female (F).

Posted February 5, 2017 4:20pm by Guy Sudai

Guy Sudai
8,358 Points
- Databases
2 Answers
Anil Nalabothu
1,540 Points
Write a query that totals up all ratings in the reviews table. Alias it as starman_total_ratings.

Posted January 27, 2017 8:43am by Anil Nalabothu

Anil Nalabothu
1,540 Points
- Databases
1 Answer
Hassan H
1,086 Points
Where can I find answers to questions?

Posted January 26, 2017 4:17am by Hassan H

Hassan H
1,086 Points
- Databases
1 Answer
AJ Longstreet
Treehouse Project Reviewer
Using 2 Inner Joins at the same time?

Posted January 25, 2017 10:58pm by AJ Longstreet

AJ Longstreet
Treehouse Project Reviewer
- Databases
1 Answer
Zachary Wheeler
1,157 Points
Very First Reporting SQL Challenge Question

Posted January 25, 2017 8:14pm by Zachary Wheeler

Zachary Wheeler
1,157 Points
- Databases
3 Answers
abhisheklomsh5
4,365 Points
First entry is not correct

Posted January 16, 2017 12:28pm by abhisheklomsh5

abhisheklomsh5
4,365 Points
- Databases
1 Answer
Kristian Woods
23,414 Points
I don't fully understand how GROUB BY works...

Posted October 9, 2016 5:20pm by Kristian Woods

Kristian Woods
23,414 Points
4 Answers
Buck McBuck
2,324 Points
Challenge appears to be flawed.

Posted June 27, 2016 6:48pm by Buck McBuck

Buck McBuck
2,324 Points
8 Answers
A X
12,842 Points
Getting Keywords Mixed Up! GROUP BY/ORDER BY & WHERE/HAVING

Posted April 1, 2016 12:59am by A X

A X
12,842 Points
1 Answer
Rohit Gopalan
81,945 Points
Why is this code incorrect for the code challenge of concatenating strings in SQL?

Posted February 26, 2016 1:37pm by Rohit Gopalan

Rohit Gopalan
81,945 Points
- Databases
1 Answer
PLUS

Kevin Williams
Courses Plus Student 19,952 Points
From the users table, find all the usernames with the last_name of "Chalkley". Only return the usernames.

Posted December 16, 2015 10:31pm by Kevin Williams

Kevin Williams
Courses Plus Student 19,952 Points
- Databases
7 Answers

Prev Page 111 of 389 Next

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