--Main
       With Input1 As(
    
                              SELECT  distinct IE.Id AS EventId, IE.EventType AS EventType,IE.eventTime AS EventTime
                              FROM EventHub
                             ),
    
    
     agg AS (
        SELECT [day] = DATEPART(WEEKDAY, EventTime),
               count = Count(*)
        FROM InputEprismEvents IE
       
    )
    
    SELECT count
    INTO ServicebusQueue
    FROM agg
    WHERE CASE WHEN [day] in (1,7) and count < 10 THEN 1
               WHEN [day] in (2,3,4,5,6) and count > 10 THEN 1
               ELSE 0
          END = 1
      
    ---Output to the Power BI
                            SELECT EventTime,count(*) as Eventcount
                            INTO PowerBIOutput
                            FROM Input1
                            Group By EventTime, tumblingwindow(minute,5)