Question: Fill in the missing words to complete the query, which finds the average square footage ( s _ floor _ space ) for each state.
Fill in the missing words to complete the query, which finds the average square footage sfloorspace for each state.
SELECT sstate, sfloorspace
from TABLE
sstate;
SUM, HAVING
COUNT, ORDER BY
AVG, GROUP BY
MAX, ORDER BY
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
