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)
CREATE TABLE Faculty_Participates_in (FacID NUMBER, actid NUMBER)
CREATE TABLE Faculty (FacID NUMBER, Lname VARCHAR2, Fname VARCHAR2, Rank VARCHAR2, Sex VARCHAR2, Phone NUMBER, Room VARCHAR2, Building VARCHAR2)

A bar chart showing the first name of all the faculty members who participated in some activity, together with the number of activities they participated in, display y-axis from low to high order.
SELECT Fname, COUNT(*) FROM Faculty AS T1 JOIN Faculty_Participates_in AS T2 ON T1.FacID = T2.FacID GROUP BY T1.FacID ORDER BY COUNT(*)
SELECT "Fname", COUNT(*) FROM "Faculty" "T1" JOIN "Faculty_Participates_in" "T2" ON "T1"."FacID" = "T2"."FacID" GROUP BY "T1"."FacID" ORDER BY COUNT(*)