Treehouse | Community | Union Operations

⚡ 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

Hanna Han
4,105 Points
Unions require the number of columns...

Posted June 28, 2018 3:38am by Hanna Han

Hanna Han
4,105 Points
2 Answers
Luis Ponce
2,290 Points
What is wrong with the folllowing query? SELECT name AS Product Name,description AS Product Description, FROM products;

Posted June 25, 2018 4:21pm by Luis Ponce

Luis Ponce
2,290 Points
3 Answers
jlampstack
23,932 Points
Is ID in the Customer_Extension table both primary & foreign key?

Posted June 25, 2018 1:34pm by jlampstack

jlampstack
23,932 Points
2 Answers
jlampstack
23,932 Points
Can you delete a row with a Primary Key?

Posted June 25, 2018 12:36pm by jlampstack

jlampstack
23,932 Points
1 Answer
Hannah Tucker McLellan
1,856 Points
Why doesn't my query work? Name of Fruit and Veg between A - K

Posted June 22, 2018 9:38am by Hannah Tucker McLellan

Hannah Tucker McLellan
1,856 Points
2 Answers
Deborah Watson
2,614 Points
STRFTIME() Bummer: You may have got your params the wrong way around.

Posted June 21, 2018 5:07pm by Deborah Watson

Deborah Watson
2,614 Points
3 Answers
PLUS

Jonathan Pina
Courses Plus Student 157 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames.

Posted June 21, 2018 10:44am by Jonathan Pina

Jonathan Pina
Courses Plus Student 157 Points
2 Answers
Nyasha Mujakachi
4,176 Points
I am failing to see where I am getting it wrong here?

Posted June 21, 2018 6:50am by Nyasha Mujakachi

Nyasha Mujakachi
4,176 Points
1 Answer
Zach Bucek
10,798 Points
Deprecated setup method?

Posted June 15, 2018 5:10pm by Zach Bucek

Zach Bucek
10,798 Points
5 Answers
Michael Martin
8,890 Points
What is wrong here? I don't understand the output matches against itself

Posted June 15, 2018 4:13am by Michael Martin

Michael Martin
8,890 Points
2 Answers
Hanna Han
4,105 Points
Replace usage

Posted June 13, 2018 3:24pm by Hanna Han

Hanna Han
4,105 Points
2 Answers
adam woolf
1,181 Points
there is a bug here. i believe my syntax is correct

Posted June 12, 2018 12:35am by adam woolf

adam woolf
1,181 Points
1 Answer
PLUS

Joe Marcallini
Courses Plus Student 14,835 Points
SELECT genre, COUNT(genre) AS genre_count FROM books GROUP BY genre; Can you please tell me what is wrong with this

Posted June 11, 2018 8:29pm by Joe Marcallini

Joe Marcallini
Courses Plus Student 14,835 Points
2 Answers
Odane Williams
6,692 Points
What "format" do they want the email to be in?

Posted June 8, 2018 9:22pm by Odane Williams

Odane Williams
6,692 Points
1 Answer
Walter Guerrero
6,843 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted June 7, 2018 11:41am by Walter Guerrero

Walter Guerrero
6,843 Points
1 Answer
Noel Thurau
1,021 Points
SQL Count and Distinct task 2 of 2

Posted May 27, 2018 3:28pm by Noel Thurau

Noel Thurau
1,021 Points
- Databases
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
Trouble with Challenge on Min Max values for Query

Posted May 24, 2018 3:15am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
I tried with this query "SELECT SUBSTR(first_name, 1, 1) || " " || last_name AS initial FROM customers;" and return me "

Posted May 22, 2018 2:54am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
2 Answers
Stevan Lay
8,306 Points
What is the correct syntax here?

Posted May 21, 2018 1:42am by Stevan Lay

Stevan Lay
8,306 Points
1 Answer
Terri Valentine
23,034 Points
SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")

Posted May 20, 2018 12:40am by Terri Valentine

Terri Valentine
23,034 Points
1 Answer
Philip Schultz
11,437 Points
Why does UNION ALL work in this case and not just UNION

Posted May 13, 2018 1:10pm by Philip Schultz

Philip Schultz
11,437 Points
2 Answers
John Tester
3,366 Points
longest length

Posted May 9, 2018 9:41pm by John Tester

John Tester
3,366 Points
2 Answers
Ahmed Mohamed Fouad
11,735 Points
A technical problem with the Challenge task 2 of 5

Posted May 8, 2018 9:53pm by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
3 Answers
Hatem Zreek
7,739 Points
Mistake in the Challenge!!!

Posted May 8, 2018 1:23am by Hatem Zreek

Hatem Zreek
7,739 Points
1 Answer
Alexander Salako
360 Points
Find all users 2

Posted May 7, 2018 7:06pm by Alexander Salako

Alexander Salako
360 Points
- Databases
1 Answer
Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
"Hello you futuristic person you." Haha Andrew has grow on me a lot more over the past courses I've taken!

Posted February 27, 2018 6:59pm by Neil Bircumshaw

Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
3 Answers
Khadar Basha Shaik
1,828 Points
Help with this sql query

Posted January 28, 2017 5:40pm by Khadar Basha Shaik

Khadar Basha Shaik
1,828 Points
- Databases
4 Answers
Andreas Frost Nordstrøm-Hansen
2,443 Points
Need help on the SQL Playground. Movies with any missing data

Posted September 6, 2016 1:42pm by Andreas Frost Nordstrøm-Hansen

Andreas Frost Nordstrøm-Hansen
2,443 Points
5 Answers
PLUS

Tej Singh
Courses Plus Student 2,673 Points
Cant got the problem, Help this statement. (SQL)

Posted July 12, 2016 9:23pm by Tej Singh

Tej Singh
Courses Plus Student 2,673 Points
- Databases
4 Answers

Prev Page 139 of 389 Next

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