Instructional Style

I have just completed a few lesson with SQL and although it seems clear
enough, there isn’t an opportunity to test my own knowledge. As a
retired professional educator, I question the value of given the code
every time. Who do you have planning your educational approach?
Do they consider various learning needs or is everyone expected to learn the same way?

I need to be able to see if I grasp the organization of
syntax and when I am given it every time then I have no chance to think
it through. Would it not better to have some of the question open ended
and then give the correct syntax?

I’m serious about wanting to learn this but I’m not sure how much I will maintain within this approach.