CREATE TABLE Sales
(user_nbr INTEGER NOT NULL,
day_nbr INTEGER NOT NULL
CHECK(day_nbr BETWEEN 1 AND 365),
Value INTEGER NOT NULL
CHECK(value >= 0),
PRIMARY KEY (user_nbr, day_nbr));

INSERT INTO Sales
VALUES (1, 12, 60),
(1, 15, 70),
(1, 16, 80),
(1, 17, 83),
(1, 19, 86),
(1, 20, 90),
(1, 21, 90),
  
(2, 12, 80),
(2, 13, 70),
(2, 14, 70),
(2, 17, 50),
(2, 18, 60),
(2, 19, 70),
(2, 20, 80),
(2, 21, 0),

(3, 12, 70),
(3, 13, 60),
(3, 14, 50),
(3, 15, 60),
(3, 16, 60),
(3, 17, 65),
(3, 21, 65),  

(4, 1, 5),
(4, 2, 6),
(4, 3, 6),
(4, 4, 7),
(4, 5, 8),

(5, 1, 1),
(5, 2, 2),
(5, 3, 3);

Select    Distinct S1.user_nbr
From    Sales S1, Sales S2, Sales S3, Sales S4, Sales S5
Where   
        S1.user_nbr = S2.user_nbr
        AND
        S2.day_nbr = (Select MIN(day_nbr) From Sales Where user_nbr = S1.user_nbr AND day_nbr > S1.day_nbr)
        AND
        S1.user_nbr = S3.user_nbr
        AND
        S3.day_nbr = (Select MIN(day_nbr) From Sales Where user_nbr = S1.user_nbr AND day_nbr > S2.day_nbr)
        AND
        S1.user_nbr = S4.user_nbr
        AND
        S4.day_nbr = (Select MIN(day_nbr) From Sales Where user_nbr = S1.user_nbr AND day_nbr > S3.day_nbr)
        AND
        S1.user_nbr = S5.user_nbr
        AND
        S5.day_nbr = (Select MIN(day_nbr) From Sales Where user_nbr = S1.user_nbr AND day_nbr > S4.day_nbr)
    AND
        S1.Value < S2.Value
        AND
        S2.Value < S3.Value
        AND
        S3.Value < S4.Value
        AND
        S4.Value < S5.Value

Select S1.User_Nbr,COUNT(Distinct S1.Day_nbr) As DaySales
    From Sales S1
    Left Outer Join
        Sales S2
    On S1.user_Nbr=S2.User_nbr
Where S1.Value>S2.Value And S1.day_nbr>S2.Day_nbr
Group by S1.User_Nbr
Having count(distinct S1.Day_nbr)>5

/*Msalim 1: 435  Characters (no space)*/
SELECT DISTINCT user_nbr
  FROM (
          SELECT *,
                 (SELECT COUNT(*)
                    FROM Sales S5
                   WHERE S5.user_nbr = S1.user_nbr
                     AND S5.day_nbr <= S1.day_nbr) rn
            FROM Sales S1
       ) AS S1
 WHERE EXISTS (SELECT 1
                 FROM (
                         SELECT (SELECT COUNT(*)
                                   FROM Sales S2
                                  WHERE S2.user_nbr = S3.user_nbr
                                    AND S2.day_nbr <= S3.day_nbr) rn1,
                                (SELECT COUNT(*)
                                   FROM Sales S4
                                  WHERE S4.user_nbr = S3.user_nbr
                                    AND S4.value < S3.value) + 1 rn2, *
                           FROM sales s3
                     ) d
               WHERE D.user_nbr = S1.user_nbr
                 AND D.rn1 BETWEEN S1.rn
                               AND rn + 4
              HAVING COUNT(*) = 5
                 AND MAX(D.rn1 - D.rn2) = 0
            );

/*Msalim 2: 413 Chars*/
SELECT DISTINCT a.user_nbr
  FROM Sales A, Sales B, Sales C, Sales D, Sales E
 WHERE A.user_nbr = B.user_nbr
   AND B.user_nbr = C.user_nbr
   AND C.user_nbr = D.user_nbr
   AND D.user_nbr = E.user_nbr
   AND B.day_nbr > A.day_nbr
   AND C.day_nbr > B.day_nbr
   AND D.day_nbr > C.day_nbr
   AND E.day_nbr > D.day_nbr
   AND A.value < B.value
   AND B.value < C.value
   AND C.value < D.value
   AND D.value < E.value
   AND (SELECT COUNT(1)
          FROM sales
         WHERE user_nbr = a.user_nbr
           AND day_nbr BETWEEN a.day_nbr AND e.day_nbr) = 5;

/*Msalim 4: 238 Chars*/
SELECT DISTINCT user_nbr
  FROM Sales S
 WHERE (SELECT COUNT(*)
          FROM Sales D
         WHERE S.user_nbr = user_nbr
           AND S.day_nbr < day_nbr
           AND S.value < value
           AND NOT EXISTS
               (SELECT *
                  FROM Sales
                 WHERE user_nbr = S.user_nbr
                   AND day_nbr > S.day_nbr AND day_nbr < D.day_nbr
                   AND value <= S.value)) >= 5;