Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Grady Robbins
8,249 Points
Reporting with SQL final assesment: i am thrown off by: LIMIT 0, OFFSET 50. should any rows be returned at all?

Posted April 21, 2019 5:23pm by Grady Robbins

Grady Robbins
8,249 Points
2 Answers
Kevin Lewis
12,809 Points
If you're having trouble installing Mongo on Mac.

Posted April 20, 2019 1:10am by Kevin Lewis

Kevin Lewis
12,809 Points
0 Answers
sofia Heikkila Svensson
4,618 Points
Hi, My code is wrong. The bummer answer is : You should try writing a SELECT query.

Posted April 18, 2019 7:33am by sofia Heikkila Svensson

sofia Heikkila Svensson
4,618 Points
1 Answer
Karl Hogben
462 Points
> SELECT * FROM books WHERE genre = "Fantasy" ORDER BY genre ASC LIMIT 5

Posted April 14, 2019 4:33pm by Karl Hogben

Karl Hogben
462 Points
1 Answer
Muhittin Palamutçu
1,750 Points
I need some help for my Sql Query

Posted April 11, 2019 8:57pm by Muhittin Palamutçu

Muhittin Palamutçu
1,750 Points
- Databases
2 Answers
sj sh
122 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted April 11, 2019 8:37am by sj sh

sj sh
122 Points
0 Answers
Aaron Howarth
111 Points
What am I missing here with my syntax?

Posted April 10, 2019 6:53pm by Aaron Howarth

Aaron Howarth
111 Points
1 Answer
Ikechukwu Arum
3,463 Points
ERROR: NO SUCH COLUMN

Posted April 9, 2019 6:41pm by Ikechukwu Arum

Ikechukwu Arum
3,463 Points
3 Answers
PRO

kevin hudson
Pro Student 8,479 Points
No Help needed but want to share Code with mistakes

Posted April 9, 2019 3:58pm by kevin hudson

kevin hudson
Pro Student 8,479 Points
0 Answers
PRO

kevin hudson
Pro Student 8,479 Points
Is it a bad approach to use subqueries over CTE and JOINING?

Posted April 8, 2019 6:20pm by kevin hudson

kevin hudson
Pro Student 8,479 Points
1 Answer
PRO

kevin hudson
Pro Student 8,479 Points
What is penultimate?

Posted April 8, 2019 3:51pm by kevin hudson

kevin hudson
Pro Student 8,479 Points
1 Answer
PRO

kevin hudson
Pro Student 8,479 Points
The first challenge should include GROUP BY

Posted April 8, 2019 2:51pm by kevin hudson

kevin hudson
Pro Student 8,479 Points
4 Answers
Luitzen Hietkamp
7,593 Points
Actor table too large

Posted April 7, 2019 2:15pm by Luitzen Hietkamp

Luitzen Hietkamp
7,593 Points
- Databases
0 Answers
Marat Guysin
1,601 Points
Cannot get the right SQL statement

Posted April 6, 2019 11:28pm by Marat Guysin

Marat Guysin
1,601 Points
1 Answer
PRO

kevin hudson
Pro Student 8,479 Points
Is there an advanced SQL track to follow later on after the beginner's track?

Posted April 5, 2019 1:29am by kevin hudson

kevin hudson
Pro Student 8,479 Points
1 Answer
Ikechukwu Arum
3,463 Points
related to the subquery challenge using the "IN" Keyword

Posted April 4, 2019 6:40pm by Ikechukwu Arum

Ikechukwu Arum
3,463 Points
1 Answer
Francesco Sollitto
2,158 Points
I HAVE ADDED THE PRIMARY KEY ON ID, WHY YOU KEEP REPEATING THE SAME BUMMER????

Posted April 4, 2019 9:03am by Francesco Sollitto

Francesco Sollitto
2,158 Points
1 Answer
Lukas Rohm
4,375 Points
SQL error for selecting all data from customer_address

Posted April 4, 2019 2:54am by Lukas Rohm

Lukas Rohm
4,375 Points
1 Answer
Elise Glynn
529 Points
Why and when would we need to use aliases?

Posted April 2, 2019 3:36pm by Elise Glynn

Elise Glynn
529 Points
1 Answer
Abdullah Salman
6,461 Points
Quiz - Modifying Data with SQL

Posted April 2, 2019 12:38pm by Abdullah Salman

Abdullah Salman
6,461 Points
1 Answer
Chamundeshwari Vadamalai
2,204 Points
How to format the dates?

Posted April 2, 2019 11:46am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer
adam woolf
1,181 Points
select SUM(rating) AS starman_total_ratings From reviews WHERE movie_id="Starman" it says i did not sum correctly

Posted April 2, 2019 4:39am by adam woolf

adam woolf
1,181 Points
1 Answer
Ilya Kotlyar
2,082 Points
Is there a track on online databases?

Posted March 31, 2019 1:18am by Ilya Kotlyar

Ilya Kotlyar
2,082 Points
- Databases
1 Answer
Apoorva Seeram
790 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted March 28, 2019 8:09pm by Apoorva Seeram

Apoorva Seeram
790 Points
2 Answers
Yelson Yang
3,977 Points
How to select all row with missing values?

Posted March 28, 2019 3:48pm by Yelson Yang

Yelson Yang
3,977 Points
- Databases
1 Answer
Gia Hoang Nguyen
3,271 Points
How to find the discrepancy between the current grade 7 students and the future grade 6 students who move to grade 7?

Posted March 27, 2019 3:28am by Gia Hoang Nguyen

Gia Hoang Nguyen
3,271 Points
1 Answer
Michael Nanni
4,549 Points
Does grade level matter to find which subject is least popular?

Posted March 26, 2019 12:49pm by Michael Nanni

Michael Nanni
4,549 Points
- Databases
1 Answer
taherkhan
4,327 Points
Query regarding calculating average

Posted March 24, 2019 9:46am by taherkhan

taherkhan
4,327 Points
1 Answer
Michael Nanni
4,549 Points
My answer to the challenge. Let me know what you think.

Posted March 23, 2019 9:20pm by Michael Nanni

Michael Nanni
4,549 Points
- Databases
1 Answer
Brian Poirier
7,678 Points
select fruit and vegetables. what's wrong with this? SELECT * FROM fruit UNION SELECT * FROM vegetable

Posted March 22, 2019 2:25am by Brian Poirier

Brian Poirier
7,678 Points
1 Answer

Prev Page 1 of 308 Next

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