Question

For all problems, use a single word alias (no quote marks) for any calculated fields. Limit long output to the first 5 rows by adding LIMIT 5 as the last row in your SQL select statement. Examples: SELECT AVG(amount) AS Avg_Payment LIMIT 5 The following questions use aggregate functions and all will require a GROUP BY clause. Some of them will require a HAVING clause if you are making selection criteria based on results from aggregated functions.

6. Show the number of customers and average credit limit for customers in zip code (postalCode) 94217. Use appropriate aliases and round the average credit limit to 0 decimal places. (HINT: use a WHERE clause for the zip code.)

Answer 1

SELECT COUNT(CustID) as NUM_Customers, ROUND(AVG(Credit_Limit),0) as Average_Credit_Limit FROM Customers WHERE Zip_Code=94217 LIMIT 5;

as the schema was not provided I assumed that the The table name is Customers, and it has columns CustID for customer ID, Credit_Limit and Zip_Code in the table.

if you like the answer please provide a thumbs up, and in case of any confusion feel free to write in the comments section.