Access Homework

profiledevilmycry1
restaurantsedited.accdb
Home>Computer Science homework help>Access Homework
FranchiseeID FirstName LastName HomeAddress HomeCity HomeState HomeZip HomePhone CellPhone CreditRating
F001 James Antonucci 8990 SW 71 Avenue Miami FL 33176 3057778888 3055909090 AA
F002 Dottie Balchunas 400 Canopy Blvd Pensacola FL 32504 8502221111 8502229898 B
F003 Steve Spann 5900 West Highway Boca Raton FL 33427 5619991199 5618998899 a
F004 Benjamin Grauer 4 Grove Road Orlando FL 32801 4074448888 4076662266 C
F005 Megan Miller 903 SW 1 Street Vero Beach FL 32960 4073330033 4074449900 B
F006 Jessica Kinzer 1239 College Drive Gainesville FL 32601 3529990044 3529998811 C
F007 Carlos Portu 500 Highway East Miami FL 33176 3057878778 3058899877 AA
RestaurantID Address City State Zipcode Phone AnnualSales SquareFootage DateOpened TypeofService Visa/MasterCard AmericanExpress DiscoverCard FranchiseeID
R0001 2345 SW 98 Street Miami FL 33133 3054448787 ¤ 575,000.00 2000 6/1/98 Table Service true false true F001
R0002 3487 Main Highway Pensacola FL 32504 8508865555 ¤ 350,000.00 1000 4/15/99 Table & Take-out true false false F002
R0003 89 Turnberry Drive Orlando FL 32801 4075559999 ¤ 750,000.00 2500 1/1/00 Table Service true true true F004
R0004 4598 SW 136 Street Miami FL 33156 3054444444 ¤ 200,000.00 750 3/1/98 Take-out true false false F001
R0005 9000 Biscayne Blvd Tallahassee FL 32301 9042221111 ¤ 800,000.00 2200 12/1/00 Table & Take-out true true true F003
R0006 2 State Street Boca Raton FL 33427 5614441100 ¤ 175,000.00 750 5/1/01 Take-out false false false F003
R0007 8990 SE 2 Avenue Miami FL 33133 3057877889 ¤ 500,000.00 1800 3/31/01 Table Service true true true F001
R0008 298 W 75 Terrace Vero Beach FL 32960 4072229999 ¤ 350,000.00 2850 6/1/00 Table & Take-out true false false F005
R0009 1000 Grand Avenue Gainesville FL 32601 3526667788 ¤ 1,000,000.00 1000 5/31/99 Take-out true false false f006
R0010 6767 NW 75 Street Miami FL 33120 3058878877 ¤ 750,000.00 1200 4/3/99 Table Service true true false f005
SELECT Count(Restaurants.RestaurantID) AS NumRestaurant, Restaurants.City, Avg(Restaurants.AnnualSales) AS AvgSale, Sum(Restaurants.SquareFootage) AS SqFtTotal, Min(Restaurants.DateOpened) AS EarliestOpened, Max((Now()-[dateopened])/365) AS LongestInBiz, Max(Restaurants.SquareFootage) AS BigStore FROM Restaurants GROUP BY Restaurants.City;
SELECT Count(Restaurants.RestaurantID) AS CountOfRestaurantID, Avg(Restaurants.AnnualSales) AS AvgOfAnnualSales, Sum(Restaurants.SquareFootage) AS SumOfSquareFootage, Min(Restaurants.DateOpened) AS MinOfDateOpened, Restaurants.TypeofService FROM Restaurants GROUP BY Restaurants.TypeofService;