Home › Forums › KX Academy › Advanced capstone 2.2
-
Advanced capstone 2.2
Posted by timbs_1995 on May 2, 2024 at 10:59 amDoes anyone know why my code won’t pass it fully it fails the “contain all columns for 2nd Jan 2020” section of the test for 2.2.
lapTable: select date: 2020.01.02, sensorId, session, lapId, time, endTime, sensorValue from lap
thats my code for 2.2
timbs_1995 replied 7 months, 3 weeks ago 2 Members · 8 Replies -
8 Replies
-
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
-
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
-
Hi @timbs_1995
Sorry my mistake – you must add the name of the directory.
Which in this case is f1:
\l f1
Thanks,
Megan
-
-
-
I’m getting the same error
-
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
-
Why does it say theres no such file or directory?
Log in to reply.