Question 13 5 pts Consider again the following relation about public transport usage data of users tapping on/off with t

[answerhappygod]

Question 13 5 Pts Consider Again The Following Relation About Public Transport Usage Data Of Users Tapping On Off With T 1 (72.8 KiB) Viewed 30 times

Question 13 5 pts Consider again the following relation about public transport usage data of users tapping on/off with their Opal cards: CardEvents (id: integer, day: date, card: integer, mode: text, tap_on: timestamp, tap_off: timestamp ) This table contains a record for each trip on the Sydney public transport network with corresponding tap on and tap_off timestamps as well as the day when the trip started, the card number used, and which mode of transport was used ('bus', 'lightrail', 'train' or 'ferry'). For this scenario, give 1. an example of an SQL SELECT query, and 2. a corresponding CREATE INDEX statement so that your query will be executed with an index-only execution plan using your index.