General doubt about working of capstone project fundamentals

optProfile: `option_id xkey
select
numTrds: count i,
avgEdge: avg edge,
minQty: min qty,
maxQty: max qty
from trade
where date = last date;

why here the (backtick)opion_id doesnt work rather than that sym are not working properly but they ar eworking fine with my local machine

Hi @tanu1
The option_id error may occur because you’re attempting to key the table by option_id, but that column isn’t included in your select statement.
It also asks in the question to break it down by option (screenshot provided) which should hint that a by cause is also needed.
If you have any follow up questions, please let me know!

Screenshot 2025-07-22 095110