Beta
Table of Contents
The outline of your notebook will show up here. You can include headings in any text cell by starting a line with #
, ##
, ###
, etc., depending on the desired title hierarchy.
Unknown integration
DataFrameavailable as
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;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
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;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df1
variable
SELECT COUNT(*) AS nulls
FROM sales.orders
WHERE shipped_date is NULL;
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.