#get_me.sql
#Replace 'Scobey' with 'your_name'
#---------------------------------
use u30
SELECT customer_id as id,
       salutation as sal,
       first_name as first,
       middle_initial as mid,
       last_name as last,
       gender as sex,
       email,
       login_name as username,
       login_password as password
FROM   as_Customer
WHERE  last_name='Scobey';

SELECT phone_number, address, town_city, county, country
FROM   as_Customer
WHERE  last_name='Scobey';

