title: Need to write a query to show staff full name number of specialties and name the new column as specialties
body: <p>Write a query to show the staff full name, Number of specialties of all male with staff with more than one specialty.
  Name the new Column Num of Specialties. 
  Sort it by Staff Full Name</p>
  
  <pre><code>Table Describ
  SQL&gt; describ staff_speciality;
   Name                                      Null?    Type
   ----------------------------------------- -------- ----------------------------
   STAFFID                                   NOT NULL CHAR(2)
   SPECID                                             CHAR(4)
   DATEQUALIFIED                             NOT NULL DATE
   VALIDDATE                                          DATE
   DETAILS                                            VARCHAR2(100)
  
  SQL&gt; describ staff
   Name                                      Null?    Type
   ----------------------------------------- -------- ----------------------------
   STAFFID                                   NOT NULL CHAR(2)
   FIRSTNAME                                 NOT NULL VARCHAR2(20)
   LASTNAME                                  NOT NULL VARCHAR2(20)
   ROLE                                               VARCHAR2(15)
   GENDER                                             CHAR(1)
   DATEJOINED                                NOT NULL DATE
   DATELEFT                                           DATE
  
  
  COLUMN count(staffid) HEADING "Num of Specialities"
  SELECT firstname || ' '|| lastname "Staff Full Name",
  count(staffid) &gt; 1
  FROM staff, staff_speciality
  ORDER By Staff Full Name;
  
  
  COLUMN count(staffid) HEADING "Num of Specialities"
  SELECT firstname || ' '|| lastname "Staff Full Name",
  count(staffid) &gt; 1
  FROM staff, staff_speciality
  ORDER By Staff Full Name;
  
  Showing firstname and last name as Staff Full name
  than counting how many staff with more than 1 entry
  and sorting it by Staff Full name
  </code></pre>