Treehouse | Community | Updating Data in a Database Review

💥 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

Sebastiaan van Vugt
Python Development Techdegree Graduate 15,563 Points
replacing null values

Posted February 24, 2020 2:07pm by Sebastiaan van Vugt

Sebastiaan van Vugt
Python Development Techdegree Graduate 15,563 Points
1 Answer
Zachary keller
3,178 Points
Cant understand the question, mainly the end part

Posted February 12, 2020 5:41pm by Zachary keller

Zachary keller
3,178 Points
3 Answers
Caroline Dossal
1,767 Points
It's expecting 4 entries, and I enter 4 entries

Posted January 21, 2020 9:09am by Caroline Dossal

Caroline Dossal
1,767 Points
1 Answer
Stephanie Albright
5,690 Points
Help please

Posted January 10, 2020 7:14pm by Stephanie Albright

Stephanie Albright
5,690 Points
3 Answers
roy chen
2,659 Points
I think i did it right.

Posted January 4, 2020 11:46pm by roy chen

roy chen
2,659 Points
1 Answer
Maryam Naz
3,636 Points
how to combine "AS" statement so I wont have to re-type AS each time?

Posted December 31, 2019 12:51am by Maryam Naz

Maryam Naz
3,636 Points
1 Answer
DCI Seven
828 Points
SELECT name AS "Product Name", description AS "Product Description" FROM products;

Posted December 3, 2019 7:28pm by DCI Seven

DCI Seven
828 Points
2 Answers
Jessica Schteiden
3,254 Points
Issue with Concatenation Function

Posted November 16, 2019 4:43am by Jessica Schteiden

Jessica Schteiden
3,254 Points
1 Answer
Jerry Lombardo
945 Points
Date Datatypes Task

Posted November 14, 2019 9:49pm by Jerry Lombardo

Jerry Lombardo
945 Points
4 Answers
terri ray
870 Points
I am not sure what I did wrong: select id as "Username",first_name as "First Name",last_name as "Last Name" from users;

Posted November 11, 2019 11:51am by terri ray

terri ray
870 Points
1 Answer
Seth Johnson
15,200 Points
Question about use of aliases in query statements...

Posted November 8, 2019 2:29am by Seth Johnson

Seth Johnson
15,200 Points
- Databases
2 Answers
Jerry Lombardo
945 Points
Getting the Grand Total exercise

Posted November 1, 2019 9:36pm by Jerry Lombardo

Jerry Lombardo
945 Points
1 Answer
Jerry Lombardo
945 Points
Concatenation

Posted October 24, 2019 9:12pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
Kimberlee Johnson
5,343 Points
Small typo in "Changine" questions (SQL Playground - Stage 2 Practice)?

Posted October 23, 2019 5:47pm by Kimberlee Johnson

Kimberlee Johnson
5,343 Points
1 Answer
Steve Rogers
3,285 Points
Counting issue?

Posted October 21, 2019 2:24pm by Steve Rogers

Steve Rogers
3,285 Points
1 Answer
Ray Thomas
12,478 Points
Does treehouse show how to make an SQL table natively?

Posted October 8, 2019 10:21am by Ray Thomas

Ray Thomas
12,478 Points
- Databases
1 Answer
Orchid Li
2,024 Points
In the library database there's a patrons table with the columns id, first_name, last_name, address, email, library_id,

Posted October 7, 2019 7:02pm by Orchid Li

Orchid Li
2,024 Points
2 Answers
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
Could someone pls tell me whats wrong with this statement.

Posted October 2, 2019 7:39pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
4 Answers
Zach Johnston
2,500 Points
I'm not sure how this isn't pulling the correct count. SELECT COUNT(genre) AS genre_count FROM books GROUP BY genre

Posted September 16, 2019 10:43pm by Zach Johnston

Zach Johnston
2,500 Points
1 Answer
PLUS

Emily Payne
Courses Plus Student 6,433 Points
Where is the MongoDB course?

Posted September 10, 2019 5:11pm by Emily Payne

Emily Payne
Courses Plus Student 6,433 Points
- Databases
2 Answers
Dharmesh Nayee
1,090 Points
I get the Bummer message saying that i need to add the 4 columns. What is wrong with my code?

Posted August 29, 2019 9:00pm by Dharmesh Nayee

Dharmesh Nayee
1,090 Points
3 Answers
sevdiye ozlutas
1,453 Points
What should be the SQL code for challenge one? I have tried different ways but it keeps giving me an error

Posted August 26, 2019 12:52pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
3 Answers
Marcus Yang
7,476 Points
I don't know what's wrong with my SQL statement. Pls help!

Posted August 24, 2019 1:57pm by Marcus Yang

Marcus Yang
7,476 Points
2 Answers
Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
Replace question on SQL practice

Posted August 3, 2019 10:32pm by Jesse Dispoto

Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
4 Answers
PLUS

Kate Woodroffe
Courses Plus Student 6,685 Points
Stuck on task 4 of querying relational databases, sub queries assessment

Posted April 29, 2019 1:32pm by Kate Woodroffe

Kate Woodroffe
Courses Plus Student 6,685 Points
4 Answers
lukej
34,222 Points
The meaning of COUNT(1)?

Posted July 28, 2018 12:17pm by lukej

lukej
34,222 Points
2 Answers
ABRAHAM NYONI
9,692 Points
Can someone help me on this challenge on SQL,CALCULATING DATES.

Posted May 10, 2018 10:03am by ABRAHAM NYONI

ABRAHAM NYONI
9,692 Points
8 Answers
Brett Phillips
7,016 Points
Many-to-Many join? What are we actually supposed to be doing here?

Posted October 16, 2017 6:56am by Brett Phillips

Brett Phillips
7,016 Points
- Databases
6 Answers
Juan Sebastian Ortiz
761 Points
Challenge Task 2 of 2 SQL

Posted October 6, 2017 6:01pm by Juan Sebastian Ortiz

Juan Sebastian Ortiz
761 Points
- Databases
3 Answers
renhe
10,282 Points
Alternative Soln: Generate a list of students with last names from A to M

Posted August 1, 2017 9:20pm by renhe

renhe
10,282 Points
7 Answers

Prev Page 311 of 389 Next

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