Treehouse | Community | Using a Subquery to Create a Temporary Table (Part 2)

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

⭐Get support and network on our Discord server! ⭐

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

jlampstack
23,932 Points
Is There a Sales Table?

Posted April 11, 2017 11:42am by jlampstack

jlampstack
23,932 Points
1 Answer
Mikko Metso
22,375 Points
Quiz | Review: Reporting with SQL :The operator you'd use to add two pieces of text together in SQLite/SQL Playground

Posted April 10, 2017 8:31am by Mikko Metso

Mikko Metso
22,375 Points
- Databases
1 Answer
PLUS

Madhuri Maddala
Courses Plus Student 793 Points
Create a report from the customers table that shows their first initial of their first name and alias it as initial. Sel

Posted April 10, 2017 3:48am by Madhuri Maddala

Madhuri Maddala
Courses Plus Student 793 Points
- Databases
3 Answers
Joshua Hardy
17,317 Points
Assistance with code error.

Posted April 10, 2017 12:41am by Joshua Hardy

Joshua Hardy
17,317 Points
- Databases
1 Answer
Shawn Boyd
6,907 Points
We're still using the library database there's a books table. There's a title, author, genre and first_published column.

Posted April 9, 2017 9:25am by Shawn Boyd

Shawn Boyd
6,907 Points
- Databases
0 Answers
Frederick Alcantara
7,617 Points
Trying to move items from a shopping cart back to the inventory

Posted April 9, 2017 1:13am by Frederick Alcantara

Frederick Alcantara
7,617 Points
- Databases
0 Answers
Jeremy Mathew
852 Points
Love the lecture just curious on one thing. Why is it that Title didn't need quotes like "First Published"? Thanks again

Posted April 9, 2017 12:45am by Jeremy Mathew

Jeremy Mathew
852 Points
3 Answers
Abe Layee
8,378 Points
I am trying to get the average in descending order from three column.

Posted April 7, 2017 10:31pm by Abe Layee

Abe Layee
8,378 Points
- Databases
2 Answers
PLUS

Madhuri Maddala
Courses Plus Student 793 Points
Obtain the actor records between the 701st and 720th records using only LIMIT and OFFSET

Posted April 7, 2017 4:43am by Madhuri Maddala

Madhuri Maddala
Courses Plus Student 793 Points
2 Answers
PLUS

Anjali Rana
Courses Plus Student 842 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 6, 2017 10:48pm by Anjali Rana

Anjali Rana
Courses Plus Student 842 Points
- Databases
2 Answers
eberhapa
51,495 Points
Tool for practicing SQL commands offline for mac

Posted April 6, 2017 5:10pm by eberhapa

eberhapa
51,495 Points
- Databases
1 Answer
Wendy Radford-Gaby
981 Points
Does anyone have experience in optimising a MySQL database on Google Cloud platform?

Posted April 6, 2017 9:55am by Wendy Radford-Gaby

Wendy Radford-Gaby
981 Points
- Databases
0 Answers
Ahmed Abdalla
5,250 Points
Any advanced upcoming courses on SQL ?

Posted April 5, 2017 4:14pm by Ahmed Abdalla

Ahmed Abdalla
5,250 Points
- Databases
1 Answer
antonio amicone
8,210 Points
i'm kinda lost on what it's asking

Posted April 5, 2017 2:10pm by antonio amicone

antonio amicone
8,210 Points
- Databases
0 Answers
PLUS

tonypitkin2
Courses Plus Student 1,950 Points
Formatting Dates in a simple way?

Posted April 4, 2017 7:26pm by tonypitkin2

tonypitkin2
Courses Plus Student 1,950 Points
3 Answers
nicholasgryczewski
2,919 Points
query

Posted April 4, 2017 2:14am by nicholasgryczewski

nicholasgryczewski
2,919 Points
- Databases
1 Answer
Jonatan Spahn
6,362 Points
Multiple Inner Joins

Posted April 3, 2017 11:33pm by Jonatan Spahn

Jonatan Spahn
6,362 Points
- Databases
1 Answer
PLUS

Rania Mohamed
Courses Plus Student 1,333 Points
reporting wit SQL, challenge Task giving error

Posted April 3, 2017 2:13pm by Rania Mohamed

Rania Mohamed
Courses Plus Student 1,333 Points
- Databases
1 Answer
Aurelio Decock
14,607 Points
Anonymous ID for voting system

Posted April 1, 2017 9:26pm by Aurelio Decock

Aurelio Decock
14,607 Points
- Databases
1 Answer
Jan Lundeen
5,886 Points
SQL Stage 4: Practice Problems: Find all loans that are overdue - not sure if my query is right.

Posted April 1, 2017 1:31am by Jan Lundeen

Jan Lundeen
5,886 Points
- Databases
2 Answers
Adriano De Oliveira
5,653 Points
> SELECT last_name FROM phone_book WHERE last_name IS NOT NULL;

Posted March 31, 2017 6:47pm by Adriano De Oliveira

Adriano De Oliveira
5,653 Points
- Databases
2 Answers
Adriano De Oliveira
5,653 Points
i would like some help topic database paging through results!!!!!!!!!!!!!!!!

Posted March 30, 2017 3:01pm by Adriano De Oliveira

Adriano De Oliveira
5,653 Points
- Databases
2 Answers
Sean Loke
14,659 Points
STAGE 3: PRACTICE MOVIES BEGINNING WITH ALIEN AND WILL OF ACTORS

Posted March 29, 2017 4:17am by Sean Loke

Sean Loke
14,659 Points
- Databases
2 Answers
Jonatan Spahn
6,362 Points
User Average Rating, a little more advanced using subqueries

Posted March 29, 2017 12:54am by Jonatan Spahn

Jonatan Spahn
6,362 Points
1 Answer
Adriano De Oliveira
5,653 Points
We're back on the smartphone, but our phone_book is a mess. There's a phone_book table but there's missing information i

Posted March 28, 2017 12:26pm by Adriano De Oliveira

Adriano De Oliveira
5,653 Points
- Databases
2 Answers
Elizabeth Hicks
44,877 Points
Reporting with SQL - Counting Groups challenge task #2 - not obvious from video

Posted March 28, 2017 1:33am by Elizabeth Hicks

Elizabeth Hicks
44,877 Points
- Databases
1 Answer
Ryan Quinn
2,027 Points
In Concatenation, I don't know how or where to add the <> to the email after first_name last_name.

Posted March 28, 2017 1:26am by Ryan Quinn

Ryan Quinn
2,027 Points
- Databases
1 Answer
Vaidas Staugaitis
1,431 Points
Auto incremented ID after deleting rows

Posted March 26, 2017 4:59pm by Vaidas Staugaitis

Vaidas Staugaitis
1,431 Points
1 Answer
Malaya Manjula
6,028 Points
What am i doing wrong here

Posted March 25, 2017 11:19pm by Malaya Manjula

Malaya Manjula
6,028 Points
- Databases
1 Answer
Byron Injeeli
Full Stack JavaScript Techdegree Graduate 25,639 Points
Challenge - "count number of orders with status of shipped and shipped date as today". My result is 149.

Posted March 25, 2017 5:22pm by Byron Injeeli

Byron Injeeli
Full Stack JavaScript Techdegree Graduate 25,639 Points
- Databases
1 Answer

Prev Page 67 of 388 Next

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