Database

SELECT DISTINCT serviceid,tcid,endtime,qos FROM (SELECT * FROM service ORDER BY serviceid, qos, id) AS base GROUP BY serviceid

WITH id AS (
    SELECT  serviceid,tcid,Min(EndTime) endtime,Min(Qos) qos
    FROM    service
    GROUP BY   serviceid,tcid
    )
SELECT  s.ServiceID,s.ID,s.TCID,s.EndTime,s.Qos
FROM    service s,id
WHERE   s.serviceid = id.serviceid
AND     s.tcid = id.tcid
AND     s.endtime = id.endtime
AND     s.qos = id.qos

SELECT * FROM (SELECT COUNT(TCID) as count, TCID, Month FROM (
    SELECT month(endtime) as Month, tcid, serviceid 
	FROM (SELECT MIN(Qos) qos, serviceid, id, TCID, EndTime from service
		GROUP BY serviceid
    	)T1
	WHERE qos = 1
	group by month(endTime),tcid, serviceid
    )As T
GROUP BY month, tcid) AS S
order by month, count DESC

count	TCID	Month
4	Andrew	1
3	Jacob	1
2	Tyler	1
2	Dylan	1
1	Daniel	1
4	Dylan	2
4	Jacob	2
4	Andrew	2
2	Tyler	2
1	Daniel	2

SELECT
   'Pharmarcy' AS Entity
  ,Pharmacy.Name AS Name
FROM
  Pharmacy
  INNER JOIN Place ON Place.Id = Pharmacy.PlaceId

UNION

SELECT
   'Hospital' AS Entity
  ,Hospital.Name AS Name
FROM
  Hospital
  INNER JOIN Place ON Place.Id = Hospital.PlaceId

SELECT
   Pharmacy.Name AS PharmacyName
  ,Hospital.Name AS HospitalName
FROM
  Place
  INNER JOIN Pharmacy ON Place.Id = Pharmacy.PlaceId
  INNER JOIN Hospital ON Place.Id = Hospital.PlaceId