7Zip bulk gzip creation for SQL DB Parts

I have this folder here that contains the multiple sql files and I want to convert them to Gzip using 7Zip. You can only see 10 files but there are 254 files since it is a large database.

I tried the following command for /f %%X in (*.sql) do c:\Program Files\7-Zip\7z.exe a -tgzip %%X.zip %%X but command prompt says The system cannot find the file *.sql.

Even the command with no extension such as (*.) says the same thing that file cannot be found