Treehouse | Community | Set 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

Max Toth
3,777 Points
I've tried both approaches to a WHERE clause limiting names to '[a-k]%' (or NOT LIKE '[l-z]%' but neither does the trick

Posted April 23, 2021 8:24pm by Max Toth

Max Toth
3,777 Points
1 Answer
Beckett Brees
3,390 Points
I am being told I am missing a column but cannot find it - id, home_team, home_score, away_team, away_score, played_on.

Posted March 17, 2021 10:07am by Beckett Brees

Beckett Brees
3,390 Points
1 Answer
Chun Yin Lau
3,769 Points
don't under question database count/distinct

Posted July 6, 2017 5:05am by Chun Yin Lau

Chun Yin Lau
3,769 Points
- Databases
2 Answers
donald kaiser
9,736 Points
It's saying that I'm missing the division operator but why in God's name would I need that?

Posted June 28, 2017 9:05pm by donald kaiser

donald kaiser
9,736 Points
- Databases
2 Answers
PLUS

Christopher Morris
Courses Plus Student 509 Points
Not Sure How to Proceed

Posted June 28, 2017 6:29pm by Christopher Morris

Christopher Morris
Courses Plus Student 509 Points
- Databases
0 Answers
PLUS

Fabio Campanini
Courses Plus Student 1,544 Points
Hi, I'm not able to overcome task 2/6 of the set operations challenges

Posted June 15, 2017 3:38pm by Fabio Campanini

Fabio Campanini
Courses Plus Student 1,544 Points
- Databases
4 Answers
Xavier Swehla
2,852 Points
why does the following code not work?

Posted June 14, 2017 8:52pm by Xavier Swehla

Xavier Swehla
2,852 Points
- Databases
1 Answer
PLUS

Manish Barik
Courses Plus Student 4,058 Points
How do I show next week in SQL, i,e. starting from coming Sunday to the following Saturday?

Posted June 6, 2017 9:40am by Manish Barik

Manish Barik
Courses Plus Student 4,058 Points
1 Answer
PLUS

Stephen Funk
Courses Plus Student 2,650 Points
Date Formatting for all date columns

Posted May 31, 2017 4:09pm by Stephen Funk

Stephen Funk
Courses Plus Student 2,650 Points
- Databases
3 Answers
PLUS

Chris Gauthier
Courses Plus Student 6,434 Points
Using Concatenate to format text in a sql statement

Posted May 30, 2017 9:20pm by Chris Gauthier

Chris Gauthier
Courses Plus Student 6,434 Points
- Databases
1 Answer
PLUS

Stephen Funk
Courses Plus Student 2,650 Points
For the BETWEEN objective test, using the BETWEEN statement ONLY errors. HELP

Posted May 30, 2017 1:31am by Stephen Funk

Stephen Funk
Courses Plus Student 2,650 Points
- Databases
6 Answers
Jan Lundeen
6,201 Points
Subqueries - Challenge 4 of 4 - still getting error

Posted May 29, 2017 1:50am by Jan Lundeen

Jan Lundeen
6,201 Points
- Databases
5 Answers
Ni Yao
3,852 Points
App crashes when deleting

Posted May 27, 2017 10:30pm by Ni Yao

Ni Yao
3,852 Points
- Databases
0 Answers
David Greenstein
6,734 Points
i am producing the right output but saying it is wrong

Posted May 18, 2017 8:54pm by David Greenstein

David Greenstein
6,734 Points
- Databases
0 Answers
PLUS

hari krishnan
Courses Plus Student 33 Points
How to update user's data?

Posted May 18, 2017 2:10am by hari krishnan

hari krishnan
Courses Plus Student 33 Points
- Databases
2 Answers
Sanjay Dulal
1,269 Points
What's the missing ?

Posted April 28, 2017 6:22pm by Sanjay Dulal

Sanjay Dulal
1,269 Points
- Databases
1 Answer
James Moran
7,271 Points
You have an error in your SQL syntax (trigger was unable to be created)

Posted April 27, 2017 12:47pm by James Moran

James Moran
7,271 Points
- Databases
1 Answer
PLUS

Modure Rares
Courses Plus Student 9,041 Points
How to run sql in Sublime Text??

Posted April 26, 2017 7:22pm by Modure Rares

Modure Rares
Courses Plus Student 9,041 Points
- Databases
1 Answer
Paul Ownby
23,414 Points
I cannot get a correct answer for Task #4 on the last Challenge for Querying Relational Databases. What's wrong?

Posted April 24, 2017 11:15pm by Paul Ownby

Paul Ownby
23,414 Points
- Databases
2 Answers
PLUS

Fabio Campanini
Courses Plus Student 1,544 Points
Can anyone help me to check the code I wrote for the "Calculating Dates" exercise?

Posted April 19, 2017 11:01am by Fabio Campanini

Fabio Campanini
Courses Plus Student 1,544 Points
- Databases
0 Answers
renhe
10,282 Points
Longest Name

Posted April 16, 2017 8:35pm by renhe

renhe
10,282 Points
- Databases
1 Answer
Adriano De Oliveira
5,653 Points
Hello ! I would like some help in this challange. thanks

Posted April 16, 2017 11:45am by Adriano De Oliveira

Adriano De Oliveira
5,653 Points
- Databases
3 Answers
nathanielcusano
9,808 Points
Can you have AND <condition 3> etc?

Posted March 14, 2017 11:26pm by nathanielcusano

nathanielcusano
9,808 Points
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
David Wright
4,437 Points
Task 2 of 3 UNION or JOIN two query results that include EXCEPT clauses

Posted October 3, 2016 7:40pm by David Wright

David Wright
4,437 Points
8 Answers
David Wright
4,437 Points
Task #2 patrons with no loans

Posted October 3, 2016 4:46pm by David Wright

David Wright
4,437 Points
9 Answers
Amos Wu
1,086 Points
I'm having trouble displaying the "<" and ">" around the email.

Posted August 22, 2016 8:40pm by Amos Wu

Amos Wu
1,086 Points
- Databases
3 Answers
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
How do we know what date the order was shipped on?

Posted March 1, 2016 12:19am by Brendan Whiting

Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
- Databases
13 Answers

Prev Page 116 of 389 Next

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