Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write queries to answer: - What is the average capacity of the stadium where players who make over $10 million play? - What stadiums
Write queries to answer: - What is the average capacity of the stadium where players who make over $10 million play? - What stadiums are not associated with any teams in the Teams relation? Players Name Sidney Rice Peyton Manning Champ Baily Russel Okung Wesley Woodward Jared Allan Salary Stadiums Name Sports Authority LP Field CenturyLink Field TCF Bank Stadium Soldier Field 8500000 15000000 9500000 7060000 3000000 14280612 Height Weight 6.33 6.42 6 6.42 6 6 City Denver Nashville Seattle Minneapolis Chicago Team Teams Name 202 Seahawks Broncos 230 Broncos Seahawks 192 Broncos Titans 310 Seahawks Vikings 233 270 State Colorado Titans Vikings Tennessee Washington Minnesota Illinois Capacity SID 77160 69143 72000 52525 62871 1001 1002 1003 1007 1004 SID Record Avg. Ticket 1001 13-3 1003 13-3 1002 7-9 1007 5-10 89 81 67 89
Step by Step Solution
There are 3 Steps involved in it
Step: 1
a players who make je tomillion 10X1000000 10000000 Har...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started