Fundamentals Capstone 1.3

[megan_mcp]

Hi ,

Yes  is correct you should use ‘exec’ instead of ‘select’ – however this is the syntax for the statement you need:

exec ... from select ... from ...

exec keyword | Reference | kdb+ and q documentation – Kdb+ and q documentation (kx.com)

If you have any questions please let me know,

Megan

[kdbguru]

Hi,

As the question asks to extract “symbol list” of all the unique options, you should use “exec” rather than “select”. While “select” returns the result of a table type, “exec” for a single column would return a list of values.

uniqueOpts: exec distinct option_id from trade

[laura]

Hi  ,

You can use “select from” to extract the column from the trade table on disk, and then use “exec from” to extract the data from that column as a list.

To help you complete the capstone project you should first go through the course materials on KX Academy, specifically Fundamentals: qSQL queries will help with this question, or check out the link that Megan sent previously exec keyword | kdb+ and q documentation.

Hope this helps,

Laura