Discover how to effectively learn SQL using ChatGPT, a powerful ... and the correct usage of clauses like “SELECT,” “WHERE,” “GROUP BY” and “ORDER BY.“ Example: Using GROUP BY in SQL.

Send the prompt to OpenAI’s GPT-3.5-turbo API and request an SQL query to answer your question. Run the SQL that comes back on your data set to calculate your answer.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

In the SQL code, I used fully qualified column names because I’m directly comparing the two tables, not merely using the result set as a passive resource. I’m not returning results from the ...