Line1 SELECT AVG(AnnualsSales) AS AvgSale, COUNT(RestaurantID), SquareFootage FROM Restaurants Line 5 HAVING AvgSale >= 500000; Line 5 (new) HAVING AVG(AnnualsSales) >= 500000;
Added by Danielle H.
Close
Step 1
SELECT AVG(AnnualSales) AS AvgSale, COUNT(RestaurantID), SquareFootage FROM Restaurants This line selects the average annual sales, the count of restaurant IDs, and the square footage from the Restaurants table. Show more…
Show all steps
Your feedback will help us improve your experience
James Kiss and 92 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
The number of customers per day visiting a restaurant was recorded in the security's logbook over a month period. Day | No. of Customers | Day | No. of Customers | Day | No. of Customers ---|---|---|---|---|--- 1 | 24 | 11 | 38 | 21 | 78 2 | 28 | 12 | 45 | 22 | 40 3 | 29 | 13 | 55 | 23 | 42 4 | 35 | 14 | 68 | 24 | 35 5 | 40 | 15 | 39 | 25 | 46 6 | 50 | 16 | 42 | 26 | 50 7 | 80 | 17 | 48 | 27 | 75 8 | 25 | 18 | 45 | 28 | 85 9 | 35 | 19 | 52 | 29 | 30 10 | 35 | 20 | 65 | 30 | 36 a. Determine the mean, median, and mode.
T. L.
Determine the mean, median, and mode for the following data set, which shows online reviews of a restaurant: 1, 4, 2, 5, 3, 4, 1, 4, 4, 3
Tim T.
Create a data set that meets the following criteria: 9 data points, median is 3.5, mean is -0.25. Answer should should be a list of numbers separated by commas. For example: 1, 2, 3, 4, 5.
Manisha S.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Watch the video solution with this free unlock.
EMAIL
PASSWORD