KX SQL project

https://learninghub.kx.com/forums/topic/kx-sql-project

I’m currently trying to complete the KX SQL challenge, and I’m unsure why my defined variable doesn’t have the correct sql syntax? Any sort of guidance would be appreciated!

 

 

 

 

 

The question is asking you to save your SQL code to variable ex1. What you are doing instead is executing the query and putting the result into ex1. This is why the second check passes (since the CREATE TABLE was executed) but the first one fails (because the variable doesn’t contain the SQL command).