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.

As an example, SQL was the first programming language to return multiple rows per single request. This makes it easier to get data on what is taking place within a set of data—and consequently ...

With the data in Power Query, it’s time to find the duplicates. There are two duplicate rows, which you can easily find by sorting, but you don’t have to sort when using Power Query.

Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database table and index structures. Maintain table data integrity through constraints. Understand how to ...