SQL in industry

Introduction to SQL with AI

Jasmin Ludolf

Senior Data Science Content Developer

Healthcare

Finance

Retail

Government

Data

Asking the right question

Prompt: What customer data do we have?

SELECT *
FROM customers;

Prompt: Where are our customers from?

SELECT *
FROM customers;

Prompt: What country is each customer from?

SELECT name, country
FROM customers;

Prompt: Show me the first five products from the products table

SELECT product_name
FROM products
LIMIT 5;

|product_name|
|------------|
|Laptop      |
|Desktop     |
|Gaming      |
|Mouse       |
|Keyboard    |

Prompt: Show me the customer names as first_name

SELECT name AS first_name
FROM customers;

|first_name|
|----------|
|Madison   |
|Giovanni  |
|Olivia    |
|Brady     |
...

Analyst showing their report

Introduction to SQL with AI