0001 select
0002 count(*) as total,
0003 count(ss_sold_date_sk) as not_null_total,
0004 count(distinct ss_sold_date_sk) as unique_days,
0005 max(ss_sold_date_sk) as max_ss_sold_date_sk,
0006 max(ss_sold_time_sk) as max_ss_sold_time_sk,
0007 max(ss_item_sk) as max_ss_item_sk,
0008 max(ss_customer_sk) as max_ss_customer_sk,
0009 max(ss_cdemo_sk) as max_ss_cdemo_sk,
0010 max(ss_hdemo_sk) as max_ss_hdemo_sk,
0011 max(ss_addr_sk) as max_ss_addr_sk,
0012 max(ss_store_sk) as max_ss_store_sk,
0013 max(ss_promo_sk) as max_ss_promo_sk
0014 from store_sales