Fundamentals Capstone 1.3

Academy Support
1

https://learninghub.kx.com/forums/topic/fundamentals-capstone-1-3

Hello,

May someone explain whether I am on the right track for question 1.3.

My Answer: uniqueOpts: select distinct option_id from trade

Have I completely missed the point of the question?

2

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

3

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

4

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