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.

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 ...