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

Display a bar chart for how many faculty members participate in each activity? Return the activity names and the number of faculty members, and sort 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"