title: How can I create a view for my desired output
body: <p>What should I include in my view so that it outputs number of transactions in September for employee id 4:</p>
  <pre><code>SELECT * FROM DeniseTransactions;
  </code></pre>
  <p>gives the output:</p>
  <p><a href="https://i.stack.imgur.com/yuAYM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yuAYM.png" alt="enter image description here" /></a></p>
  <pre><code>  CREATE TABLE Transactions(
      e_id INT,
      c_id INT,
      l_id INT,
      date DATE,
      t_id INT,
      PRIMARY KEY(t_id),  
      FOREIGN KEY(c_id) references Customers(c_id),
      FOREIGN KEY(e_id) references Employees(e_id),
      FOREIGN KEY(l_id) references Locations(l_id)
      );
  
      INSERT INTO Transactions VALUES(1,3,1,'2021-08-09',1);
      INSERT INTO Transactions VALUES(4,2,2,'2021-08-14',2);
      INSERT INTO Transactions VALUES(4,4,1,'2021-09-07',3);
      INSERT INTO Transactions VALUES(3,4,1,'2021-09-07',4);
      INSERT INTO Transactions VALUES(4,1,3,'2021-09-07',5);
      INSERT INTO Transactions VALUES(1,4,1,'2021-09-23',6);
  </code></pre>
  <p>I know its incorrect but this is what i have so far. Just struggling to get further</p>
  <pre><code>CREATE VIEW DeniseTransactions AS
      SELECT COUNT(transactions)
      FROM Transactions
      WHERE e_id = '4';
  
  
  
  
    
  </code></pre>