CREATE TABLE Services (Service_Type_Code VARCHAR2)
CREATE TABLE Ref_Service_Types (Service_Type_Description VARCHAR2, Service_Type_Code VARCHAR2)

What is the description, code and the corresponding count of each service type?
SELECT T1.Service_Type_Description, T2.Service_Type_Code, COUNT(*) FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code = T2.Service_Type_Code GROUP BY T2.Service_Type_Code
SELECT "T1"."Service_Type_Description", "T2"."Service_Type_Code", COUNT(*) FROM "Ref_Service_Types" "T1" JOIN "Services" "T2" ON "T1"."Service_Type_Code" = "T2"."Service_Type_Code" GROUP BY "T2"."Service_Type_Code"