Post and Team NamesCompany: Slack | Difficulty: easy

Write a query to return the post_id and the team_name for every post. Combine the user_posts and teams tables using their shared team identifier.

Sort the results by post_id in descending order.

Table Schema

Table	Column	Type
`user_posts`	`post_id`	integer
`user_posts`	`team_id`	integer
`teams`	`team_id`	integer
`teams`	`team_name`	varchar(80)

Example Input: `user_posts`

post_id	team_id
1	10
2	10
3	20

Example Input: `teams`

team_id	team_name
10	Core Platform
20	Enterprise Sales

Example Output Explanation

Posts 1 and 2 belong to the Core Platform team, while post 3 belongs to the Enterprise Sales team. The result is ordered by post_id from highest to lowest.

SchemaDROP TABLE IF EXISTS user_posts; DROP TABLE IF EXISTS teams; CREATE TABLE user_posts ( post_id INT, team_id INT ); CREATE TABLE teams ( team_id INT, team_name VARCHAR(80) ); INSERT INTO user_posts VALUES (1, 10), (2, 10), (3, 20); INSERT INTO teams VALUES (10, 'Core Platform'), (20, 'Enterprise Sales');← All SQL Challenges · Slack Questions · Learn SQL Free