search

ajlightbody / monday

0 stars 0 forks source link

source tweet using selenium #1

Open ajlightbody opened 6 years ago

ajlightbody commented 6 years ago

write script to pull a tweet using a webdriver

ajlightbody commented 6 years ago

Update comment

ajlightbody commented 6 years ago

Test to run:

with cte as ( select distinct count(distinct soh.customerid) as count_of_customers_ordered ,eomonth(soh.orderdate) as order_month from sales.SalesOrderHeader soh inner join sales.salesorderdetail sod on sod.SalesOrderID = soh.SalesOrderID inner join production.product p on sod.ProductID = p.ProductID where isnull(p.color, 'missing') in ('red', 'black', 'missing', 'blue', 'silver') group by eomonth(soh.orderdate) )

select sum(count_of_customers_ordered) ,year(order_month) from cte group by year(order_month)