Editing SQL in excel

[Morty36]

Hiya,

I'm looking for some help with SQL in excel.

At work we are uning Excel 2016 and I am able to edit SQL code in the Definition tab, I've bought Excel at home to have some practice but pretty much the whole deifinition tab is greyed out, any idea why?

I've connected to an example table in another worksheet Get Data --> From File --> From Workbook, and I was hoping to have some practice to get used to SQL syntax and such.


Thank you

https://ibb.co/XCrwBRS

 

[sergioMabres]

Hi Morty,
To get used to SQL syntax and such try
https://sqlbolt.com/lesson/select_queries_introduction