CREATE TABLE Claims_Processing (Claim_Processing_ID NUMBER, Claim_ID NUMBER, Claim_Outcome_Code CHAR, Claim_Stage_ID NUMBER, Staff_ID NUMBER)
CREATE TABLE Policies (Policy_ID NUMBER, Customer_ID NUMBER, Policy_Type_Code CHAR, Start_Date DATETIME, End_Date DATETIME)
CREATE TABLE Staff (Staff_ID NUMBER, Staff_Details VARCHAR2)
CREATE TABLE Customers (Customer_ID NUMBER, Customer_Details VARCHAR2)
CREATE TABLE Claims_Documents (Claim_ID NUMBER, Document_Type_Code CHAR, Created_by_Staff_ID NUMBER, Created_Date NUMBER)
CREATE TABLE Claims_Processing_Stages (Claim_Stage_ID NUMBER, Next_Claim_Stage_ID NUMBER, Claim_Status_Name VARCHAR2, Claim_Status_Description VARCHAR2)
CREATE TABLE Claim_Headers (Claim_Header_ID NUMBER, Claim_Status_Code CHAR, Claim_Type_Code CHAR, Policy_ID NUMBER, Date_of_Claim DATETIME, Date_of_Settlement DATETIME, Amount_Claimed NUMBER, Amount_Piad NUMBER)

Find the number of records of each policy type and its type code. Visualize by bar chart.
SELECT Policy_Type_Code, COUNT(*) FROM Policies GROUP BY Policy_Type_Code
SELECT "Policy_Type_Code", COUNT(*) FROM "Policies" GROUP BY "Policy_Type_Code"