• nevermind i figured it out

    Declare @Julycount int

    Set @Julycount= (Select Count(*) From orders Where MONTH(OrderDate) = 7)

    print 'The total orders for july is ' + Cast(@JulyCount as varchar)