How do I return the name of each trip that has the type Biking and that has a di
ID: 3708004 • Letter: H
Question
How do I return the name of each trip that has the type Biking and that has a distance of greater than 5 miles?
Below pictures are screenshots of the Excel Datafile and an example of the expected result.
Note: This needs to be done in Excel by Logical Functions(AND/OR/NOT/IF) or logical functions with other functions.
State StartLocation Harts Location Weathersfield Weathersfield Lewiston-Auburn ME 1 Arethusa Falls 2 Mt Ascutney - North Peak 3 Mt Ascutney-West Peak 4 Bradbury Mountain Ride 5 Baldpate Mountain 6 Blueberry Mountain 7 Bloomfield Maidstone 8 Black Pond 9 Big Rock Cave 10 Mt. Cardigan - Firescrew 11 Chocorua Lake Tour 12 Cadillac Mountain Ride 13 Cadillac Mountain 14 Cannon Mtn 15 Crawford Path Presidentials Hike 16 Cherry Pond 17 Huguenot Head Hike 18 Low Bald Spot Hike 6 HikingSpring 10 Hiking Batchelders Grant ME 6 Paddling Spring Summer Tamworth 8 Hiking 15 Paddli Summer Tamworth 6 Hiking Crawford Notch Whitefield NH 16 Hiking 10 Hiking Pinkam Notch North Stratford 7 Paddling Spring 15 Paddling Spring 20 Lake Mephremagog Tour 21 Long Pond 22 Long Pond Tour 23 Lower Pond Tour 24 Mt Adams 25 Mount Battie Ri 26 Mount Cardigan Hike 27 Mt. Chocorua 28 Mount Garfield Hike 29 Metacomet-Monadnock Trail Hike 30 Mclennan Reservation Hike Rutland Greenville HikingSummer 10 Paddling Summer 15 Paddling Spring Randolph Camden Cardigan 10 Hikin 10 Hiking Pelham 10 Paddling Summer 10 Paddling Summer 8 BikingSpring 32 Northern Forest Canoe Trail 33 Park Loo 34 Pontook Reservoir Tour 35 Pisgah State Park Ride 36 Pondicherry Trail Ride 37 Seal Beach Harbor 38 Sawyer River Ride 39 Welch and Dickey Mountains Hike Thorton 40 Wachusett Mountain 41 Westfield River Loop Mount Desert Island ME Northborough White Mountains NH Summer 6 BikingSpring 16 Hiking Mount Carrigain NH Customer Guide |Reservation Trip TripGuides Problem a3 Select destination and press ENTER or choose PasteExplanation / Answer
SQL queries for excel i almost same as that if normal sql queries. Its just the names are written in square bracket and name of the table is appended with '$' token inside its square bracket.
SELECT [TripName] FROM [Trip$]
WHERE [Distance] > 5 AND [TYPE] = 'Biking' ;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.