Student Two with Project Two - list of different Seating type total number of each Seating type maximum number of Seats for each Seating type with its Trading name, Street address and location

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers
Section: Chapter Questions
Problem 8EYW
icon
Related questions
Question
Write the queries of this list
Student Two with Project Two
- list of different Seating type
- total number of each Seating type
- maximum number of Seats for each Seating type with its Trading
name, Street address and location
Transcribed Image Text:Student Two with Project Two - list of different Seating type - total number of each Seating type - maximum number of Seats for each Seating type with its Trading name, Street address and location
帕Copy
Calibri
11
A A
Wrap Text
General
Paste
BIU
A E = EEE E Merge & Center -
VFormat Painter
$- % , 00 Conditional Format as
Cell
Formatting Table Styles
.00 .0
Insert Del
Clipboard
Font
Alignment
Number
Styles
Ce
E9
fe
U-Rail
1 x
Y
OBJECTID
AssetID
H
|Туре
Bike Maintenance Stand
404691 Bike Maintenance Stand
394233 Bike Maintenance Stand
StreetName
Suburb
Postcode
151.2024332 -33.87430961
151.2161059 -33.88325102
151.198217 -33.87023501
2
1461 BIKE15
Harbour Street
Sydney
2000
1462
Bourke Street
Surry Hills
Sydney
Sydney
Haymarket
4
2010
1463
Darling Drive
Liverpool Street
Ultimo Road
151.212075 -33.87651806
1464
2000
404840 Bike Maintenance Stand
151.202647 -33.88091401
2000
1465
406023 U-Rail
2000
151.202678
-33.880904
1466
406025 U-Rail
Ultimo Road
Haymarket
2000
8.
151.209721 -33.88128899
1467
404903 U-Rail
Reservoir Street
Surry Hills
Sydney
2010
9.
151.207949 -33.87457699
1468
405330 U-Rail
Pitt Street
2000
10
151.208954 -33.87470603
1469
405304 U-Rail
Castlereagh Street
Sydney
2000
11
151.203028 -33.85838099
1470
405841 U-Rail
Argyle Place
Millers Point
2000
12
151.191976 -33.86385701
1471
394191 U-Rail
Pirrama Road
Pyrmont
2009
13
151.2033759 -33.87945697
1472
405802 U-Rail
Hay Street
Haymarket
2000
14
151.203403 -33.87946404
1473
405803 U-Rail
Hay Street
Haymarket
2000
15
151.2034361 -33.87946606
1474
405804 U-Rail
Hay Street
Haymarket
Haymarket
2000
16
151.203439 -33.87946006
1475
405805 U-Rail
Hay Street
2000
17
151.207345 -33.85570103
1476
406089 U-Rail
Hickson Road
Millers Point
2000
18
151.207322
-33.85573
1477
406090 U-Rail
Pottinger Street
Dalgety Road
Dawes Point
2000
19
151.202358 -33.85800898
1478
406199 U-Rail
Millers Point
2000
20
151.197133 -33.87010706
1479
394229 U-Rail
Pyrmont Bridge Road
Pyrmont
2009
21
151.2014929 -33.88260001
1480
406186 U-Rail
Harris Street
Ultimo
2007
22
151.2015
-33.882581
1481
406187 U-Rail
Harris Street
Ultimo
2007
23
151.201469 -33.88255404
1482
406188 U-Rail
Harris Street
Ultimo
2007
161201AA1
22. 002 E0204
1402
405100 LLDoil
Herric ctrant
2007
Bicycle parking
Ready
23
图
Transcribed Image Text:帕Copy Calibri 11 A A Wrap Text General Paste BIU A E = EEE E Merge & Center - VFormat Painter $- % , 00 Conditional Format as Cell Formatting Table Styles .00 .0 Insert Del Clipboard Font Alignment Number Styles Ce E9 fe U-Rail 1 x Y OBJECTID AssetID H |Туре Bike Maintenance Stand 404691 Bike Maintenance Stand 394233 Bike Maintenance Stand StreetName Suburb Postcode 151.2024332 -33.87430961 151.2161059 -33.88325102 151.198217 -33.87023501 2 1461 BIKE15 Harbour Street Sydney 2000 1462 Bourke Street Surry Hills Sydney Sydney Haymarket 4 2010 1463 Darling Drive Liverpool Street Ultimo Road 151.212075 -33.87651806 1464 2000 404840 Bike Maintenance Stand 151.202647 -33.88091401 2000 1465 406023 U-Rail 2000 151.202678 -33.880904 1466 406025 U-Rail Ultimo Road Haymarket 2000 8. 151.209721 -33.88128899 1467 404903 U-Rail Reservoir Street Surry Hills Sydney 2010 9. 151.207949 -33.87457699 1468 405330 U-Rail Pitt Street 2000 10 151.208954 -33.87470603 1469 405304 U-Rail Castlereagh Street Sydney 2000 11 151.203028 -33.85838099 1470 405841 U-Rail Argyle Place Millers Point 2000 12 151.191976 -33.86385701 1471 394191 U-Rail Pirrama Road Pyrmont 2009 13 151.2033759 -33.87945697 1472 405802 U-Rail Hay Street Haymarket 2000 14 151.203403 -33.87946404 1473 405803 U-Rail Hay Street Haymarket 2000 15 151.2034361 -33.87946606 1474 405804 U-Rail Hay Street Haymarket Haymarket 2000 16 151.203439 -33.87946006 1475 405805 U-Rail Hay Street 2000 17 151.207345 -33.85570103 1476 406089 U-Rail Hickson Road Millers Point 2000 18 151.207322 -33.85573 1477 406090 U-Rail Pottinger Street Dalgety Road Dawes Point 2000 19 151.202358 -33.85800898 1478 406199 U-Rail Millers Point 2000 20 151.197133 -33.87010706 1479 394229 U-Rail Pyrmont Bridge Road Pyrmont 2009 21 151.2014929 -33.88260001 1480 406186 U-Rail Harris Street Ultimo 2007 22 151.2015 -33.882581 1481 406187 U-Rail Harris Street Ultimo 2007 23 151.201469 -33.88255404 1482 406188 U-Rail Harris Street Ultimo 2007 161201AA1 22. 002 E0204 1402 405100 LLDoil Herric ctrant 2007 Bicycle parking Ready 23 图
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Probability Problems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L