Database

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