CREATE TABLE Faculty (FacID NUMBER, Lname VARCHAR2, Fname VARCHAR2, Rank VARCHAR2, Sex VARCHAR2, Phone NUMBER, Room VARCHAR2, Building VARCHAR2)
CREATE TABLE Faculty_Participates_in (FacID NUMBER, actid NUMBER)
CREATE TABLE Activity (actid NUMBER, activity_name VARCHAR2)
CREATE TABLE Participates_in (stuid NUMBER, actid NUMBER)
CREATE TABLE Student (StuID NUMBER, LName VARCHAR2, Fname VARCHAR2, Age NUMBER, Sex VARCHAR2, Major NUMBER, Advisor NUMBER, city_code VARCHAR2)

How many faculty members participate in each activity? Return the activity names and the number of faculty members Show bar chart, list in ascending by the x-axis.
SELECT activity_name, COUNT(*) FROM Activity AS T1 JOIN Faculty_Participates_in AS T2 ON T1.actid = T2.actid GROUP BY T1.actid ORDER BY activity_name
SELECT "activity_name", COUNT(*) FROM "Activity" "T1" JOIN "Faculty_Participates_in" "T2" ON "T1"."actid" = "T2"."actid" GROUP BY "T1"."actid" ORDER BY "activity_name"