Advanced capstone 2.2

[megan_mcp]

Hi @timbs_1995

It states in the exercise that you must load the lap table from disk.

To do we use the system command:

\l

**Tip: Instead of listing each individual column, you can simply run

select from lap

To retrieve the entire lap table.

Hope this helps!

Thanks,

Megan

[timbs_1995]

when i go use the system command like so

\l lapTable: select date,sensorId, session, lapId, time, endTime, sensorValue from lap where date = 2020.01.02

it says its not implemented

[megan_mcp]

Hi @timbs_1995

Sorry my mistake – you must add the name of the directory.

Which in this case is f1:

\l f1

Thanks,

Megan

• This reply was modified 2 weeks, 2 days ago by  megan_mcp.

[timbs_1995]

I’m getting the same error

Screenshot-2024-05-02-142825.png 95 KB Image File - Click to view

• Copy Download Link

[megan_mcp]

Hi @timbs_1995

The \l f1 command simply loads in the lap data from disk.

You must then preform your select statement for lapTable.

Thanks,

Megan

[timbs_1995]

Why does it say theres no such file or directory?

Screenshot-2024-05-02-143750.png 108 KB Image File - Click to view

• Copy Download Link

[megan_mcp]

Does it pass the tests anyway?

[timbs_1995]

No it fails all of the 2.2 sections test