CREATE TABLE Order_Items (Order_Item_ID NUMBER, Order_ID NUMBER, Product_ID NUMBER, Order_Quantity VARCHAR2, Other_Item_Details VARCHAR2)
CREATE TABLE Invoices (Invoice_ID NUMBER, Order_ID NUMBER, payment_method_code CHAR, Product_ID NUMBER, Order_Quantity VARCHAR2, Other_Item_Details VARCHAR2, Order_Item_ID NUMBER)
CREATE TABLE Stores (Store_ID VARCHAR2, Address_ID NUMBER, Marketing_Region_Code CHAR, Store_Name VARCHAR2, Store_Phone VARCHAR2, Store_Email_Address VARCHAR2, Other_Details VARCHAR2)
CREATE TABLE Customer_Orders (Order_ID NUMBER, Customer_ID NUMBER, Store_ID NUMBER, Order_Date DATETIME, Planned_Delivery_Date DATETIME, Actual_Delivery_Date DATETIME, Other_Order_Details VARCHAR2)
CREATE TABLE Drama_Workshop_Groups (Workshop_Group_ID NUMBER, Address_ID NUMBER, Currency_Code CHAR, Marketing_Region_Code CHAR, Store_Name VARCHAR2, Store_Phone VARCHAR2, Store_Email_Address VARCHAR2, Other_Details VARCHAR2)
CREATE TABLE Bookings_Services (Order_ID NUMBER, Product_ID NUMBER)
CREATE TABLE Performers_in_Bookings (Order_ID NUMBER, Performer_ID NUMBER)
CREATE TABLE Invoice_Items (Invoice_Item_ID NUMBER, Invoice_ID NUMBER, Order_ID NUMBER, Order_Item_ID NUMBER, Product_ID NUMBER, Order_Quantity NUMBER, Other_Item_Details VARCHAR2)
CREATE TABLE Bookings (Booking_ID NUMBER, Customer_ID NUMBER, Workshop_Group_ID VARCHAR2, Status_Code CHAR, Store_ID NUMBER, Order_Date DATETIME, Planned_Delivery_Date DATETIME, Actual_Delivery_Date DATETIME, Other_Order_Details VARCHAR2)
CREATE TABLE Ref_Payment_Methods (payment_method_code CHAR, payment_method_description VARCHAR2)
CREATE TABLE Clients (Client_ID NUMBER, Address_ID NUMBER, Customer_Email_Address VARCHAR2, Customer_Name VARCHAR2, Customer_Phone VARCHAR2, Other_Details VARCHAR2)
CREATE TABLE Ref_Service_Types (Service_Type_Code CHAR, Parent_Service_Type_Code CHAR, Service_Type_Description VARCHAR2)
CREATE TABLE Addresses (Address_ID VARCHAR2, Line_1 VARCHAR2, Line_2 VARCHAR2, City_Town VARCHAR2, State_County VARCHAR2, Other_Details VARCHAR2)
CREATE TABLE Customers (Customer_ID VARCHAR2, Address_ID NUMBER, Customer_Name VARCHAR2, Customer_Phone VARCHAR2, Customer_Email_Address VARCHAR2, Other_Details VARCHAR2)
CREATE TABLE Performers (Performer_ID NUMBER, Address_ID NUMBER, Customer_Name VARCHAR2, Customer_Phone VARCHAR2, Customer_Email_Address VARCHAR2, Other_Details VARCHAR2)
CREATE TABLE Marketing_Regions (Marketing_Region_Code CHAR, Marketing_Region_Name VARCHAR2, Marketing_Region_Descriptrion VARCHAR2, Other_Details VARCHAR2)
CREATE TABLE Services (Service_ID NUMBER, Service_Type_Code CHAR, Workshop_Group_ID NUMBER, Product_Description VARCHAR2, Product_Name VARCHAR2, Product_Price NUMBER, Other_Product_Service_Details VARCHAR2)
CREATE TABLE Products (Product_ID VARCHAR2, Product_Name VARCHAR2, Product_Price NUMBER, Product_Description VARCHAR2, Other_Product_Service_Details VARCHAR2)

Which workshop groups have bookings with status code 'stop'? Give me the names, and count them by a pie chart
SELECT Store_Name, COUNT(Store_Name) FROM Bookings AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Workshop_Group_ID = T2.Workshop_Group_ID WHERE T1.Status_Code = "stop" GROUP BY Store_Name
SELECT "Store_Name", COUNT("Store_Name") FROM "Bookings" "T1" JOIN "Drama_Workshop_Groups" "T2" ON "T1"."Workshop_Group_ID" = "T2"."Workshop_Group_ID" WHERE "T1"."Status_Code" = "stop" GROUP BY "Store_Name"