/ ---
/ jupyter:
/   jupytext:
/     text_representation:
/       extension: .q
/       format_name: light
/       format_version: '1.5'
/       jupytext_version: 1.14.4
/   kernelspec:
/     display_name: SQL
/     language: sql
/     name: SQL
/ ---

/ + [markdown] azdata_cell_guid="a744b9cf-7c87-4d49-a36d-bcfe2261430e"
/ The following notebook runs through some sample queries against our development database to test the deployed SQL project:
/
/ 1. list customers
/     
/ 2. aggregate information about customers

/ + [markdown] azdata_cell_guid="1eba26f8-7aa0-4292-acdc-7e3cdb1d6cb6"
/ ## 0. Insert sample data

/ + azdata_cell_guid="5002fa50-ca7a-4baf-8ea1-5d7b78905c00"
insert into SalesLT.Customer (firstname, lastname,PasswordHash,passwordsalt)
select 'Someone', 'ThisPerson', 'hashforpassword', 'salt'
union select 'SomeoneElse', 'AnotherPerson', 'hashforpassword', 'moresalt'

/ + [markdown] azdata_cell_guid="b21362b3-42e3-4556-a1a8-e047d5f50dac"
/ ## 1\. List customers

/ + azdata_cell_guid="56d93d60-616c-48e0-99ce-d01befd88e35"
select * from SalesLT.Customer

/ + [markdown] azdata_cell_guid="550f9ca7-9619-4950-b5b9-b06af81f2d26"
/ ## 2\. Aggregate customer info
/
/ Should display All\_Customers: 2

/ + azdata_cell_guid="0ca515fd-e3e4-4751-a1e5-e80cb82c7a67"
select count(1) as All_Customers from SalesLT.Customer

StarcoderdataJupyterScriptsDedupFiltered