Course Notes: Introduction to SQL Server (copy)

DataFrameas

customers

variable

SELECT TOP 14 
email,
LEFT(email, CHARINDEX('@', email) -1) AS left_name,
RIGHT(email, 10) AS right_10_strings,
RIGHT(email, LEN(email) - CHARINDEX('@', email)) AS right_email
FROM sales.customers
WHERE email LIKE '%mail%'
ORDER BY first_name;

DataFrameas

df

variable

SELECT TOP 15 
    street,
    LEN(street) AS street_length,
    LEFT(street, 3) AS leng_3,
	RIGHT(street, 2) AS leng_4,
	LEFT(street, CHARINDEX(' ', street) - 1) AS left_name,
	RIGHT(street, LEN(street) - CHARINDEX(' ', street) +1) AS right_2
FROM sales.customers;

DataFrameas

df1

variable

SELECT COUNT(*) AS nulls
FROM sales.orders
WHERE shipped_date is NULL;