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

PLUS

Rania Mohamed
Courses Plus Student 1,333 Points
reporting wit SQL, challenge Task giving error

Posted April 3, 2017 2:13pm by Rania Mohamed

Rania Mohamed
Courses Plus Student 1,333 Points
- Databases
1 Answer
Byron Injeeli
Full Stack JavaScript Techdegree Graduate 25,639 Points
Challenge - "count number of orders with status of shipped and shipped date as today". My result is 149.

Posted March 25, 2017 5:22pm by Byron Injeeli

Byron Injeeli
Full Stack JavaScript Techdegree Graduate 25,639 Points
- Databases
1 Answer
PLUS

Emily Coltman
Courses Plus Student 9,623 Points
What am I doing wrong with the Querying Relational Databases final practice session, please?

Posted March 24, 2017 4:37pm by Emily Coltman

Emily Coltman
Courses Plus Student 9,623 Points
- Databases
5 Answers
Jonatan Spahn
6,362 Points
SQL Stage 4: Practice problem.

Posted March 24, 2017 4:47am by Jonatan Spahn

Jonatan Spahn
6,362 Points
3 Answers
PLUS

tonypitkin2
Courses Plus Student 1,950 Points
Can you combine a Substring and Replace function inside one another?

Posted March 22, 2017 12:10am by tonypitkin2

tonypitkin2
Courses Plus Student 1,950 Points
2 Answers
Erica Rottman
2,602 Points
This keeps throwing an error SELECT first_name, last_name FROM users WHERE username = "wig-lady";

Posted March 21, 2017 6:21pm by Erica Rottman

Erica Rottman
2,602 Points
- Databases
1 Answer
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
Karrerah White
10,118 Points
SQL basics: Categorizing your output with 'AS'

Posted March 20, 2017 1:30am by Karrerah White

Karrerah White
10,118 Points
- Databases
2 Answers
Christopher Johnson
2,066 Points
Why am I receiving "no such column: street" ?

Posted March 19, 2017 2:30am by Christopher Johnson

Christopher Johnson
2,066 Points
- Databases
2 Answers
Jan Lundeen
6,201 Points
Wrote query that totals up ratings in the reviews table. Error - missing WHERE clause. WHERE and GROUP BY don't mix

Posted March 17, 2017 10:50pm by Jan Lundeen

Jan Lundeen
6,201 Points
- Databases
2 Answers
nicolaslemaire
12,806 Points
Problem with task 2 of 2 (reporting with SQL)

Posted March 17, 2017 2:58pm by nicolaslemaire

nicolaslemaire
12,806 Points
- Databases
1 Answer
Rashi Abramson
769 Points
Why is it an INNER JOIN, not a LEFT OUTER JOIN, because if a car doesn't have a make I still want to show it?

Posted March 13, 2017 11:32pm by Rashi Abramson

Rashi Abramson
769 Points
- Databases
2 Answers
Ido Galili
1,160 Points
Why do I recieve wrong answer if the results ar correct?

Posted March 13, 2017 9:33am by Ido Galili

Ido Galili
1,160 Points
- Databases
3 Answers
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
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
Jan Lundeen
6,201 Points
Reporting with SQL concatenation query - SQL Error: near ".": syntax error

Posted March 1, 2017 2:52am by Jan Lundeen

Jan Lundeen
6,201 Points
- Databases
5 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
Jan Lundeen
6,201 Points
Concatenating query - error message says emails are not in the correct format

Posted February 28, 2017 4:37am by Jan Lundeen

Jan Lundeen
6,201 Points
- Databases
4 Answers
Derek Lin
1,563 Points
Autocommitting:

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

Derek Lin
1,563 Points
2 Answers
arthropod
2,792 Points
Database: SELECT first_name || " " || last_name AS "to", email AS "<email>" FROM patrons; -- I always get stuck here.

Posted February 23, 2017 5:55am by arthropod

arthropod
2,792 Points
- Databases
3 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
Abdus Samad
2,307 Points
SET Problem

Posted February 1, 2017 2:40pm by Abdus Samad

Abdus Samad
2,307 Points
- Databases
2 Answers
xl
1,970 Points
SELECT * FROM results WHERE played_on BETWEEN 2015-09-01 AND 2015-09-30; it says i am missing the value of 2015-09-01?

Posted January 22, 2017 4:56pm by xl

xl
1,970 Points
- Databases
2 Answers
amourief
5,469 Points
Access Control for MongoDB

Posted December 4, 2016 11:29am by amourief

amourief
5,469 Points
- Databases
1 Answer
Shawn Jass
7,151 Points
Bummer! Your query didn't select the `MakeName`, `ModelName`, `VIN` and `StickerPrice`!

Posted September 16, 2016 10:21pm by Shawn Jass

Shawn Jass
7,151 Points
- Databases
3 Answers
Vaibhav Vikram Singh
2,604 Points
Stored Procedure

Posted February 3, 2016 2:31pm by Vaibhav Vikram Singh

Vaibhav Vikram Singh
2,604 Points
5 Answers

Prev Page 300 of 389 Next

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