View and Select

Hi ,

Can someone help me with this Select statement and creating a VIEW. TIA!!!

1)display all entries in the stock table where the stock name starts with a C

2)create a view called manager_cash that contains the manager number and the total cash in portfolios managed by the manager.

      MANAGER
      Manager Manager
      Number   Name    Salary

      M1      Smith   45000.00
      M2      Brown   62500.00
      M3      Jones   43900.00


     STOCK
      Stock     Stock             Current
      Symbol    Name              Price

      JFM    Jetform              21.75
      JDS    JDS Fitel            20.55
      NTL    NorTel               54.10
      COS    Corel                 3.16
      MLT    Mitel Corp.          14.30
      CSN    Cognos               27.50
      RIM    Research In Motion   90.95


      PORTFOLIO
      Portfolio  Manager
      Number     Number   Cash

      P001        M2     25000
      P004        M3     10000
      P005        M2     50000
      P008        M3     37500
      P011        M3      8000


     HOLDING
      Portfolio Stock Purchase Number Purchase
      Number    Symbol  Date   Shares  Price

      P001    JFM    10-1-1998   300   19.55
      P004    NTL    10-2-1998   200   52.90
      P001    CSN    10-5-1998   150   29.90
      P005    MLT    10-6-1998   500   12.00
      P001    JFM    9-30-1998   300   19.30
      P008    COS    9-29-1998   800    4.50
      P008    CSN    9-29-1998   500   25.00
      P001    NTL    9-30-1998   250   56.40
      P005    COS    9-30-1998  1200    3.60
      P001    CSN    10-6-1998   250   29.75
      P001    COS    10-7-1998   200    3.50
      P001    JFM    10-2-1998   300   19.55
      P004    MLT    10-13-1998  200   12.20
      P005    MLT    10-13-1998  600   12.25
      P008    JDS    10-28-1998  610   21.50
      P008    JFM    10-14-1998  500   20.50