Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following table schema Write a select statement that performs the following: 1. Select the cities where the games played had total scores between

Given the following table schema

image text in transcribed

Write a select statement that performs the following:

1. Select the cities where the games played had total scores between 12 and 20. REMEMBER points only tracks one player's points on a team, so this should be a sum of all points scored by players on a specific team.

2. Select the names of the teams that played in every single arena.

Do not select duplicate entries.

team team_ID tname rank city championships INTEGER INTEGER VARCHAR(15) INTEGER VARCHAR(20) player team_player_arena player_ID pname positiorn draft_year retire_year INTEGER education VARCHAR(30) INTEGER VARCHAR(30) VARCHAR(20) INTEGER team ID INTEGER player ID INTEGER arena ID INTEGER points INTEGER arena arena ID INTEGER aname VARCHAR(20) city VARCHAR(20)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud

Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic

1st Edition

1484263693, 978-1484263693

More Books

Students also viewed these Databases questions

Question

Prepare a selling and administrative expenses budget.

Answered: 1 week ago

Question

Understand the process of arbitration

Answered: 1 week ago

Question

LO4 Provide an overview of four challenges facing HR today.

Answered: 1 week ago