Question

The execution of the query
SELECT BirthPlace, AVG(Age) AS Avgage
FROM CUSTOMER
WHERE BirthPlace = 'TAMPA' OR BirthPlace = 'ERIE'
GROUP BY BirthPlace
will produce the following number of rows:

CUSTOMER Спалье BLACK GREEN JONES MARTIN SIMON VERNON Resid City ERIE CARY HEMET HEMET ERIE CARY | Age 40 23 BirthPlace TAMPA ERIE. TAMPA TAMPA ERIE CARY 30 35 22 60 RENTALS Спалое BLACK BLACK BLACK GREEN JONES JONES Pickup Date Out 10-Oct-1994 |CARY 01-Nov-1995 | TAMPA 01-Jan-1995 ERIE 07-Jul-1994 TAMPA | 01-Jul-1995 | CARY 01-Aug-1995 ERIE 01-Aug-1994 | CARY 01-Sep-1995 ERIE 02-Sep-1995 |RENO Rtn 1 2 3 Make Return CARY CARY ERIE TAMPA ERIE ERIE FORD GM FORD NISSAN FORD GM 4 MARTIN SIMON WARP FORD GM TOYOTA ERIE. CARY RENO 9

Answer 1

SQL Statement: SELECT FROM [customer] Edit the SQL Statement, and click "Run SQL" to see the result. Run SQL > Result: Number of Records: 6 Resid_city BirthPlace Cname Age BLACK 40 ERIE ТАMPA GREEN 25 CARY ERIE ZONES 30 НЕМЕТ TAMPA MARTIN 35 НЕМЕТ ТАMPA SIMON 22 ERIE ERIE VERNON 60 CARY CARY

SQL Statement: SELECT BirthPlace, AVG(Age) AS Avgage FROM CUSTOMER WHERE BirthPlace 'TAMPA' OR BirthPlace = 'ERIE' = GROUP BY BirthPlace Edit the SQL Statement, and click "Run SQL" to see the result. Run SQL > Result: Number of Records: 2 BirthPlace Avgage ERIE 23.5 TAMPA 35