agawronski

-- When did these orders occur ?
-- How many records are there?
-- How many orders are there?
select
min(duedate) as min_duedate,
max(duedate) as max_duedate,
count(*) as num_records,
count(distinct purchaseorderid) as num_orders
from purchasing.purchaseorderdetail;

agawronski

select *
from purchasing.productvendor
limit 10;

select *
from purchasing.purchaseorderdetail
limit 10;

select *
from purchasing.purchaseorderheader

agawronski

-- connect to the Adventureworks database
\c Adventureworks

-- view all tables in all schemas
\dt *.*

-- vew all tables in the purchasing schema
\dt purchasing.*