Hey guys Was wondering if someone could help me out with the following questions. I haven't got access to SQL Server where I'am and my SQL guy is on holidays. I was wondering if someone could be kind enough to answers the below by writing the code so I can run it Thanks guys!
1.Whats the count of purchases made on 12th January 2014. select count(*) from Purchase where purchase_day='2014-01-12' 2.Whats the deal title which was purchased on 12th January 2014. select d.deal_title from Deal d inner join Purchase p on d.dealid=p.dealid and p.purchase_day='2014-01-12' 3.Whats the city name and count of deals, where the city name starts with “Sydney”. select count(*) from deals where city_name like 'Sydney%' 4.Whats the deal_title and gross billings for every deal. select d.deal_title,p.grossbillings from Deal d inner join Purchase p on d.dealid=p.dealid