Treehouse | Community | Adding Data With SQL

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Sarah E
1,961 Points
Modifying Data with SQL Challenge question

Posted May 10, 2023 2:54pm by Sarah E

Sarah E
1,961 Points
3 Answers
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
Use a subquery along with IN to list all the Model Names with a Sticker Price greater than $30000

Posted May 7, 2023 11:56pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Codi Hasbrouck
41 Points
Date datatype

Posted May 6, 2023 11:26am by Codi Hasbrouck

Codi Hasbrouck
41 Points
- Databases
0 Answers
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
SQL Error: no such column: VIN

Posted May 3, 2023 8:46pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
1 Answer
Daiana Cherhynets
1,354 Points
SELECT ||(first_name, ' ', last_name, ' <', email, '>') AS to_field FROM patrons

Posted April 30, 2023 10:44pm by Daiana Cherhynets

Daiana Cherhynets
1,354 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
Hello, Please help me, what wrong with my command?

Posted April 29, 2023 1:59pm by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
I don't understand where is the mistake? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted April 26, 2023 12:15pm by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
IN a library database....

Posted April 24, 2023 4:23pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Alyssa Daniel
1,944 Points
I don't understand

Posted April 20, 2023 7:43pm by Alyssa Daniel

Alyssa Daniel
1,944 Points
1 Answer
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
What does this error mean: Bummer: Was expecting 7 entries in the phone_book table. There's only 6.

Posted April 17, 2023 7:09pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
7 Answers
Anakin Bjelland
7,176 Points
I need some help with this union challenge

Posted March 30, 2023 9:40pm by Anakin Bjelland

Anakin Bjelland
7,176 Points
1 Answer
Eric Agbayani
Full Stack JavaScript Techdegree Graduate 15,011 Points
Adding a new product, but my command is not working.

Posted March 24, 2023 7:43pm by Eric Agbayani

Eric Agbayani
Full Stack JavaScript Techdegree Graduate 15,011 Points
1 Answer
Wufei Hong
1,393 Points
bummer reason

Posted March 24, 2023 6:08am by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
Fidelis Chime
6,077 Points
inserting data on the database row

Posted March 20, 2023 1:43pm by Fidelis Chime

Fidelis Chime
6,077 Points
1 Answer
Fidelis Chime
6,077 Points
ADD FOREIGN KEY

Posted March 13, 2023 5:42am by Fidelis Chime

Fidelis Chime
6,077 Points
1 Answer
Krithika Pirahalathan
150 Points
alias the query

Posted March 8, 2023 1:25pm by Krithika Pirahalathan

Krithika Pirahalathan
150 Points
1 Answer
Krithika Pirahalathan
150 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted March 8, 2023 11:10am by Krithika Pirahalathan

Krithika Pirahalathan
150 Points
0 Answers
Danielle Petrides
5,346 Points
REPLACE() with string literal and single quotes?

Posted March 8, 2023 2:58am by Danielle Petrides

Danielle Petrides
5,346 Points
- Databases
1 Answer
Wufei Hong
1,393 Points
don't know what's wrong wiz my code

Posted March 4, 2023 1:51am by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
Alberto Gurrola
1,769 Points
Hi, I'm not too sure what I'm doing wrong. I tried entering this code but it's still wrong.

Posted February 22, 2023 2:36pm by Alberto Gurrola

Alberto Gurrola
1,769 Points
1 Answer
Vincent Almeroth
12,123 Points
What lesson shows use how to filter by the first letter of a column value?

Posted February 22, 2023 12:25am by Vincent Almeroth

Vincent Almeroth
12,123 Points
1 Answer
Andy McDonald
Python Development Techdegree Graduate 13,801 Points
Expecting an extra value when not defining columns first

Posted February 13, 2023 6:18am by Andy McDonald

Andy McDonald
Python Development Techdegree Graduate 13,801 Points
1 Answer
Joel Fuster
2,429 Points
Are you able to review my script? It returns incorrect but I can't seem to figure out why

Posted February 12, 2023 2:25pm by Joel Fuster

Joel Fuster
2,429 Points
1 Answer
Minh Duong
1,616 Points
SELECT CONCAT(first_name, ' ', last_name) AS "To_field", CONCAT('<', email, '>') AS "To" FROM patrons; why is missing?

Posted February 9, 2023 8:43pm by Minh Duong

Minh Duong
1,616 Points
1 Answer
Kenzie Iles
1,773 Points
Error: near "ID": syntax error

Posted February 6, 2023 3:07pm by Kenzie Iles

Kenzie Iles
1,773 Points
1 Answer
Vernon Kincaid
11,447 Points
What is a where statement that will not return a row that starts with the letter L through Z

Posted January 29, 2023 8:11pm by Vernon Kincaid

Vernon Kincaid
11,447 Points
1 Answer
Brian Taylor
3,436 Points
Your code challenge appears to have a broken Javascript file in it? (or at least in this instance of the virtual machine

Posted January 26, 2023 6:57am by Brian Taylor

Brian Taylor
3,436 Points
1 Answer
Sam Speaks
6,013 Points
What is this supposedly outputting? (Subqueries)

Posted January 25, 2023 12:37am by Sam Speaks

Sam Speaks
6,013 Points
1 Answer
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Car data base query

Posted January 24, 2023 10:14pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
2 Answers
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Querying Relational Database error

Posted January 21, 2023 2:03pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
1 Answer

Prev Page 3 of 389 Next

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